…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 3 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: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 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 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: 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: 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: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
…best choice for operability in the majority of normal configurations. Are there ways to squeeze more performance out of a server…for Swap — 10-20G for the OS (/) Possibly 10G+ for /tmp (note you could also point mysql‘s tmpdir elsewhere) Everything else for MySQL…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… couple things about InnoDB storage: first – in Percona Server you can now customize page size and it …500 byte) files mostly, it’s best to use 512-byte blocks, for bigger files 4k may make more sense (you can’t use blocks bigger than 4k (page size) on Linux…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main database, I believe different applications work best on… the availability of RAM? On a dedicated server for Mysql you will still need some memory for the OS and the various stuff that… used for these non-mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql server for a…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… Platform | Linux Release | Ubuntu 10.04.2 LTS (lucid) Kernel | 2.6.32-31-server Architecture | …MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have been running these benchmarks for… not during mkfs. This is your best option if you have a proper …
