… in memory where possible, do to it you should increase tmp_table_size to appropriate value and avoid using blob/text columns which force table… memory temporary table after which it will be converted to MyISAM. To make things more confusing this is not what you would read in MySQL…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… have seen cases where the tables had to be dropped more frequently (like every other hour), or when…the buffer pool mutex Try to force a context switch by advising the os to give up remainder of… 8G of memory and a software RAID5 array consisting of 4 disks. The version of MySQL used for benchmarking…
Post: The MySQL optimizer, the OS cache, and sequential versus random I/O
April 28, 2008 By 17 Comments
… MySQL doesn’t want to choose this join order, so we’ll force …memory, in the OS cache. (They don’t get evicted from memory by the cache’s LRU policy, because they are frequently used…MySQL optimizer were right and each of these had to go to disk, our STRAIGHT_JOIN plan would take more than a month to…
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 31 Comments
…What if we leave MySQL no choice but only to use combined index: mysql [localhost] {msandbox} (test) >…MySQL which would allow forcing using index merge when MySQL does not think it should be used….memory workload. For UNION case the optimizer is more advanced and it is able to deal with ranges: mysql…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…to see more configuration options to adjust database behavior to…to use itself. At this point I have not seen auto-configuration algorithms to be able to…MySQL anyway though). Very interesting to see how this one will compare to… have enough memory to hold all …be forced to rewrite them to commit often….
Post: Building Indexes by Sorting In Innodb (AKA Fast Index Creation)
June 19, 2012 By 2 Comments
…memory and large uncorrelated indexes you might be looking at 10x difference or more. Yet for some reason Innodb team has chosen to use…to MySQL 5.5 promptly, yet it has not happen to…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
…MySQL 5.0 and 5.1. Building this list was not really a scientific process – It’s always difficult to… will lead to more work when checkpoints are eventually forced at the end …memory data dictionary (which is unlimited in size).  XtraDB introduces a patch to be able to control this, which is useful…
Comment: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
…this case, Mysql) – think about memory settings, …the force is…to analyse the output more. Sort of autotrace command in Oracle. This is to me vital if you want to make the cross to…use this mantra to stop the everlasting : ” “it’s the database server†to “it’s the RAID controller†to…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…to the database latency. To give you more information, this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql…memory: [root@dom*************** log]# free -m total used…
Post: Innodb Recovery - Is large buffer pool always better ?
July 17, 2007 By 3 Comments
…to help with Innodb crash recovery on box with large amount of memory (64GB) with Innodb Buffer pool configured to…forced to scan good portion of it finding place to insert the page. So I took a shot at restarting MySQL…to happen with all recoveries out where as 20GB buffer pool is not way more…is used…
