… to be extra careful working with large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL… to avoid it. Joins to smaller tables is OK but you might want to preload them to memory before join so there is no random IO needed to populate the caches. With proper application architecture and table design…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… have some tables in MyISAM format in “mysql” database. Plus HEAP/MEMORY tables are used for temporary tables which may …to the table. Works with table locks so again practically applies to MYISAM and MEMORY tables. preload_buffer_size – Buffer used for Key preloading, which works for MYISAM tables…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to…commanual port_open_timeoutblogpercona.commanual preload_buffer_sizeblogpercona.commanual Prepared_… shared_memoryblogpercona.commanual shared_memory_base_nameblogpercona.commanual show_…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…to take care of or which may seriously affect MySQL Performance. MyISAM Corruption – If you’re writting to MyISAM tables…tables at onces, which typically make system extremely slow and also can use up all allowed connections or run out of memory… Full table scan queries allow to preload table data …
Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)
December 22, 2011 By 5 Comments
…to even attempt to create 30,000 tables in InnoDB. That time is now a memory. We have customers with a lot more tables…to get performance. The simplest way is to use libeatmydata. This is a small shared library designed to be LD_PRELOADed… test to run (even with –big-test option to mysql-test-run) …
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
…memory footprint under the control. In this post I’m going to check impact of several memory allocators on the performance/scalability of MySQL… Percona server either with LD_PRELOAD=[allocator_lib.so] or glibc…should be taken into account – memory footprint. table { width: 80%; margin: 0; background:…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
…. There is reported bug http://bugs.mysql.com/bug.php?id=29847, with ETA MySQL-6.0 Preload table / index into buffer_pool. You can use custom queries by primary / secondary key to “warm up” part of table… and memory on servers they become critical. I do not know what is InnoDB plans about it and would like to hear…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…available in MySQL 5.6 which I thought was worth sharing to give …Memory Fragmentation – Reduced Locking for Partitioned tables – Reduced Contention for LOCK_open – Support for multiple table_…- Fast Restart – Preloading Innodb Buffer Pool – Online DDL – Import/Export for Partitioned Tables – Remote …
Comment: Beware of MyISAM Key Cache mutex contention
August 14, 2008 By 10 Comments
…to see what our problem is? Thanks a lot! The cpu of hardware is 2.2 GHz, and the memory…Table | Op | Msg_type | Msg_text | +————+————–+———-+———-+ | lps.user_1 | preload_keys | status | OK | | lps.user_2 | preload_keys | status | OK | | lps.user_3 | preload…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…_master_data’, ’0′ ‘Com_load_master_table‘, ’0′ ‘Com_lock_tables‘, ’102′ ‘Com_optimize’, ’0′ ‘Com_preload_keys’, ’0′ ‘Com_prepare_sql’, ’0…/mysql innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL…
