… swap space) like crazy. Why ? Because by default mysql_query uses mysql_store_result C library call and buffers all result set in…. Note this limit is not controlled by memory_limit PHP config variable because that only controls memory which passes via PHP memory management which does not apply to MySQL result set. OK there…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…. The table is CREATE TABLE `c` ( `tracker_id` int(10) unsigned NOT …| +—————————+ 1 row in set (2 min 8.92 sec) mysql> SHOW STATUS LIKE ‘Innodb_scan_pages%’; +——————————+——-+ | Variable_name | … key, and you cannot really control it (tough it is possible in …
