… Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5…in performance. Other then that, I have also disabled query cache to avoid contention caused by query… Per Second, while with the table purchases_index, the avg. insert rate reduced to ~9k INSERTs Per Second….
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By Leave a Comment
… to be frequent, severe, or subtle causes of problems in MySQL systems. They are intentionally not generic because I wanted to… counters and variables. This is the pmp-check-mysql-status plugin, which can perform computations on status variables. By default, I recommend… change over time for one or more counters (e.g. queries per second) The documentation contains examples of how to do all of…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
…was taking same 5 seconds, which points to problem with optimizer performance. Note though if you…per manual will chose best value automatically. Making this change I could bring optimization, and full query…the following explanation from Timour Katchaounov in MySQL mailing list archives I have some …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…’re running 16 seconds per second. Of course no system scale perfectly, so you would unlikely be able to get 16 queries per second on such… ~= 12 queries per second. For some ideas about what factor may make sense for your system check out Thinking Clearly About Performance by Cary… to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… running 20k queries per second and higher, lots of memory, lots of CPU cores, and most queries are …report, I was able to see queries that have mostly very fast performance, and occasionally have much worse, … — and that’s where improvements to the MySQL source code are necessary. But in many …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence …list, there are several others that can be performed with existing plugins, so there was no …increase in a variable such as Queries and alert on a queries-per-second threshold. (I don’t suggest doing …
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
…; logging queries which take more than a second to execute; logging every query; MySQL was run…was executed roughly 20-25k queries per second. If all queries are logged – a slow…query rate in this case is about 1000 per second. Logging to /dev/null It is interesting to know how much from performance…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… times per second. Often this is from some ORM system, such as Class::DBI, which does $dbh->ping before each and every query… stock MySQL server’s limitation of one-second granularity makes it hide problem queries that are faster than one second (which in a high-performance system is virtually every query.) If…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time … is being done in terms of requests per second. Should be easy to see on the… queries mysql. I’ve seen monitoring updates which would add excessively expensive and frequent query …
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…performance: understanding events at points in time. And in a system that accepts, processes, and replies to requests (queries…maybe a bit longer. This is common in MySQL servers I work with when they’re … per second. A few of the requests will arrive in one second and complete in the next second, …
