June 20, 2013

Comment: Introducing percona-patches for 5.1

on Ubuntu Hardy with the following installed: ii libmysqlclient15off 5.0.90-percona-b21.hardy.3 MySQL database client library ii libpercona-xtradb-client-dev 5.1.45-xtradb-1.0…

Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)

mysql soft nproc 4096 followed up by a restart of MySQL in a fresh user session. If you’re running RHEL/CentOS 5, Ubuntu…these limits files.[1] Conversely, it also…installation. If we do a fresh reboot of the machine, allow MySQLon the fly, without a MySQL server restart…. As it turns out, we do. On

Comment: Pitfalls of converting to InnoDB

… problem I’ve found. I’m using PHP 5.1.6, MySQL 5.0.24a default installs from Ubuntu 6.10, so pretty recent + standard. I…_progress = false; } I notice your code above has a loop on the 1205 (and 1213) error. In my case, each attempt… better solution is to use timestamps and max out based on duration, rather than a fixed loop?

Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs

installs of Ubuntu 11.04 (Natty) and CentOS 51.97g                                             mysql-data              sb       owi-ao 20.00g                                             mysql-data-201202230150 sb       swi-a-  5.00g mysql-data   0.00                           mysqlon time!). mysql> …