mysql memory usage

is 99.54%. maybe it has something to do with the database files size? bye. * Benjamin KRIEF * Directeur Technique * IGUANE Studio * -- MySQL General Mailing List For list archives: http

Re: replication redirector

. * Benjamin KRIEF * Directeur Technique * IGUANE Studio Tel:01.56.55.54.20 * 5-7-9 passage des Cloys Fax:01.56.55.54.24* 75018 PARIS Gsm:06.12.56.50.41 * mailto:[EMAIL PROTECTED

Re: replication redirector

hi , and thanks for your answer, On Mon, Oct 20, 2003 at 07:03:37PM +0200, Benjamin KRIEF wrote: the problem is that it's quite impossible to fine tune the load between the servers , and my slave is a bit too busy , so the replication thread is becoming very slow , and sometimes , i can see

replication redirector

for instance 0,3 for the slave , so that 3 requests out of 10 would go to the slave. maybe stg similar already exists ? thanks for your attention, * Benjamin KRIEF * Directeur Technique * IGUANE Studio Tel:01.56.55.54.20 * 5-7-9 passage

spaces in index name

hi all , i'm trying to improve performance of a quite big and heavily used mysql set of tables. i want to create some indexes on this table , but before this , i'd like to remove the ones created by my predecessor , which are sometimes duplicate , and somtimes useless. here is an output from

Re: spaces in index name

); Hope that helps. Matt - Original Message - From: Benjamin KRIEF Sent: Sunday, August 31, 2003 7:40 PM Subject: spaces in index name hi all , i'm trying to improve performance of a quite big and heavily used mysql set of tables. i want to create some indexes on this table

optimization headaches.

hi all , and thanx for your help on my weird_indexes problem. no that i've created the indexes , the things are going a bit better but it's still not so fast : here's some output from mytop : - Queries Total: 442,666Avg/Sec: 7.74 Now/Sec: 16.27