…lists is typical for a lot of modern applications. The system I used for test was 4 …can’t get use of more than 8 cores effectively (which would correspond to single CPU socket these…do_select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_…
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… and it is clear when you can use index for sort MySQL will be a lot faster. First – Sorting. Sphinx is smart doing… Sphinx however comes from its ability to scale almost linearly using multiple CPU cores and multiple nodes in the system. The raw…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… a CPU with two cores, 8G of memory and a software RAID5 array consisting of 4 disks. The version of MySQL used for benchmarking pre 5.5.23 DROP TABLE implementation is MySQL 5.5.15, the version of MySQL used for benchmarking… in older versions of MySQL. However, Percona Server with “Lazy Drop Table” still fares a lot better than MySQL. The dips are there…
Post: What CPU Architecture do you prefer for running MySQL In production
November 24, 2012 By 13 Comments
Time for another poll! I wonder What CPU Architecture do you use for running MySQL in Production ? I guess most of the game…-64 variants though I wonder if there is still a lot of use for others in the wild. If I am missing…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…, is relatively widely used for the MySQL server development: there is support for it in the MySQL Test Framework, DBQP… intermediate state, it is likely that if other CPU cores will read this same variable, they will …lot of the last kind). What would I do about all this? If I had my way, I’d use…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… deleted rows and MySQL timestamps may not be flexible enough. The trigger method has a lot of problems. … you use row-based binary logs (RBR). If you don’t have MySQL 5.1 or aren’t using RBR… materialized views. Most database servers have some spare CPU for binary log parsing. Run the setup script: …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…kernel — knowing this may tell us a lot of useful things about the system. Next I continue …/cpuinfo power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : Intel(R… If it’s not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… see the CPU usage being low with a lot of CPU being idle, increased compared to normal workload portion of system CPU and high… you should expect a lot of threads waiting and the more CPU cores you have available the less CPU utilization you can have… can be used to buy a little bit more time while you’re upgrading to Percona Server or newer MySQL version or…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 5 Comments
… server with MySQL, Load Average is likely to be close to 1 even if there are a lot of CPUs … waiting in the queue starts. If you have fully CPU bound workload which is rather parallel (ie many queries…if you’re waiting on one drive you can’t use another drive instead), and the fact disks can optimize…
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… how people tend to use MySQL in modern applications and it stroke me in many cases MySQL is not used to process the data… at recommendation task as well as a lot of other personalized services they may not use MySQL (and SQL at all). In many… not served from cache you will have many CPU seconds if not minutes used processing your request, but you get reply fast…
