… is. As of MySQL 5.5 FLUSH TABLES … | 0 | NULL | show processlist | 0 | 0 | 1 | +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ 5 rows in set …which are stored in MyISAM tables anyway) you…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… All – I have created a backup of my mysql database using the innobackupex-1.5.1 command. I have the innodb_file_per_table… the database in my /var/lib/mysql folder. But I am able to view/access ONLY MYISAM table – but none of the…
Comment: Fixing column encoding mess in MySQL
March 14, 2012 By 32 Comments
… I have similar problem and nothing works. MyISAM tables with latin1 encoding. Tried: ALTER TABLE CONVERT TO … encodings, but no actual content changes. So.. After this mysql thinks my table is utf8, I try the nr2…Does nothing. £ sign stays the same, nothing changes. Server version: 5.1.61-0ubuntu0.11…
Post: Percona Server 5.1.60-13.1
December 16, 2011 By Leave a Comment
… are available from Percona Server 5.1.60-13.1 downloads and from the Percona Software Repositories). Based on MySQL 5.1.60, including all the bug fixes in it, Percona Server 5.1.60-13.1 is now the current stable release in the 5.1… MySQL bug tracker, but not fixed in upstream MySQL at the time of this Percona Server release. Bug Fixed: #860910 (Alexey Kopytov) MyISAM…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…-H run, and it can’t be because we used MyISAM tables which are not ACID complaint. Plus we only measured… is MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6…
Post: MySQL 5.1 Stability
June 30, 2008 By 12 Comments
… downgrading from MySQL 5.1.25 to 5.0 We have other customers (and our own projects as well) which run on MySQL 5.1 successfully but I can’t it is on par with MySQL 5.0 stability yet. This given customer was running MyISAM on FreeBSD with quite basic queries, so may be there are some issues with FreeBSD and MySQL 5.1 still ?
Post: InnoDB in self-compiled MySQL 5.1
September 13, 2007 By 9 Comments
… version: mysql testdatabase < dump.sql I bet you will not notice all your tables now is MyISAM. Why? Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.21-beta-log Source distribution Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer. mysql…
Post: xtrabackup-1.1
March 24, 2010 By 5 Comments
… 1.1. The list of changes in version 1.1 includes: Changelog: XtraBackup is built on a base of MySQL 5.1.44 with InnoDB plugin 1.0…-files to mysql child proc Bug #510960: innobackupex –remote-host scp doesn’t copy MyISAM files The binary packages for RHEL4,5, Debian… available on http://www.percona.com/percona-builds/XtraBackup/XtraBackup-1.1/. Debian and RPM are available in Percona repository. The project…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
So lets say you upgraded from MySQL 5.1 to Percona Server 5.5 and instead of expected performance improvement you see your performance …. Check stats sampling settings such as innodb-stats-method and myisam-stats-method. For Innodb storage engines it is possible for… get more accurate results. In recent Percona Server versions and MySQL 5.6 you can also store innodb stats in table so…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1-falcon for…) Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb For Falcon ./configure –prefix=/usr/local/mysqltest/mysql- –with-falcon…
