June 18, 2013

Post: The perils of InnoDB with Debian and startup scripts

…tables. And they’re running on Amazon EC2 with 8G of RAM and EBS storage,… a lot of tables, InnoDB uses over 3.5G of memory for its data dictionary…stay in the buffer pool, some small part of it will move in and out… declared inside InnoDB 500 mysql tables in use 7, locked 0 MySQL thread id 6424, query…