…MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use reasonable global buffers, such as innodb…MySQL can clean them up. Killing connections (or stopping related applications) and observing whenever memory usage shrinks…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… brings me to my next point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually… But you still have to think about how to avoid enormous tables that are hard to maintain, back up, and…indexes other than the primary key, we can shrink the primary key’s width: create table …
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
…row will need to be decompressed) it also makes data easier to work with with console MySQL tools. …data size and performance gains, especially for Innodb tables. With Innodb tables BLOB gets its own page (…also think about how many rows you will be able to shrink down so they fit back to the page…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions like Tokyo Tyrant … tend to always grow and very rarely shrink. Which leads to a challenge faced by almost everyone how …2GB, and 4GB. For these tests I left Innodb with a 256M buffer pool, or roughly …
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 1 Comment
… would not know what caused your system tablespace size to explode – they will shrink to the normal size and all what you have… example MySQL CACTI Templates will have the graphs you need. If you’re looking at SHOW INNODB STATUS this is how you can…’re running Percona Server the following can be helpful: mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ | rseg_id | space_id | zip_size | page_no…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… using mysql_stmt_send_long_data call – Server buffers such data until you have executed prepared statement. Innodb Table Cache Leak – Innodb never shrinks… to MySQL Team. What I’m trying to do is pretty much explain the issue so there is no misunderstandings on how secure is MySQL…
