… I see here is that this is an 8-core machine, two quad-core processors at 2GHz. I also know some things about… total execution time. By the way, the slow query logs in the stock MySQL server are extremely limited, and for serious analysis… for microsecond logging and additional information in the slow query log output. The stock MySQL server’s limitation of one-second granularity…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
…: The system was 2* Quad Core Xeon E5310, CentOS 5, Data stored on ramfs. We controlled number of cores used with /sys/devices… of cores. If you would not only run MySQL plugin but also use new “Barracuda” Innodb format you see just 1% slow down with 2 cores and about…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… it’s having to seek on disk which slows down throughput. If we could control the checkpointing …? HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_… multicore boxes. The new quad core CPUs from AMD and Intel means that 8-core boxes are going to …
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
… 2 X quad core processor with 8gb of RAM. This server is a dedicated database server. So, my problems are, the mysql process always use 1 cpu core at 1 time and it used 100% of…_using_indexes = On log_slow_queries=/var/lib/mysql/log-slow-queries.log innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… (keeping data smaller) or can a bit slow it down. Plus there were bunch of …old HT’ed XEONs to 32 GB, 4x quad-core AMD Opterons. Yes it helped:-). At the …size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts,…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… Quad Core E7320 Xeon, 2.13GHz, 32GB Memory, 16X2GB, 667MHz db_STRESS: 32 sessions, RW=1, dbsize = 1000000, no thinktime XtraDB: (mysql-5… able to disperse the lock using by the partitioning of MySQL. Added the following clause to the HISTORY table definition. “PARTITION… of InnoDB). The huge history list makes the purge operation slow, and it interferes with the other tasks of the master…
Comment: Innodb Performance Optimization Basics
March 30, 2009 By 75 Comments
…% of the data. Our server is Quad Dual Core 4GB Ram, Server 2003 and using MySQL 5.0. Query cache size is 156M… fear that if I disable the query cache it will slow down my system which already is just OK. Apart from… is increasing rapidly. I have got hold of High Performance MySQL but any hints where should I be looking at first…
Comment: MySQL random freezes could be the query cache
March 27, 2009 By 23 Comments
…% of the data. Our server is Quad Dual Core 4GB Ram, Server 2003 and using MySQL 5.0. Query cache size is 156M… fear that if I disable the query cache it will slow down my system which already is just OK. Apart from… is increasing rapidly. I have got hold of High Performance MySQL but any hints where should I be looking at first…
Comment: ORDER BY ... LIMIT Performance Optimization
December 29, 2008 By 100 Comments
… data table) but withou success. Can you help me? In MySQL I do: > create table c (id integer auto_increment, a… table is very slow 
Any idea why? My MySQL is 5.0.51a-18 PC: Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz, bogomips: 4776.06, 8GB RAM, and system including mysql id on SSD…
