I have an update operation where I am able to update 10 million records in
approx
2.5 mins.
But when I tried to do the same update on say 40-50 million records, mysql
takes forever to finish. Its the same table, and same update operation, i am
just changing the range of ids using where claus
>Also, when a query takes too long I kill it by shutting down the
server, is this safe or is there a better alternative (MyISAM tables)?
Use show processlist to see the query that taking more time and use "
kill ; " for terminating the query .
--
Praj
Surendra Singhi wrote:
Hello Chris,
C
Hello Chris,
Chris <[EMAIL PROTECTED]> writes:
> Surendra Singhi wrote:
>> I am using mySQL 5.0 and I have 2 tables with few hundred millions of
>> records. To optimize things, I am using MyISAM tables, using the
>> smallest possible data
>> type and have set indexes.
>> Now, the problem which
Surendra Singhi wrote:
Hi,
I am using mySQL 5.0 and I have 2 tables with few hundred millions of
records.
To optimize things, I am using MyISAM tables, using the smallest possible data
type and have set indexes.
Now, the problem which I am facing is that mySql process is wasting lot of
time
Hi,
I am using mySQL 5.0 and I have 2 tables with few hundred millions of
records.
To optimize things, I am using MyISAM tables, using the smallest possible data
type and have set indexes.
Now, the problem which I am facing is that mySql process is wasting lot of
time in disk access the CPU an
Hi All,
Our current setup has the mysql server and the client app run on the
same host. We are using mysql++ (ports/mysql++-1.7.9) for the database
client api. The application returns huge data sets in the order of 50K. When
we do a show processlist most of the threads spend their time in th
Thanks, I changed the permissions, restarted, and everything is working
great now. Thanks a lot.
> Shaun wrote:
> > Thanks for your help Dathan, I will make the required changes. I just
have
> > one other problem.
> >
> > I'm not sure what queries don't use an index. I've attmepted to turn on
Shaun wrote:
Thanks for your help Dathan, I will make the required changes. I just have
one other problem.
I'm not sure what queries don't use an index. I've attmepted to turn on the
slow-queries-log, but nothing ever shows up in the file. Here's what I have
in the my.cnf
[mysqld]
skip-locking
se
Thanks for your help Dathan, I will make the required changes. I just have
one other problem.
I'm not sure what queries don't use an index. I've attmepted to turn on the
slow-queries-log, but nothing ever shows up in the file. Here's what I have
in the my.cnf
[mysqld]
skip-locking
set-variable
Shaun wrote:
Hello,
I was wondering if a more knowledgeable person could help me out with my
configuration and let me know how I could further optimize MySQL. Here's the
hardware on my dedicated server:
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) 4 CPU 2.40GHz
Process
ECTED]
> Sent: Thursday, November 18, 2004 10:56 AM
> To: [EMAIL PROTECTED]
> Subject: Optimizing MySQL
>
> Hello,
>
> I was wondering if a more knowledgeable person could help me out with my
> configuration and let me know how I could further optimize MySQL. Here's
>
Hello,
I was wondering if a more knowledgeable person could help me out with my
configuration and let me know how I could further optimize MySQL. Here's the
hardware on my dedicated server:
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) 4 CPU 2.40GHz
Processor #1 speed
Joseph,
How big your table files are? Are they MyISAM or Innodb ? Do you have
indexes? How much memory do you have? Is your MySQL running on a
dedicated server or do you run anything else on your db server?
This questions needs to be answered before suggesting anything logical.
But general sugges
Group,
I have been working with Mysql for about 5 years - mainly in LAMP shops. The
tables have been between 20-100 thousand records size. Now I have a project
where the tables are in the millions of records.
This is very new to me and I am noticing that my queries are really
sloww!
What ar
On Tue, Jan 22, 2002 at 10:12:55AM -0600, Solsberry, Glendon wrote:
> I have mySQL v3.23 running on a Mandrake 8.1 box (AMD 1600XP, 512MB
> RAM). The problem is that the main query (listed below) takes
> approximately 3 hours to run.
[snip]
Wow! Thanks for all the detail.
> The query is this
I have mySQL v3.23 running on a Mandrake 8.1 box (AMD 1600XP, 512MB
RAM).
The problem is that the main query (listed below) takes approximately 3
hours to run.
my.cnf looks like:
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=128M
You need to set the max_connections variable like this in the my.cnf
file:
set-variable = max_connections=250
-- Jason
On Thu, 2001-12-27 at 11:38, Kim Albee wrote:
> We are trying to optimize mySQL. Right now, the max_connections is set to
> 100. We are only able to open 99 concurrent co
On Thu, Dec 27, 2001 at 10:38:42AM -0600, Kim Albee wrote:
> We are trying to optimize mySQL. Right now, the max_connections is set to
> 100. We are only able to open 99 concurrent connections to the db, and even
> then, some requests are unable to get a connection. We'd like to be able to
> sc
We are trying to optimize mySQL. Right now, the max_connections is set to
100. We are only able to open 99 concurrent connections to the db, and even
then, some requests are unable to get a connection. We'd like to be able to
scale that up, but mySQL doesn't like what we've done, as it won't st
> I have used optimize table on several tables however it has not
> affected the
> speed of the queries or the large amount of processor resources that are
> being used.
>
> Have you heard of a way to rebuild a table more efficiently?
Go back and do this:
myisamchk -o *MYI
myisamchk -a *MYI
myisa
I'm not an expert, but I've never heard of a db getting slower after an
index rebuild. It's possible that's just a red herring.
You've been speaking generally about things being slower, I'd suggest you
get specific. Track down the queries are slow now, use EXPLAIN on them to
see what indexes
]]
Sent: Tuesday, June 26, 2001 11:33 AM
To: Mysql
Cc: "Michael Blood"
Subject: Re: Optimizing MySQL
> Recently the index files became corrupted and I ran the
> myisamchk *.MYI -r -S to repair them.
Try an OPTIMIZE TABLE or ANALYZE TABLE. Your queries may be using the
incorrect i
> Recently the index files became corrupted and I ran the
> myisamchk *.MYI -r -S to repair them.
Try an OPTIMIZE TABLE or ANALYZE TABLE. Your queries may be using the
incorrect indexes since the statistics have not been updated.
You can also do this: myisamchk *.MYI -a
Sincerely,
Steven Rouss
I have a MySQL myISAM database that has about 300 MB of information.
Recently the index files became corrupted and I ran the myisamchk
*.MYI -r -S to repair them.
Ever since then mySQLd process has been using up a ton of processor time.
And some of the queries that I run have started taking a lon
Hi all,
I have been using Mysql to power my online database search engine(CGI). IT contains
more than 500K rows of records(12 columns).
Is there a trick to optimize Mysql Table( by using Index , temporary table??) so that
the search engine could get the result in
shorter time?
Should I conside
25 matches
Mail list logo
