May 25, 2012

Post: Heikki Tuuri Innodb answers - Part I

slows down throughput. If we could control the checkpointing rate we could use an 8G write ahead log and tell innodbINSERT with multiple values? We build up INSERTS on our clients and insert values 50 or so at a time. HT: For most users, group

Comment: MySQL Server Memory Usage

downinsert‘, ’17889656′ ‘Com_insertSlow_launch_threads’, ’0′ ‘Slow_queries’, ’27405′ ‘Sort_merge_passes’, ’376′ ‘Sort_range’, ’56479689′ ‘Sort_rows’, ’1344092495′ ‘Sortinnodb_log_group_home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb