… service). I thought I should write a blog post that will both answer their question, …s hardware, including RAID controllers, installed memory, and so on in the boot output. In addition, at the …error in the my.cnf file. For an example, take a look at this bug report (not a bug). Looking at MySQL…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… couple of blog posts recently asking something like “what’s… equation, of course, is the one in the error log after a crash: “It is possible…buffers to be allocated. You can’t control that or calculate it at a global …and ran the following on my laptop: mysql> set @a := repeat(‘a’, 1024 * 1024 * 100);…
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
… blogged about how InnoDB performs a checkpoint , I …. Percona Server with XtraDB allows you to control the transaction log record size, as better…subject recently in his post MySQL 5.5.8 – in search of stability, as seen in his …then later rolled back do to an error or a specific request, as part of…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… is about deadlock errors: ———————— LATEST DETECTED DEADLOCK ———————— 060717 4:…in microseconds. mysql tables in use 1, locked 0 is number of tables used by transaction in…Innodb main thread which controls scheduling of number of …than accessing 10MB blog, but it is…
Comment: MySQL Error control changes
March 9, 2007 By 4 Comments
[...] of storage engines, on the MySQL Performance Blog, Peter Zaitsev reports on changes to error control in MySQL 5.0. “Previously if you start MySQL and Innodb storage engine fails to initialize … MySQL [...]
