June 19, 2013

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

…PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_B` ( `id` …table sizes and an easy way to use the search feature of your browser to zero in on a particular table…metadata files!) Anomalies – Identifies possible relationships between columns/tables based on names, tables …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: ,

Post: Recovering Innodb table Corruption

July 4, 2008 By 22 Comments

…file about checksum failing CHECK TABLE says table is OK. This means You Can’t Trust CHECK TABLE in Innodb to be sure your tables…Innodb tables): mysql> optimize table test; +———–+———-+———-+———————————-+ | Table …search” Note even if you do not use MyISAM table…

Filed Under: Insight for DBAs Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… new features introduced with InnoDB full-text search), that’s largely where…corresponding FTS_*_DOC_ID.ibd file (but none of the others…INNODB_FT_* tables. In particular, the INNODB_FT_CONFIG table is supposed to “display metadata about the FULLTEXT index and associated processing for an InnoDB table…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

… ib_log* files; I know that innodb writes files in the log file group in a round… a fairly large Innodb table (150GB) that is showing poor performance for full table scans. using O…table where id=5 show innodb status: Hash table size 10624987, used cells 1, node heap has 1 buffer(s) 0.00 hash searches…

Filed Under: Insight for Developers Tagged With:

Post: Moving from MyISAM to Innodb or XtraDB. Basics

November 22, 2010 By 2 Comments

…Innodb though well it is typically easily spotted by converting tables to Innodb on restored backup. Full text search…would not fit to Innodb, though this is an exception. Space Innodb Tables tend to be larger…check are innodb_flush_log_at_trx_commit, innodb_buffer_pool_size and innodb_log_file_size. …

Filed Under: Events and Announcements, MySQL Tagged With: , ,

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

… tables locked by transactions. Innodb does not lock tables for normal operation so number of tables locked normally stays 0, unless it is ALTER TABLE… helper threads, on Windows it however can be adjusted by innodb_file_io_threads variable. For each helper thread you can see… hash index Innodb builds for some pages to speed up row lookup replacing btree search with hash search. This section shows hash table size…

Filed Under: Insight for DBAs Tagged With:

Post: Heikki Tuuri Innodb answers - Part I

October 26, 2007 By 19 Comments

… stored, and a search almost as efficient as a binary search can be performed. But InnoDB‘s adaptive hash…, and in an ascending order of the file address, then InnoDB schedules the read of all the 64…for example, if ORDER and ORDERLINE tables are joined to form a single table), it might make sense for…

Filed Under: Insight for Developers Tagged With: ,

Post: High-Performance Click Analysis with MySQL

December 22, 2008 By 13 Comments

…customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis,…with InnoDB tables — don’t use GUIDs.  Which brings me to my next point: Use InnoDB Assuming… can write CSV files with any programming language.  Naturally, CSV files don’t store as…

Filed Under: Insight for Developers Tagged With: , , , ,

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…innodb_status_fileblogpercona.commanual innodb_strict_modeblogpercona.commanual innodb_support_xablogpercona.commanual innodb_sync_spin_loopsblogpercona.commanual innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb…

Filed Under: Insight for DBAs, MySQL

Post: MySQL 5.5.8 - in search of stability

January 3, 2011 By 11 Comments

… are the InnoDB settings for the initial run. Later I will change them in searching for optimal values. innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb…

Filed Under: Benchmarks, MySQL Tagged With: ,
« Older Posts