…_DICTIONARY tables, the Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to… Ubuntu packages are available from the Drizzle PPA. Instructions on how to install from the PPA are in the Drizzle manual. CentOS 6…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
… decided to use the following strategy. Start with a clean MySQL install so that Innodb tablespace id is set to 1 Import… and good internet connectivity, I fired up an Ubuntu 10.04 EC2 instance, installed MySQL and provided the customer the credentials to upload…=`hexdump -C $t | head -3 | tail -1 | awk ‘{print $6$7}’`; mysql -u root -e “insert into tables (name,spaceid) values (‘$tname…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…core dumped to /var/lib/mysql (datadir) on my system (Ubuntu). You might be lucky …libpthread.so.0(+0xf8f0)[0x7fbb86de98f0] /lib/libc.so.6(__poll+0×53)[0x7fbb86066f93] /usr/sbin/mysqld(_…install “debuginfo” package if you expect to do any MySQL profiling or dealing with crashes. It does not slow MySQL…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 10, 2011 By 37 Comments
… MySQL on Debian/Ubuntu, CentOS/RHEL/OEL, Solaris and on Windows. On Windows: There is no OS version of MySQL. And the MySQL Installer makes installing… system MySQL is easy to install. CentOS 5 ships with MySQL 5.0.77 which is really old. The 6.x releases ship with MySQL…/Ubuntu: MySQL 5.5 landed in Debian expirimental, and the default MySQL version has been 5.1 for some time. And indeed /etc/mysql…
Post: XtraDB storage engine release 1.0.6-9
January 13, 2010 By 9 Comments
…release is base on 1.0.6 version of InnoDB plugin. MySQL 5.1.42 as a…mysql.com/47621 more reasonable The builds for RedHat 4, 5 , Debian and Ubuntu are located on http://www.percona.com/mysql…you install Percona-release repo the upgrade becomes as easy as yum update MySQL-server-percona MySQL-client…
Comment: Introducing percona-patches for 5.1
May 18, 2010 By 21 Comments
… have a server on Ubuntu Hardy with the following installed: ii libmysqlclient15off 5.0.90-percona-b21.hardy.3 MySQL database client library… ii percona-xtradb-server 5.1.45-xtradb-1.0.6-10-80.hardy.25 Percona SQL database server (metapackage dep…-xtradb-1.0.6-10-80.hardy.24 Percona SQL database server binaries Is the userstat patch included? mysql> set global userstat…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… option was made available to the lvconvert binary. Base installs of Ubuntu 11.04 (Natty) and CentOS 5.7 …if our salaries table is restored. mysql> SHOW TABLES; +———————+ | Tables_in_employees | +———————+ … | salaries | … +———————+ 6 rows in set (0.05 sec…
Comment: Pitfalls of converting to InnoDB
March 8, 2007 By 16 Comments
…’ve found. I’m using PHP 5.1.6, MySQL 5.0.24a default installs from Ubuntu 6.10, so pretty recent + standard. I’m…
