Hi Baron, that’s definitely a very helpful article! It is just … of the main loop. Then it works for me like a charm transferring the biggest table we have (160GB , varchar columns). Also…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
March 29, 2012 By 28 Comments
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
…to the built-in innobackupex usage docs. (Baron Schwartz, Fred Linhoss) Added a manual page …- The innobackup –include option now handles non-InnoDB tables. (Vadim Tkachenko) Bug #606981 – Streaming InnoDB …special shell characters (such as “&”) did not work, even when the option value was properly …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… look at the system to predict in performance, the model baron has published for example is good for measuring scalability of…” tell us the number of work system has to do will vary significantly all the time. Baron‘s model deals with some… # Full scan 0% yes, 99% no # Tmp table 1% yes, 98% no # Tmp table on 1% yes, 98% no In this case…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… is all great but it does not work any more in MySQL 5.0 Baron has spotted it by incident when we… though this functionality is currently broken other somewhat similar functionality works as expected. Innodb during recovery also prints position in the… Snapshot (assuming you’re only using Innodb tables and not touching your MyISAM system tables) and use this position to point to…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…, the unfortunate problem is that surrogate measures work sometimes, simply because there is sometimes a … useful you can do with Key_reads: [baron@localhost ~]$ mysqladmin ext -ri10 | grep Key_reads | Key_… a machine that’s dedicated to MyISAM tables. Consider your mixture of storage engines (some …
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 7 Comments
… a special mutex table, as explained on Baron’s blog to get rid of the gaps problem. A “mutex” table is a clever trick that allows joining tables while… we were working on a Consulting case for a customer. So, if this saves you from doing an ALTER TABLE to change…
Comment: Four ways to optimize paginated displays
September 24, 2008 By 26 Comments
Baron, Let me elaborate:) What we ( at work ) wind up doing is: Do we need to know how … that comprise the primary key value) 3. SELECT fields FROM table WHERE id IN (collectedIds) 4. re-arrange ids 5.SELECT… one if total rows returned == size 3. SELECT fields FROM table WHERE id IN (collectedIds) 4. re-arrange ids 5. If…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… NULL | 8272067 | Using where | +—-+————-+———-+——-+—————+—————+———+——+———+————-+ against table CREATE TABLE `lineitem` ( `l_shipdate` date NOT … was able to find is Baron‘s bug with no …to check how really MRR works. What else worth to…
Post: SELECT LOCK IN SHARE MODE and FOR UPDATE
August 6, 2006 By 51 Comments
Baron wrote nice article comparing locking hints in MySQL and SQL … is not used while you recompute it. Note it also works if LOCK IN SHARE MODE is used with selects – standard… missing in Locking implementation of Innodb are: Lock table Innodb can lock tables but it will still need to set row level…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…– SHOW ENGINE InnoDB STATUS. On most occasions it works beautifully. The problems appear when you have …space occupied by that section of InnoDB status. Baron once wrote an article on how to do … is to create a special InnoDB table called innodb_monitor: CREATE TABLE innodb_monitor (a INT) ENGINE=…
