… and USER_STATISTICS tables in the INFORMATION_SCHEMA database. Bugs Fixed: A Server acting as a replication… bug was introduced in MySQL 5.5.18 and Percona Server inherited it from MySQL. Bug fixed #915814 … dumps to a temporary file first, and then rename it to the actual dump file. Bug fixed…
Comment: Dangerous command
May 21, 2008 By 9 Comments
Hi Peter, Vadim “RENAME DATABASE should have been implemented years ago” it should but it … is also something that will be perceived as half-baked. MySQL has a lot of half-baked features, and the idea… the feature was dropped. However, it’s better than releasing MySQL 5.1, and then finding out it is critically flawed…
Comment: Dangerous command
May 20, 2008 By 9 Comments
… need to release software on schedule. After being burned with MySQL 5.0 quality there was a swing to making solid… is a shame MySQL does not have this feature even in 5.1 – it is extremely handy – rename current database and load new… you just store tables in MySQL database you can simply use little script to create new database rename all tables and drop the old…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… obviously take more time! The tool processes the database one table at a time, and processes each …it would be pt-query-digest –review S=/tmp/mysql_sandbox5527.sock,u=msandbox,p=msandbox,D=percona,…and what about the transaction in the meanwhile? The rename table itself should be fast, but as it …
Comment: Using MyISAM in production
November 10, 2009 By 36 Comments
… SET UNIQUE_CHECKS=1; ALTER TABLE transferido RENAME TO transferido_myisam; ALTER TABLE transferido_inno RENAME TO transferido; OPTIMIZE TABLE transferido; — END… started optimizing this database a month ago (my first real database challenge). This blog and your book (along with Pro MySQL) helped me…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… on it when doing commercial MySQL consulting and MySQL AB has even adopted it into the official database distribution starting 5.1.21…/macko/work/mysql-5.0.51a’ The new database binary should be now available in sql subdirectory: (garfield:~/work/mysql-5.0.51a… Configuration section for details). Then rename the binary, which can be safely done even with MySQL still running. This will also automatically…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… | 18.083490 | | restoring secondary keys | 17.824109 | | rename result table | 0.162041 | | end | 0.000008 | |… created with –innodb-optimize-keys (the test database contained only the table I used in… clustered one. References: Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page…
Post: Looking at Redis
August 27, 2009 By 27 Comments
…. This keeps overhead rather low. The database is dumped in temporary file which is renamed only after fsync which means if you… can access all databases. I am also a bit surprised why databases are numbered instead of named. Naming the databases would make it… random single row updates which are hard to batch. With MySQL/Innodb I got server being able to handle some 30…
Comment: Spreading .ibd files across multiple disks; the optimization that isn't
December 26, 2010 By 23 Comments
… database –schema or database server. create database the_db; –This database is going to be created on SSD create database… To move the_db.log to `fast_ssd`: RENAME TABLE the_db.log to `fast_ssd`.log… that this doesn’t create performance problems. MySQL will simply access the base table (`fast_ssd…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…’re comming from “traditional” databases you’re likely to be shocked by MyISAM behavior (and default MySQL behavior due to this) – it… all databases out of MySQL directory to other location, check them by myisamchk prioritizing more important databases first an then rename them back to MySQL database…
