… server. There is no comparable variables of how many user variables are allocated (and how much memory they use). Memory Tables MEMORY tables… see these tables going away if you close connection. In Percona Server you can do better as you can query temporary tables too…” is really not the total any more as Innodb has moved allocating memory from operation system directly not from addition memory…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… the server much faster with the binary log enabled Faster queries through speedier joins, faster subqueries, and elimination of useless tables in… personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL world as a whole.
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… ALTER TABLE and others. Another big one is COUNT(*) without where clause which is often the show stopper for them move until it is worked around. Operations What is good for MyISAM kills Innodb, such as copying binary tables between the servers… as it exercises not so common paths in the MySQL server – in particular Optimizer may have harder time because costs between…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… QA still needs to have some tables in fresh status. – resharding databases, moving some shards from one server to another. So long story… innodb_file_table mode, which ones love, and ones hate) 1) do backup of specific tables on sources server with xtrabackup (server can run…) 2) do prepare of tables with –export options 3) create table on destination server with exactly the same CREATE TABLE statement as on source…
Post: Percona Server and XtraBackup weekly news, February 5th
February 6, 2011 By 2 Comments
…lot of problems that are essentially unfixable. Oracle has already moved away from using its ancestor, innobackup, and XtraBackup needs to… tests were augmented: more server versions, tests for export/import, tests for partitioned tables. Bug reported: when filtering by table name, innobackupex doesn…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… a plethora of useful information reported by Percona Server. Another great thing about Percona Server is the ability to enable logging atomically…, and is explained here at this link. Now before we move forward, I would like to point out that the results…_tbl_size variable is set to 32M on the server, so on-disk tables are probably being created because of blob columns…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
… cannot move your ibd files freely from one server to another or from one database to another. The reason is that the table… to comply. Percona Server relaxes a lot of limitations and is able to import tables from different Server instance, when table was altered or truncated in the meanwhile. Though this only works if table was “exported…
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
… http://www.mysqlperformanceblog.com/2009/06/08/impossible-possible-moving-innodb-tables-between-servers/ is now available in our latest releases of XtraBackup… needs to lock or shutdown server. To export table you need XtraBackup, and you can just specify table or table by mask: xtrabackup –defaults…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… is to ask them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings… have Battery backed up cache. Many applications, especially those moved from MyISAM tables are OK with value 2 which means do not… MySQL Server crashes. Value 2 only cause data loss with full OS crash. table_cache – Opening tables can be expensive. For example MyISAM tables…
