iciency 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 arch
e to
redirect part of the queries to the master =)
bye,
Ben.
*****
Benjamin KRIEF * Directeur Technique * IGUANE Studio
Tel:01.56.55.54.20 * 5-7-9 passage des Cloys
Fax:01.56.55.54.24* 7
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 ver
ct the sql requests on the slave or on the master , but this
time , i could fine tune it , and input 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,
*
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 Slow
Y (id);
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 i
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 s
