… guesswork. The key is to use a logical approach and good tools… of waiting (stack traces) and CPU consumption (oprofile). That’s important … and sometimes the problem is doing too much work without blocking. Likewise, it … that can cause a stall in MySQL, and they usually begin microscopically …
Post: MySQL Server Upgrade
August 11, 2006 By 9 Comments
… with remote MySQL access closed by firewall and only trusted people having local access so I was not worried too much about it… does not have too much CPU cycles to waste. Third – My sense of MySQL 5.0 stability is still not at MySQL 4.1 level… making is – you do not have to rush and use latest MySQL version neither it always makes sense to upgrade to each…
Post: Why Swapping is bad for MySQL Performance ?
January 18, 2010 By 11 Comments
So you get MySQL or other applications using too much memory on the box or OS behaving funny and using more memory for cache and pushing application to the swap. This causes swapping and causes performance problems. This much is… its own lets see what swapping does for concurrent (multi CPU, multi client) processing. Database Locks/Latches are typically designed to…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 28 Comments
… of MySQL connections quicker than you expected but it also frequently indicates serious problems in the application. If you do not use… task is to find to which process the connection belongs. Using different user names for different application is a good practice… MySQL but many other cases when you see web application locking up or starting to runs in the tight loop consuming too much CPU…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… efficient than doing context switches, however sometimes there is just too much spinning and it becomes inefficient. Reducing innodb_sync_spin_loops… less CPU utilization you can have. Sometimes though you may be wasting time with context switching because Innodb is not spinning too much… can be used to buy a little bit more time while you’re upgrading to Percona Server or newer MySQL version or…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…uses this storage engine which may be hard to guaranty in many environments when development has too much autonomy. I must note in this aspect however DRBD goes on par with MySQL Statement Based Replication – it is also well too… and do not use this option wast memory and CPU cycles on double…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
…MySQL+Apache pairs or split MySQL And Web Server and place them on different boxes. Generally using separate boxes for MySQL… on database server is often better use of their free CPU time. Second thing you may … commodity these days you should not worry too much about it, unless you have each page …
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… use too. All these requirements made traditional databases irrelevant for many web properties – too complex and too…much higher load and much larger data sets, they are also much more complicated and performance of MySQL… the corner which more focuses on CPU bound complex queries and there are more…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… MySQL Scaling to large amount of CPUs for all storage engines all operation systems and all workloads. Well this may be too much… the most common buzzwords used together with MySQL is Scale Out, but to say the truth MySQL does not provide much of the functionality… still can’t deny – MySQL does not handle complex queries well, being able to use only one CPU effectively on single node and…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… I attended during MySQL Users Conference but I did not get too far yet, too busy. So …use two phase commit for transactions spawning multiple databases – this might not even add too much overhead as XA already used… to happen anyway. We also checked for CPU bound workload – with disk IO situation can…
