… escalate MyISAM scalability question. This time working on the customer system we figured out that box with 1 CPU Core is able… results for MyISAM using MySQL 5.0.45 run on 4 Core System: Threads queries/sec 1 161 2 107 4 110 8 121… lookups) but its scalability is not perfect giving less than 2x in peak which happens to be at 4 concurrent threads. So…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…it the current performance, future performance, scalability, ability to recover from disasters?… KB physical id : 1 siblings : 4 core id : 3 cpu cores : 4 fpu : yes fpu_exception :…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
MySQL 5.5 and Percona Server 5.5 do not solve all scalability problems even for read only workloads. Workloads which got… system I used for test was 4 socket r910 with X7542 CPUs giving 24 real cores. The workload was completely in memory… peak performance on system with 12 physical cores and 24 threads, which is almost perfect scalability. So there are workloads where the…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… current MySQL 5.0 I still see Innodb having serious scalability problems in some environments with 4+ cores so it is still important. IO Scalability patches Mark Callaghan from Google released so many MySQL…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… to execute and we have 16 core system with hard drive which can … as well as inevitable application specific scalability restrictions, such as row level locks. … a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat … Rows sent 7.15M 0 56.36k 4.19 0.99 360.95 0.99 …
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
…’s seriously limiting MySQL in core use cases (links: part 1, 2, 3). This post is about the way MySQL handles connections, allocating… lock-out or waiting, and the specific implementation has a scalability bottleneck on multicore servers. Mark Callaghan has done much more…’t be a great OLTP web database too. MySQL replication is one of the core, fundamental features — and it’s single-threaded…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
…some mathematical modeling of InnoDB’s scalability as the number of cores in the server increases. Vadim …the same core counts and with sysbench on another machine, instead of taking 12 cores away from MySQL … ago, when you could “upgrade” from 4 to 8 cores and see a reduction in throughput. Oracle…
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
…is something on a way. Same site publishes Core vs K8 architecture comparison which is very interesting… Pro/Pentium II but it failed for Pentium 4. Performance per clock cycle could be 1….has very interesting observation on MySQL Multiple CPU scalability . As you can see MySQL could be slower on …
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 20 Comments
… | mysql -h 10.2.2.129 -u root dbt2 sleep 120 ./run_mysql.sh -h 10.2.2.129 -u root -c 4… | mysql -h 10.2.2.129 -u root dbt2 sleep 120 ./run_mysql.sh -h 10.2.2.129 -u root -c 4… the same scalability issues affects actives connections although these are also affected by concurrency issues. With new servers having 24+ cores, this…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
…. MySQL 5.1 is 4% slower than MySQL 5.0 with two cores and just 2% slower with 8 cores, thus showing a bit better scalability. MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores and about 6% slower with 8 cores, meaning regression from plugin increases with number of cores. If…
