…MySQL world and in fact I already wrote about it. There are many aspects of managing mysql…small and fast updates which go after it in MySQL …binary log as one big chunk which can’t…long running updates. Queries or transactions containing multiple …query will perform full table scan in MySQL 5.0 (even…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…’s typically set pretty small, like 20M). But even …can take many gigabytes on servers with a lot of tables. …You can’t control that or calculate it at a …. And they can be really big (but no bigger than …OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a,…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
…MySQL had a dedicated partition on XFS file system Server was running innodb_file_per_table… (or rather, unfortunately) backup only had table definitions …. There was this rather big table with integer and enum… 2. There was another table, a small one with 4 …would not work for many reasons. This is …
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
…commodity MySQL server running Percona XtraDB for a gaming workload (mostly inserts to the “moves” table),…performance implications here. How many big writes does InnoDB do, and how many small writes? First, I found…file writes on this workload are 512 or 1024 bytes. (It might vary for other workloads…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…big “non-starter” limitations Postgres has overcome for specific use cases. I decided to write a series of blog posts on MySQL…the primary, where many updates are occurring … still a relatively small fraction of the server…tables are a nightmare. Here are a few ideas I’ve either heard, or discussed, or…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or…can do only so many IO requests per second….the time if Innodb or MyISAM tables are used. There…MySQL replication is a showstopper) and it also solves the other big pain of semi-online MySQL…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…only an in memory or read-only engine, …operations. The benefit of small size is also … there https://launchpad.net/mysql-patch/mytools What …to read and decompress big portion of data. – Despite…, as it applied TABLE LOCK on copying table. When recovery… this, you often need many, often complex indexes …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…. MySQL Master Master Manager can help you to automate it a bit. I also like to keep tables small enough, “sharding” to many tables before… and reorganizes small portions of table online. Q38: Seems that adaptive hash indexes are not used for primary key lookups or not showed…? Do you have a big enough buffer pool? PZ: I guess it may be bug in the status or bug in implementation…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…big. In practice we tend to see query cache sizes that are far too big more than ones that are too small…tables to be InnoDB and use innodb_file_per_table. sql_mode also uses STRICT_TRANS_TABLES…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
…or thousands) each reading and writing small chunks of data. The recent improvements to MySQL… records. This table is partitioned by month which means that MySQL can use …big chunk of data in one query, it runs many smaller queries each requesting significantly less data. On the other hand, MySQL…
