… and see how it works; press the ‘?’ key for a list of the keystroke commands you can use. If you find…, I’ll post them on Percona.TV, our MySQL video/screencast blog site. Another interesting topic is how to examine a system…. There are many things that can cause a stall in MySQL, and they usually begin microscopically and get worse over time…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just … toolbar bookmark: an option and variable reference for all three sites in one! abort_slave_event_countblogpercona.commanual Aborted_clientsblogpercona.commanual…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… the INFORMATION_SCHEMA can take a barely-running site and bring it down, so I do …constantly on our internal IRC channel and mailing list. We share all sorts of dirty tricks and…
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
…. In general I think both of this sites have the same mistake (or shortcut) in MySQL Full Text Search configuration – relaying on… reasons you better analyze word frequencies and build stop word list which matches your application. For example “A6″ unlikely needs to…, which we’re often using with MySQL – Sphinx Search we still tend to use stop word list for performance reasons, but it…
Post: Site was down today, support and web hosting.
August 31, 2007 By 27 Comments
… we had pretty good track record with MySQL Performance Blog – there were times when site was slow (especially when backup was running… less lucky and in about a week after we moved MySQL Performance Blog to the new server, it stopped responding. I… I run – he tells me to run “fdisk -l” (which lists partitions) I ask him to spell that to me carefully…
Post: Tools to use for MySQL Performance Review
May 31, 2008 By 3 Comments
… now you can find our favorite MySQL Performance Review Tools on the site. This is just list of tools which came from the… on what else we should add to it. In this list we focused on Open Source tools which are helpful for… audit – for example you see no graphing software in this list or any commercial offerings.
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… with MySQL is the number of possible HA solutions. From the simplest the most complex let’s list the most common ones: – MySQL… level is summarized in the table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM… KVM over IP and adequate remote power management, an on site intervention with physical access to the servers is the preferred…
Post: Announcing Percona Playback 0.5
November 26, 2012 By
…. Downloads are available from our download site and Percona Software Repositories. Percona Playback… release binary packages were prepared, full list is available in our documentation. Bugs …=libmysqlclient –mysql-host=10.8.2.10 \ –mysql-username=root –mysql-password=passW0rd –mysql-schema=imdb…
Post: MySQL Performance Blog now uses Sphinx for Site Search
February 15, 2008 By 52 Comments
… wanted to find something on MySQL Performance Blog. Today we have published new search functionality for our site which is based on… list of last searches and Top searches which if both nice for fun and for SEO. Hope this addition will make MySQL…
Post: Pretty-formatted index fragmentation with xtrabackup
March 15, 2011 By 4 Comments
…to examine whether you’d benefit from “defragmenting” your MySQL database with OPTIMIZE TABLE, although I have not …on the header at the top of the code listing. The output looks like this: TABLE INDEX TOT_…revert_domain 153984 19276 71.4% art.link_out104 site_message 36992 4651 83.4% That output was …
