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 mr.crip...@gmail.com 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

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