May 24, 2012

Post: Updated msl (microslow) patch, installation walk-through!

… about installing MySQL on your platform. Also have a look at the files in the Docs directory. Thank you for choosing MySQL! Otherwise… patch for MySQL 5.0.45 with InnoDB extensions msl patch for MySQL 5.0.51a with InnoDB extensions msl patch for MySQL 5.0.54a with InnoDB extensions msl patch for MySQL

Post: How to Monitor MySQL with Percona's Nagios Plugins

… papers, you’ll see a pretty extensive list of suggestions for what to monitor in MySQL. Those are only suggestions; any given… ships by default with many server installations) or a system administration mistake to delete one of MySQL‘s log or data files… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in…

Post: How Percona does a MySQL Performance Audit

… anyone can follow. A full performance audit is far more extensive than this article can cover, and might wander into Apache… can check whether MegaCli is installed, and use it to get information about the physical drives installed; then I can find out…’s a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf…

Post: Are PHP persistent connections evil ?

As you probably know PHP “mysqlextension supported persistent connections but they were disabled in new “mysqli” extension, which is probably one of…which also does not need MySQL connection open. In optimal configuration with Apache talking to local MySQL installation hand having no remote network…

Page: Consulting for MySQL

MySQL Replication performance problems. MySQL Operations and Administration Assistance with MySQL Server installation and configuration, working out Operations practices – MySQL Security, MySQL… and patches for MySQL We can help with developing custom features and extensions for MySQL, help fixing…

Post: Apache PHP MySQL and Runaway Scripts

…is obviously the problem – they take Apache Slot, MySQL Connection and other resources. I had discussion …waiting) while it happens. Happily there is pcntl extension which you can enable and which gives …pcntl_signal function which you can use to install your own timeout handling function which can …

Post: Seeking volunteers for Percona documentation

… book High Performance MySQL, will take on the volunteer role.) You should have some understanding of MySQL and Percona’s extensions, and of….percona.com/docs/wiki/percona-xtradb:features:start) * Release notes * Installation instructions for XtraBackup Eventually we’ll also upgrade our user…

Post: Percona RPMS for RedHat 5 / CentOS 5 x86_64

… 5 / CentOS 5 x86_64 platform. http://www.mysqlperformanceblog.com/mysql/RPM/RHEL5/5.0.62/ There was question what patcheset…-patch-installation-walk-through/ User / Table / Index statistics (Google’s patch). More here http://www.mysqlperformanceblog.com/2008/04/24/mysql-extensions-for…

Post: XtraDB storage engine release 1.0.6-9

… patches extensions-1.0.6, rev. 127 fails to compile on OpenSolaris” Bug #47621: change the fix of http://bugs.mysql.com… available for FreeBSD. There is an RPM Percona-release. It installs Percona.repo to /etc/yum.repos.d/ and the public…-site. Once you install Percona-release repo the upgrade becomes as easy as yum update MySQL-server-percona MySQL-client-percona The latest…

Comment: XtraDB storage engine release 1.0.4-8

install them, MySQL crashes in horrible ways. I mention this prior to logging a real bug because I wanted to test more extensively