…, thanks to Corey Mosher. On the Linux side, we recently deployed a pair on servers for backup purpose, boxes with 64 300GB SAS… “zfs snapshot script” you’ll many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to… for the whole setup. A small but yet interesting saving. All put together, ZFS on Linux is a very interesting solution for MySQL backup servers…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
…for metadata caching, but it is just the price you should be willing to pay for ZFS. ZFS LZ4 compression is the best…It is the only stable illumos distro designed for server usage, and it can be bought with… only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker….
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… for help with server stalls. They come under various names: lockup, freeze…built a good set of tools for doing this on Linux. It is no harder … you have found. Within Percona, the best course of action is often to … things that can cause a stall in MySQL, and they usually begin microscopically and …
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… questions I get asked is which Linux distribution I would use for a MySQL database server. Bearing the responsibility for someone else’s success means… cannot upgrade MySQL either until the problem is fixed. In a stressful situation when downtime clock ticks – annoying at best. Resolving problems…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…also tell you what we think is best for you, which is our job). After the…_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 …MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server that has the Percona patches for…
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
… is a form of governance for many mature open source projects, such as Apache Software Foundation, Linux Foundation or FreeBSD Foundation. A… pick the best innovations which match our project goals for inclusion in Percona Server and other Percona software, wherever in the MySQL Ecosystem they…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…Errors behavior: Continue Filesystem OS type: Linux Inode count: 226918400 Block count: …best option to use for the database server, though panic might be good option in high availability setup which would cause server…not needed for partition you store MySQL data on, as chances are MySQL server is …
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 11 Comments
…for MySQL Users and is based on Percona Server 5.5.20. With this release we make clustering very easy and affordable for…an General Availability release. We did our best to eliminate bugs and problems during …We provide tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… see MySQL memory consumption plotted. I use “VSZ” columns from “ps” output on Linux….In Percona Server you can do better as you can query temporary tables too: mysql>…to any known resource use. For example for global memory leaks you would see…to run in production. So the best thing to do in this case…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…server for those things which need to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL… v0123456789 (Other) Service Tag | 0123456789 Platform | Linux Release | Ubuntu 12.04.1 LTS …both cases for this given workload the performance was best with…
