… of RAM which we used for testing. Even though box had 8 cores it is little use for MySQL as only one query….720.93 As you can see on 100G data set MySQL 5.1 could only complete 10 out of 22 queries within… for MySQL because CPUs just continue to add more cores. Having 2 CPUs and being able to use only half of system CPU…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow it to… Platform | Linux Release | Ubuntu 12.04.1 LTS (precise) Kernel | 3.2.0-35-generic Architecture | CPU = 64-bit, OS = 64-bit… would be in the production over time: mysql> show table status like “post_channel” \G *************************** 1. row *************************** Name: post_channel Engine: InnoDB…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… requires that you use row-based binary logs (RBR). If you don’t have MySQL 5.1 or aren’t using RBR, then it is possible to set up a dedicated MySQL slave which has log_slave_updates=1… to maintain materialized views. Most database servers have some spare CPU for binary log parsing. Run the setup script: This will…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not very recent… this patch we only use this patch not full patch set in testing. MySQL 5.1 is 4% slower than MySQL 5.0 with… interesting to see the corellation between CPU usage and performance. We can see Plugin uses less CPU with 8 cores and has less…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
…. So, my problems are, the mysql process always use 1 cpu core at 1 time and it used 100% of the cpu resource. I’am not sure… total, 276k used, 4096256k free, 6326856k cached PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND 11395 mysql 16 0…/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package) old_passwords=1…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…(R) CPU 5130 @ 2.00GHz stepping : 6 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-5.1…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…CPU specification: processor : 23 vendor_id : GenuineIntel cpu family : 6 model : 29 model name : Intel(R) Xeon(R) CPU E7450 @ 2.40GHz stepping : 1 cpu… management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB-1.0.2-2 (rel2… least active dataset in memory is one we use for our …
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… other queries, not using Full Text Search. [root@r27 sp]# mysql –host 127.0.0.1 –port 3307 Welcome to the MySQL monitor. Commands… explicit indexes and it is clear when you can use index for sort MySQL will be a lot faster. First – Sorting. Sphinx… Sphinx however comes from its ability to scale almost linearly using multiple CPU cores and multiple nodes in the system. The raw…
Post: More Gotchas with MySQL 5.0
July 27, 2007 By 23 Comments
… higher for MySQL 5.0 compared to MySQL 4.1 It was something like 2-3 for MySQL 4.1 vs 40-60 for MySQL 5.0 At the same time however there were virtually no disk IO and CPU… the fact using mysqladmin processlist | grep -v Sleep shows much smaller value which is close in MySQL 5.0 and 4.1 Hopefully…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… is quite typical server we recommend to run MySQL on. What is important I used Noop IO scheduler, instead of default CFQ… CPU bound. I compared MySQL 5.1.30 trees – MySQL 5.1.30 with standard InnoDB, MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL 5.1.30 with XtraDB (all plugins statically compiled in MySQL) For benchmarks I used…
