Pruning the slow_log Table

Hi, I've enabled slow query logging to the mysql.slow_log table, like this: log_output = TABLE general_log = 0 slow_query_log = 1 long_query_time = 5 I'm getting queries in the mysql.slow_log table now, which is awesome. But my question is this: how does one "prune" that log file, without doin

Re: mysql4 query cache pruning unnecessarily?

The tables certainly get updated and therefore those queries should be ejected from the cache, but it's not a memory issue. Does that mean that Qcache_lowmem_prunes is actually the sum of low memory prunes and dirty queries? The manual doesn't seem to suggest this, so it would be cool if someone co

Re: mysql4 query cache pruning unnecessarily?

LS <[EMAIL PROTECTED]> writes: > Hi- > Can anyone tell me why mysql4 would prune queries from the cache if the > Qcache_free_memory is still very big? I'm confused why we get so many > Qcache_lowmem_prunes: Mysql will prune queries if the tables are updated, maybe this is what you are experienc

mysql4 query cache pruning unnecessarily?

Hi- Can anyone tell me why mysql4 would prune queries from the cache if the Qcache_free_memory is still very big? I'm confused why we get so many Qcache_lowmem_prunes: | Qcache_queries_in_cache | 175011 | | Qcache_inserts | 343244 | | Qcache_hits | 4041221| |

pruning

Vijay, Friday, March 22, 2002, 1:00:24 PM, you wrote: V> I have to delete the unwanted things from my mysql db Use DELETE statement. You can find description of it in the manual: http://www.mysql.com/doc/D/E/DELETE.html V> thanks V> vijayt -- For technical support contracts, goto

pruning

Placed At : MAA Vijay T@SATYAM 03/22/2002 04:30 PM Hi I have to delete the unwanted things from my mysql db pls sugges me to go ahead thanks vijayt - Before posting, pl