…rows: +———————-+———-+ | Status | Duration | +———————-+———-+ | starting | 0.000075 | | checking permissions | 0.000004 | | checking permissions | 0.000004 | | Opening tables… of the cache and degrade performance for other queries. The…
Post: Living with backups
November 6, 2008 By 28 Comments
… into slower queries execution and significantly degraded performance. Anything else? All modern systems usually … this is especially true for MyISAM tables which have dedicated buffers only to store…Threads_connected”‘); … if ($$row[1] < 10) { $is_running= 1; } if ($$row[1] > 50) { $is_running= 0; …
Post: Redundant index is not always bad
August 28, 2007 By 7 Comments
… is case when for performance it would be good to have both Let we have the table CREATE TABLE `userinfo` ( `id` int(10… the index, and there is no need to read row data from the table. So – we can extend index `state_id_idx… memory to fit only one index, that shows how can degrade performance if we balance on memory limits) If you are interested…
Comment: Using CHAR keys for joins, how much is the overhead ?
June 19, 2007 By 18 Comments
…columns while this is more understandable as row size is increased significantly in this …4 seconds for Innodb tables. Using VARBINARY instead gave about same performance. Yet another trick I…varchar join tests for Innodb table with utf8 encoding. This caused some degradation slowing down join speed…
