Re: sync_binlog=0 affects MySQL performance but sync_binlog=1 works well

2012-11-28 Thread Reindl Harald
Am 29.11.2012 03:29, schrieb Dehua Yang: > Finally , when the sync_binlog=0 , the commit statement disappear in the > slow.log in the subject you say exactly the opposite and if something disappears in the slow.log it is good - so how should we help? signature.asc Description: OpenPGP digi

Re: Still struggling witn like 'CTV%' over varchar.... I simple cannot understand..

2012-11-28 Thread Johan De Meersman
- Original Message - > From: "Andrés Tello" > > showed the usage of the index, then, some time later, it show, for > the same query, the usage of no index... Look at the "rows" field. It's obvious that this table is live and rather on the active side; and the data has changed in such a