…to make it better suited to more environments. The 2.0.0 …a parallel way, thus utilizing multiple CPU cores if needed. In previous versions…limitations (e.g. could not be used with parallel file copying, it …topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically,…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… number of cores. If you would not only run MySQL plugin but also use new “Barracuda” Innodb format you see just 1… see Plugin uses less CPU with 8 cores and has less performance – this usually shows synchronization is the issue. Barracuda format uses more CPU while delivering better performance so it is probably better with latching too though it is hard to say anything about CPU…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…. So how we can use this data to estimate capacity of MySQL system ? We can look at CPU and IO consumption per Query… to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc… localhost # InnoDB trxID 3BBF3B55 (1/0%), 3BBF3B5A (1/0%)… 1753695 more # Last errno 0 # Users user # Query_time distribution # 1us # 10us…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 4 Comments
… can be light if it is CPU bound – because the system can execute much more CPU bound tasks in parallel or … you run single batch job on the server with MySQL, Load Average is likely to be close to 1 …if you’re waiting on one drive you can’t use another drive instead), and the fact disks can optimize …
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… a lot of CPU time running “loops” as part of spinlock implementation. In many cases busy wait is indeed more efficient than… a lot of threads waiting and the more CPU cores you have available the less CPU utilization you can have. Sometimes though you… and can be used to buy a little bit more time while you’re upgrading to Percona Server or newer MySQL version or…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…_STRESS: 32 sessions, RW=1, dbsize = 1000000, no thinktime XtraDB: (mysql-5.1.39 + XtraDB-1.0.4-current) innodb_io… the peak performance to use CPU and IO resource more effectively. To avoid mutex/lock contentions are good to use more CPU resource of many CPUs…. We may be able to disperse the lock using by the partitioning of MySQL. Added the following clause to the HISTORY table…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… queries, not using Full Text Search. [root@r27 sp]# mysql –host 127.0.0.1 –port 3307 Welcome to the MySQL monitor. Commands… for more, though I carefully picked queries which are reasonably good for both of them – it is easy to “break” MySQL making… Sphinx however comes from its ability to scale almost linearly using multiple CPU cores and multiple nodes in the system. The raw…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… scripts running very long time. For simplicity I did not use MySQL, but other system call – sleep() which has similar behavior for… or MySQL calls and does not output anything to the browser neither automatic termination not connection_aborted() check seems to work. More…_limit() which specifies cpu time, pcntl_alarm() specifies number of wall clock seconds and so it is much more useful for scripts which…
Post: Three ways that the poor man's profiler can hurt MySQL
December 2, 2011 By 19 Comments
…’s technique of using GDB as a profiler has become a key tool in helping us analyze MySQL when customers are having… a very slow-running server that was using tons of CPU time and lots of system CPU, and exhibiting the classic signs of… cases for more users, and how much less intrusive they can be. Of course, I’m really waiting for MySQL 5.6…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…compute joins and may aggregate and summarize data. Using the aggregated data can significantly improve query … views. Most database servers have some spare CPU for binary log parsing. Run the setup script…log, delete rows and then insert some more of them: mysql> create table > test.demo ( > c1 int …
