…MySQL manual, especially the …innodb_additional_mem_pool_sizeblogpercona.commanual innodb_autoextend_incrementblogpercona.commanual innodb_autoinc_lock_modeblogpercona.commanual innodb_buffer_pool_instancesblogpercona.commanual Innodb_buffer_pool_pages_datablogpercona.commanual Innodb_buffer_pool…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…actually promise to fit within innodb_additional_mem_pool_size, by the way. If it needs more it will allocate it. innodb_additional_mem_pool_size is just a … 1024 * 100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) | +—————–+ | …
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb innodb_additional_mem_pool_size=32M innodb…
Comment: MySQL Connection Timeouts
January 24, 2013 By 4 Comments
… #*** INNODB Specific options *** innodb_data_home_dir=”D:/work/MySQL Datafiles/” innodb_additional_mem_pool_size=7M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=3499k innodb_buffer_pool_size=339M innodb_log_file_size=50M innodb_thread_concurrency…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…size=256K #*** INNODB Specific options *** innodb_additional_mem_pool_size=20M innodb_flush_log_at_trx_commit=0 innodb_log_buffer_size=4M innodb_buffer_pool_size=304M innodb_log_file_size=152M innodb…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
… /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format…size=1M sort_buffer_size=203K innodb_additional_mem_pool_size=2M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=200M innodb_log_file_size=10M innodb…
Comment: What to tune in MySQL Server after installation
June 29, 2009 By 118 Comments
…Anyone suggest me how to increase the performance of my MYSQL server. Day by day the number of slow queries …buffer_size=1M sort_buffer_size=203K innodb_additional_mem_pool_size=2M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=200M innodb_log_file_size=10M innodb…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… to match the client’s version of MySQL; they are very careful about upgrades. …innodb_additional_mem_pool_size 2097152 innodb_autoextend_increment 8 innodb_autoinc_lock_mode 1 innodb_buffer_pool_size 55050240000 innodb_change_buffering inserts innodb_checksums ON innodb_commit_concurrency 0 innodb…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb_plugin.innodb…pool stats, the I/O stats might be slightly smaller than they should be. ==9090== Possible data race during write of size…Additionally, I’d consider backporting and using MySQL…
