… between. So how to recover CREATE TABLE from .frm file ? Recovering from .frm for Innodb Table If we simply copy .frm file back to the database… “test_myisam” does not need to be exist. The intuitive way to rebuild MyISAM table would be REPAIR TABLE test_myisam USE_FRM, however it…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…with InnoDB tables — don’t use GUIDs. Which brings me to my next point: Use InnoDB…to the cost of repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but read-only tables… you still have to think about how to avoid enormous tables that are hard to maintain, back …
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…tables would be repaired at the same time. What if user uses all 100 of his allowed connections to ALTER 100 different tables…Innodb Table Cache Leak – Innodb never shrinks its internal table cache (data dictionary) so by creating and accessing large amount of Innodb tables…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…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…to IO alignment yourself. In this case offset is correct, but file system is unaware how to align files properly. 4. Partition table…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…, and how does it compare in performance?  When would I use PBXT instead of a storage engine like MyISAM, InnoDB or… changed, then the indices need to be rebuilt, which can be done by REPAIR TABLE. The table data page size does not require… that then have to be fixed. How to optimize the program without compromising data integrity is a constant question. Relative to maintaining performance, stability…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…memory if done to MyISAM tables. myisam_sort_buffer_size used for ALTER TABLE, OPTIMIZE TABLE, REPAIR TABLE commands. … – not what you would like to see. Monitor how the value changes so you …memory consumption Innodb Table Cache. Innodb has its own table cache in which meta data about each table …
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…table‘, ’0′ ‘Com_repair‘, ’0′ ‘Com_replace’, ’20801587′ ‘Com_replace_select’, ’0′ ‘Com_reset’, ’0′ ‘Com_restore_table…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…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
… repair may take long hours (this is indeed one of the big reasons to use Innodb even if you do not care about Table Locks or transactions). Besides these various trips and gotchas you simply need to plan carefully how you’re going to alter…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… per minute I’m curious how you’re dealing with repairing of these MyISAM tables or are you switching to the slave because you… would. You still did not answer WHY you need to restore single table. What condition causes this ? Typically there are following conditions…. It is very possible we would have recommended you to stay with Innodb reviewing your application. Just recognize it is not typical…
Post: Progress with ClickAider project
October 24, 2007 By 21 Comments
… us with this project so far. We use Innodb tables now because checking and repairing MyISAM is nightmare and PBXT which could be… might need to do some of it for certain most common queries. At this point however we’re looking how much performance…, which might be a bit low traffic but still good to see how system works. This is the reason why we added…
