Can you send us a copy of your my.cnf at the moment.
Also, if you can provide some reports that will help us determine the best
functionality, that would also help a lot. It is useful to know what is
getting read/writing (or which function is being requested the most...).
Table format is also impo
]
Sent: Friday, June 11, 2004 7:45 AM
To: [EMAIL PROTECTED]
Subject: Re: Server optimization issue
"Misao" <[EMAIL PROTECTED]> wrote:
Take a deep look at
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
But ensure that this is MySQL who takes so much memory. Watch othe
A few pointers:
Almost every time, the issue is queries that need optimization. Figure out
which queries are happening at the slow times and look those over
carefully. I cannot count how many times I was asked to throw hardware at
an issue related to MySQL which was really related to bad quer
"Misao" <[EMAIL PROTECTED]> wrote:
Take a deep look at http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
But ensure that this is MySQL who takes so much memory. Watch other variables
like key_buffer. MySQL probably should not take that much memory if these are
the only variables spec
Misao wrote:
I have 4 MySQL 4.0.16 servers, all with Dual 3ghz Xeons and 4GB of RAM.
They use InnoDB for all tables, and the ibdata file is 70GB.
The DBs seem to be a little slow, and the darn thing is always using a huge
chunk of swap. I've tried increasing and decreasing what it's allowed to
use,
