… 2008 Igor Chernyshev of eBay implemented true-VARCHAR support for MEMORY tables for MySQL 5.0. Although this patch did not add the… performance-critical application depending on MEMORY tables, they are no replacement for application-specific tests. We start by checking if there is any performance…
Post: Performance gotcha of MySQL memory tables
February 1, 2008 By 5 Comments
One performance gotcha with MEMORY tables you might know about comes from the fact it is the only MySQL storage engine which defaults to… comes from the fact MEMORY tables use HASH indexes by default. I’ve created rather similar test table: CREATE TABLE `test` ( `id` int(11… writes and do all the changes directly in memory. MyISAM however had to perform number of random writes to the key file…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…TABLE performance with fast index creation and without it with different buffer pool sizes. Results are pretty interesting. I used modified Sysbench table…table which would look as following in terms of data and index size: mysql> show table… also offers better performance for in memory case, even …
Post: Drop table performance
April 20, 2011 By 22 Comments
… about DROP TABLE performance in InnoDB. (You can refer to Peter’s post http://www.mysqlperformanceblog.com/2011/02/03/performance-problem-with-innodb-and-drop-table/ and these bug reports: http://bugs.mysql.com/bug.php?id=51325 and http://bugs.mysql… pool: The more memory used, the slower DROP TABLE operates. MySQL 5.6.2 shows some improvement compared to MySQL 5.1.56, but…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…| 20 | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON…4MB instead of 1MB now allowing MySQL to handle larger queries. Makes sense as amount of memory available is much larger …
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO …for innodb_buffer_pool which with other memory needs leaves roughly 1GB for OS Cache…TABLE on this table which essentially performs data and indexes scan which will be reflective to large full table…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
…) benchmark so data was well fitting in memory and Read Only one to simplify … –test=oltp –mysql-socket=/tmp/mysql_sandbox5610.sock –mysql-user=msandbox_rw –mysql-password=msandbox –oltp-table-size=1000000…thread MySQL 5.5 is 11% faster than MySQL 5.6. If you disable Performance Schema in MySQL…
Post: How Much memory do you use to run MySQL
November 2, 2012 By 8 Comments
We have seen number of issues with MySQL Server related to amount of memory you have in the system – these range from problems with large size Query Cache to bad drop table performance with large Innodb Buffer Pool size. As such I wonder how much memory do we really use to run MySQL Server…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… temporary tables performance to avoid OS writes OS Write cache is not as efficient as I would hope, at least on Linux Performance… in memory MEMORY temporary tables can be 10-100 times faster than disk based MyISAM tables Hopefully MySQL will implement support of dynamic rows for MEMORY tables…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…row to lookup up a row in another table based on a text field ( called email address )…. this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions like… in memory. let’s look at the 1GB Setting: What, a performance regression? But we threw more memory at …
