…s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB…Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be …imported by ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… files to be dumped by setuid processes (and MySQL Server is most commonly ran changing user from “root” to “mysql“). Before you embark… dumping core I suggest you to test it for example on the test box, which has same operating system. This is important… if you expect to do any MySQL profiling or dealing with crashes. It does not slow MySQL performance yet it is very helpful…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-…to be enabled in slave server and the performance impact should be taken in account. Anyway, …important to mention that these kind of error messages can dissapear on the shell buffer because the restore of the dump…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… getting any significant development since MySQL 4.1, so in-place upgrade of MySQL 5.0 to MySQL 5.5 should be rather… is really no gain in dumping table via mysqldump and loading it back. If performance is of importance I would recommend using Percona… MySQL 5.5 continues to support various character sets same as previous MySQL versions. Moreover utf8 character set continues to cause significant performance…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…Remote DBA for MySQL service we recognize that reliable backups are one of the most important things we… binlogs off your primary server so you can perform point in time recovery. Store your binlogs …in compression Each table is dumped to a separate file. This is very important to make restoring …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…important goals too. We want to know what your concerns are at this stage. Is it the current performance, future performance… tail it has information on core dumps and so on. It’s …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
… the Percona Software Repositories). Based on MySQL 5.5.13, Percona Server Percona …recommend using the LRU Dump/Restore patch which provides similar improvements in restart performance. Replacement is … XtraDB crashed when importing big tables (e.g. 350G) using the Expand Table Import feature due to…
Page: Presentations
May 3, 2006 By
… performance properties of MySQL build in full text search functionality using real medium size text collection – Wikipedia Articles dump, …MySQL Users Conference 2006, Santa Clara, CA This presentation shows in numbers performance differences in MySQL 4.1 and 5.0, showing most important performance…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…tool kit which helps improve the performance of queries against a MySQL database by distributing the work …community edition (ICE) performs in combination with Shard-Query. Data set It was important to choose a … with the MyISAM storage engine, then I dumped the data to tab delimited flat files using…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…variable innodb_expand_import was renamed to innodb_import_table_from_xtrabackup. (Yasufumi Kinoshita) Old system variable innodb_auto_lru_dump was …calls to improve performance. (Oleg Tsarev) Bug #727704 – When using the Expand Table Import feature, importing .ibd files created on MySQL 5.0 or…
