…) references dos3(fkfrom1), foreign key (fkto2) references dos2(fkfrom1) ) engine=innodb character set=utf8; create table dos2 ( fkfrom1 char(32) not… achieve the best performance possible, so we’re going to convert everything to ASCII. Or perhaps we have some other tables… way we were expecting. Whatever the reason, we decide to convert these columns to be ASCII. We might assume that since…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… to determine when an in-memory temporary table will be converted to an on-disk table, which is an expensive operation… might be an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or… might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
… in a MyISAM table Advance the Innodb tablespace id by creating fake Innodb tables Once the Innodb tablespace id is minus one of a customer table alter the table definition from MyISAM to Innodb… download the tables in MyISAM format and then he just convert them back to InnoDB.
Comment: Fixing column encoding mess in MySQL
January 26, 2011 By 32 Comments
… even know what to do with it. The table is InnoDB, utf8, the column is utf8, the original data we imported… out of Sql Server into MySQL, and may have been converted to utf-8 during that first import. I tried (with…-8 or ISO-8859-1), though if I display it converted to utf-8, it’s back to upside-down exclamation…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… explain the difference between MyISAM and InnoDB table cache? 3) Would converting the MyISAM tables to InnoDB fix or help the os ulimit…_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db-logs/ibdlogs innodb_data…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… MyISAM and InnoDB and the difference in how the OS handles opened files? 3) Would converting the MyISAM tables to InnoDB fix or…_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home_dir = /db-logs/ibdlogs innodb_data… innodb_additional_mem_pool_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 2 innodb_thread_concurrency = 16 innodb_open_files = 20000 innodb…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…… I’ve read Peter Z two guides but cannot really convert the gained knowledge to solve our situation. Lesser questions but…:10M:autoextend innodb_log_group_home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer_pool… to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files…
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
… parsed fully each time, all return values had to be converted to the strings on server side and back on the… – which means not only data does not need to be converted back and forth but you also save extra data copying… include full statement text not only “Execute” but in SHOW INNODB STATUS you would still see statements without actual values – quite…
Comment: Modeling InnoDB Scalability on Multi-Core Servers
January 31, 2012 By 11 Comments
… not like –innodb_adaptive_hash_partitions=8 option on command line. I don’t know why underscores are converted to hyphens either… disabled. 120131 16:00:43 InnoDB: The InnoDB memory heap is disabled 120131 16:00:43 InnoDB: Mutexes and rw_locks use GCC…:44 [ERROR] Aborting 120131 16:00:44 InnoDB: Starting shutdown… 120131 16:00:49 InnoDB: Shutdown completed; log sequence number 1604009568 120131…
Post: Percona Server 5.5.11-20.2 Stable Release
April 28, 2011 By 1 Comment
…, ‘innodb_rollback_segments’, has been implemented in MySQL 5.5. (Yasufumi Kinoshita) Bug Fixes 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… internal table of XtraDB has been expanded for supporting ‘innodb_stats_method’ from InnoDB-plugin. (Yasufumi Kinoshita) Please report any bugs found…
