… `NAME` is a human readable table name in form database_name/table_name e.g. sakila/actor. `ID` is a table identifier. We…-ibdata1/FIL_PAGE_INDEX/<index_id> 4. Load dumps of the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…a customer recently who needed to reduce their database size on disk quickly without a…indexes select * from information_schema.index_statistics; If the stats come from some other server, then you may need to dump and load a…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… the fast index creation chapter in the MySQL manual: “… you can generally speed the overall process of creating and loading an indexed table by…’s compare the restore time for a regular dump with a dump created with –innodb-optimize-keys (the test database contained only the table I…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… the tail it has information on core dumps and so on. It’s possible… with the database. The first step is to find out what MySQL instances are on…. If the server is heavily loaded or has a lot of data, touching the…the common case, though, a query simply needs a rewrite or a new index or something. In …
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… as a Blog Post. Q: Can you go directly MySQL … no gain in dumping table via mysqldump and loading it back. If performance is of importance I would recommend using Percona Server with enabled expand_fast_index…are marked as making database binary incompatible with MySQL. Our focus …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…a single extent. For big tables, a secondary index reserves different extents from the clustered index… a heavy write load, a new flush and a checkpoint …a full write of the database (basically dump memory to disk) once every minute or two. This way we’d see a…order, for a recovery based on MySQL‘s …
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…index page where index id is 0 25556 InnoDB: (index “PRIMARY” of table “test”.”test”) InnoDB: Database page corruption on disk or a…to dump table with MySQLDump and load it…index_get_page(index)) InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql…
Post: Living with backups
November 6, 2008 By 28 Comments
…dumps all MySQL tables into a text file or ordinarily copies the binary files from the data directory to a…dedicated buffers only to store indexes, while the actual data is…it’s not difficult to have a database of such size. Everything … processlist information, CPU load avergages, I/O load, etc. In …
Post: Announcing Percona Server 5.5.24-26.0
June 1, 2012 By 9 Comments
…database. Bugs Fixed: A Server acting as a…MySQL. Bug fixed #915814 (George Ormond Lorch III). Loading LRU dump was preventing shutdown. Bug fixed #712055 (George Ormond Lorch III). A…
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
…We needed to dump and reload large database and we had… when we did load in parallel, dump in parallel did… INSERT BUFFER AND ADAPTIVE HASH INDEX ————————————- Ibuf: size 108931, free … some 80KB we have a lot of non read … in this project from MySQL AB side) – to improve…
