… because there is sometimes a correlation (but not a cause) relationship between the counter events and the query’s execution time…. Notice that we still don’t know anything about any relationship between Key_reads and the execution time of our query… a machine that’s dedicated to MyISAM tables. Consider your mixture of storage engines (some InnoDB, some MyISAM, which is more important…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… is right. With some exception however. For example Innodb tables do internal full table lock if auto_increment is used so using values… do many to many relationship between users and tables but it also might work. Regarding if you use many tables you’re doing… with many tables some are OS and File System dependent, others correspond to Innodb storage engine or using innodb_file_per_table option in…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
… to support it. Remember early MySQL versions knew only about table locks and were not initially designed to support transactions. Most… marketing. Innodb/Oracle relationship complexities. If the bug happen to affect Innodb things become even more complicated slow. Even though MySQL and Innodb is…
Comment: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
February 19, 2013 By 18 Comments
… have an InnoDB table that I want to optimize, but another table (a child table) has a foreign key constraint pointing into this table. I… the child table. I thought that “SET FOREIGN_KEY_CHECKS = OFF” would disable that relationship. I even tried dropping the parent table (which…
Comment: Blob Storage in Innodb
February 17, 2010 By 13 Comments
… be held in a separate table, and the id column used to associate rows (1-to-1 relationship). C) Do your hefty queries (with joins, complex where clauses, etc) ONLY against the metadata table, and when… 1 InnoDB table that holds the blob. Queries against this table will use the primary index, and will only pull from the actual table…
Comment: How to recover a single InnoDB table from a Full Backup
April 11, 2012 By 10 Comments
Hi, consider this comment about foreign key and transportable tablespaces : “To export tables that are in a foreign key relationship you must export and import all the tables together” Source : http://blogs.innodb.com/wp/2012/04/innodb-transportable-tablespaces/
Comment: High Rate insertion with MySQL and Innodb
March 29, 2012 By 17 Comments
… records are 1.9 million, the table has parent child relationship and the engine type is InnoDB. The process is very slow, it…, otherwise it first inserts parent and then child, after setting innodb_buffer_pool_instances to 8, I don’t see any…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…data, you are most likely using the InnoDB storage engine, since MyISAM is not transactional…support company? There is a quite direct relationship between the level of availability and the… required expertise level is summarized in the table below. Expertise level MySQL replication Typical, average …
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
…everyone brings something and puts it on the table. These builds are stamped with our name …MySQL codebase, not the Percona codebase. Percona’s relationship to the rest of the community is that…modification to the MySQL server, XtraDB, Maatkit, our InnoDB data recovery tools, MMM, innotop, or even …
