…: The fragmentation we speak in this article is filesystem fragmentation or internal table fragmentation which …do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1;…. Going to 10000 tables however insert speed dropped 20 times. This could be …
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…inserts and make primary key significantly fragmented. I also would note there are some MySQL optimizer restrictions in how …, will the index have any impact on the speed of the query? A: If you extend the … to add another index. Q: We have a database that has about 400GB of indexes. The indexes …
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…Query Cache” which is quite helpful for MySQL Performance optimization tasks but there are … transactions may see different states of the database, depending on the updates they have …reduce update speed a bit. Fragmentation over time – Over time Query Cache might get fragmented, which reduces…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…Database Egos” – Storage Engine developers showcase as one of keynotes. Today let me start with most popular transactional storage engine for MySQL…data and for various indexes. How many “fragmented” pages do we have in the …larger than table itself) The index build speed is however not only reason I …
Post: Percona Server and XtraBackup weekly news, April 4th
April 4, 2011 By 1 Comment
… in the market such as MySQL 5.5, MariaDB, Drizzle, etc. …fragmented indexes. He also improved mysqldump so indexes are created with “fast index creation” when restoring a dump, which can potentially speed…aware, are making XtraBackup support Drizzle databases. We committed code that makes …
Post: How network can impact MySQL Operations ?
September 1, 2008 By 5 Comments
…lot of data copying around between MySQL boxes. We had prepared well … large Innodb tables with not overly fragmented tablespace, or it is easy to…copy process we saw the copy speed about 20MB/sec instead of projected…while looking at network topology. Some database servers were connected to Switch A…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…of a segment are allocated from ‘fragment extents’ where any individual page … can see the full write speed of the disk for throughput. …_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread… applications to other database brands. Maybe in some denormalized database (for example, …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…is worth mentioning is fragmentation. Fast index creation results in much less fragmented indexes because …index creation chapter in the MySQL manual: “… you can generally speed the overall process of creating…created with –innodb-optimize-keys (the test database contained only the table I used …
