…of memory if done to MyISAM tables. myisam_sort_buffer_size used for ALTER TABLE, OPTIMIZE TABLE, REPAIR TABLE commands. For OLTP applications with …still can have very large memory consumption Innodb Table Cache. Innodb has its own table cache in which meta data about each table accessed from the…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…. You can save very large amounts of space. Choose primary keys very carefully, especially with InnoDB tables — don’t use GUIDs. Which brings me to my next point: Use InnoDB Assuming that you will…, it doesn’t save you from the downtime caused by ALTER TABLE — a typical reason to think about master-master with failover…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… large number of connections Innodb will only print number of them, cutting the list so SHOW INNODB STATUS output will not grow too large… of 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…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
So you’re running MySQL With innodb_file_per_table option but your ibdata1 file which holds main (or system) … (can be changed via innodb_ibuf_max_size option) which can be significant size for systems with large amount of memory. Finally… can handle it. Note ALTER TABLE will not require excessive amount of undo space even for very large tables as it internally commits every…
Post: Percona Server 5.5.11-20.2 Stable Release
April 28, 2011 By 1 Comment
… Bug #757749 – Using ALTER TABLE to convert an InnoDB table to a MEMORY table could fail due to a bug in innodb_expand_fast_index_creation… some cases when innodb_lazy_drop_table was enabled with very large buffer pools. (Yasufumi Kinoshita) Bug #733317 – SYS_STATS internal table of XtraDB…
Post: Concatenating MyISAM files
November 19, 2012 By 5 Comments
…large read-only InnoDB database to MyISAM (eventually packed). The only issue was that for one of the table…table… select * from Innodb_table… would take about 10 days. The bottleneck was clearly the lack of concurrency on the read part from InnoDB…0 Warnings: 0 mysql> alter table test_concat_part…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… and it would be waste to pull binary logs to large variety of slaves? This is the case when BLACKHOLE storage… add more tables to be replicated to the slaves. Another issue is of course creating and altering tables. If you have Innodb tables you’re normally OK because you can use –skip-innodb on the filtering slave…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… recommended against this. There are several problems with the very large transaction caused by the single statement. We didn’t want… in chunks of a million rows each. (InnoDB internally does operations such as ALTER TABLE in 10k row chunks, by the way; I… CREATE TABLE: CREATE TABLE load_test ( col1 bigint(20) NOT NULL, col2 bigint(20) default NULL, key(col1), key(col2) ) ENGINE=InnoDB DEFAULT…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
… be much faster as well as ALTER TABLE (expecially together with ability to create index without table rebuilding) Buffer pool improvements. I would… and promoting real one to unique. Tablespaces. To call “innodb_file_per_table” option tablespaces is a joke. It is better than… I will list it. Basically Innodb has problems scaling both with large number of active threads and with large number of CPUs (in…
Comment: Upgrading MySQL
January 17, 2010 By 24 Comments
… all tables which need to be changed but fails miserably with Innodb tables. Recommendation by the mysql_upgrade binary is to dump the tables… large you are back to the problem that the dump/load takes ages. Then again none of this is really necessary: ALTER TABLE ENGINE=INNODB rebuilds the table under 5.1 and MySQL is happy… (why…
