… Percona-Server-server or apt-get install percona-server-server? …MySQL and running mysql_upgrade. Unlike package managers, you do not have to worry about accidentally updating from one version to another because you forgot to… how MySQL behaves with your application, maybe it would also make sense to…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…could track versions for tables (increment each time table is updated) and check whenever version matches for…Plus if we can get MySQL protocol to support such light compression in addition to zlib we could stream… What is in the MySQL Query Cache ? How many hits did we get for this query item ?…
Post: Debugging MySQL SSL problems
November 8, 2012 By Leave a Comment
…to ensure SSL was working properly from the command line first before trying to get replication to…MySQL version. I had already added the relevant config options in the ‘mysqld’ section of the my.cnf: [mysqld] ssl-key=/etc/mysql…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
…to keep it simple) (In reality I did multiple runs to get accurate results, but I show only one here) mysql…. I also decided to see how longer rows affect performance …mysql> show table status like “m4″ \G *************************** 1. row *************************** Name: m4 Engine: MEMORY Version…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
…MySQL versions not being upgraded to the most recent version in series. It is frequent to see something like MySQL…How long older platforms need to be supported ? I think for example it makes sense to support RHEL4 with MySQL…
Post: How adding another table to JOIN can improve performance ?
August 1, 2008 By 12 Comments
… this case. But if it gets to hundreds of thousands this method starts to break (and newer MySQL versions will stop using this optimization method… have something to learn about MySQL Optimizer gotchas 
At the same time I figured out how to make MySQL Optimizer to do what we want to do…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
…by our MySQL Support customers: How can I audit the login attempts in MySQL? …in MySQL Community so the first option to audit MySQL‘s authentication process is to get all…mysql/mysql.log general_log = 1 User correctly authenticated: 121227 8:31:49 38 Connect root@localhost on 38 Query select @@version…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…-yet-purged, row versions. Later, the purge thread will have to clean these up. This is how you make InnoDB behave… more lines. If you ‘cat’ the fifo file, you get a million lines at a time from it. The… other terminal: while [ -e /tmp/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql_log…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…the MySQL ecosystem are Percona customers, including hardware… cause conflict. The short version of the following lengthy …to requests from vendors who want to get to know us and vice versa. Sometimes we invite vendors to speak to… some insight into how we strive to remain independent and objective…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
… how do they manage to keep things up given MySQL gives you so little ways to really restrict how … our MySQL 5.1 GA or even something major on the roadmap for future MySQL versions. May …to crack down on users which cause a lot of load which causes a lot of unintentional abusers, but to get MySQL…
