…this case of CPU-bound benchmark. First stage – load data. Scripts for multi-table sysbench allow…=0 –rand-type=uniform –max-time=1800 –mysql-user=root –report-interval=10 run this… tables CPU utilization is 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… cores effectively (which would correspond to single CPU socket these days) Here are some more details….get_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::general_fetch,handler::read _multi_range_next,… a lot worse in this workload and innodb_adaptive_hash_index_partitions=16 available for …
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
…/local/mysqltest/mysql- –with-innodb and next startup options were used: libexec/mysqld –no-defaults –user=root –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb… bug 15815 as the same such queries were affected on multi-CPU systems. Used hardware: CentOS release 4.4 (Final) 2 Ñ…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… MySQL – Innodb. Innodb Storage Engine was covered in a lot of talks, many of them done by Innodb … cores becomes increasingly important as their number per CPU just keeps doubling. It is also rather… for full statement duration. The problem with multi value inserts however is the following – even…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…unlock_tables’, ’102′ ‘Com_update’, ’15146253′ ‘Com_update_multi‘, ’0′ ‘Connections’, ’263413′ ‘Created_tmp_disk_tables’,…2 running, 0 zombie, 0 stopped CPU states: cpu user nice system irq softirq …innodb_log_group_home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… cpu MHz : 1995.004 cache size : 4096 KB 16GB of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql… fixed, as this is specific Falcon’s way to handle multi-versioning. I think this is a big weakness of Falcon…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
…of combination such as running multi-table update joining PBXT and Innodb tables. Operations Things like…we have a version of MySQL Server which drops everything but Innodb Storage engine (it could …CPU cycles by having storage format same as processing format. We could tune Optimizer to handle Innodb…
Comment: Bug fix of InnoDB scalability problem
November 15, 2006 By 13 Comments
James, The way how Innodb does locking and appropriate code is very close in all MySQL versions, so it is not the…, attaching it to multi core CPUs is nothing else but a trick to hide complete failure of MySQL/Innodb fixing this bug which… even before joining MySQL which is 5 years ago. Number of CPUs however does matter – the effect with large CPU numbers changes…
Post: New patches, new builds
September 5, 2008 By 24 Comments
… benchmark is not so scalable on multi-cpu. Most important patch “split_buf_pool_mutex” to separate InnoDB buffer->pool mutex into several…-in InnoDB plugin, so there is no more needs to download InnoDB separately, install it and run mysql with option –skip-innodb. We think InnoDB plugin is stable enough to use it with MySQL 5…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… a series of blog posts on MySQL‘s unsolved severe limitations. I …get more and more CPUs and CPU cores. The replication replay process … common cases will require use of InnoDB with the proper transaction isolation level, …currently does, and only enable the multi-threaded behavior if the user …
