… MyISAM tables in case of MySQL/System crash is painful and great to be avoided. Long primary key – …slow as it is quite fragmented. Table however is not getting any table scans just single row lookups by primary key… to keep system flexible so if we want add more thumbnail sizes we would not need to …
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…to execute queries or make operation to swap seriously slowing down. On now legacy 32bit platforms you …_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache…run some queries. There can be mutiple key caches. Multiple key caches can be created to accomodate …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…is doing, in terms of performance. There are two key commands for this on most operating systems (there …be an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might …client After the slow query log analysis is done, I format all my analysis for sending, add in things …
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…pas part of second key as PRIMARY key is appended to it internally anyway. For MyISAM table you should…would be primary key but it also can slow down your inserts and make primary key significantly fragmented. I…about hard limit of indexes I prefer to add indexes only in cases which provides positive …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…1 | 8 | | QUERY_CACHE_SIZE | 0 | 1048576 | | SLOW_QUERY_LOG_FILE | /mnt/data/sandboxes…to create Innodb table but getting MyISAM because Innodb was disabled for some…in my opinion. MySQL 5.6 adds a lot more optimizer switches …on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=…
