…Suppose you have the following table structure: CREATE TABLE example ( id INT UNSIGNED … TEXT, fterms TEXT, PRIMARY KEY (id) ) Engine=InnoDB; Now you insert some test data … error after converting from a native language character set to utf8, as …t have to change code in a lot of places. How much you…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…to make InnoDB use a composite UNIQUE key on a table…how to create indexes. Foreign key references may add processing time to…converting your varchars to chars for example), then having to…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
…to – SQL or storage engine. Honestly as it had name very similar to read_buffer_size which is currently only used by MyISAM tables…converted to fixed size (basically everything but BLOB/TEXT) MySQL can use read_rnd_buffer to… sometime to see how it really impacts performance both for MyISAM and Innodb…
Post: Using VIEW to reduce number of tables used
September 28, 2007 By 12 Comments
…tables per server which can become really inefficient. It is especially inefficient with Innodb tables both in terms of space (some tables…table which keeps posts for user number 123 etc. Converting it to the views we can have “post” table…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… it possible to move MyISAM to Innodb through plain ALTER TABLE statements? Yes. This is exactly how it … to work. You might need to inject MySQL 5.0 in between so it will convert…engine changed to Innodb in MySQL 5.5, meaning you might need to set storage_engine=MYISAM if you’re relaying on tables to…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…convert the gained knowledge to solve our situation. Lesser questions but probably as well important. b. The question really is how…innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE #innodb_log_buffer_size=8M # Lowered from 32M according to MySQL innodb…
