… you close connection MySQL can clean them up. Killing connections (or stopping related applications) and observing whenever memory usage shrinks can be… have created which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… all database sizes tend to always grow and very rarely shrink. Which leads to a challenge faced by almost everyone… do. Using this application I can then compare using MySQL to using MySQL + Memcached, and then to other solutions like Tokyo Tyrant… all database sizes tend to always grow and very rarely shrink. Which leads to a challenge faced by almost everyone how…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best bet. (Actually, XtraDB might… there are indexes other than the primary key, we can shrink the primary key’s width: create table ads_by_day… save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… been normally treated very quickly by MySQL. The moment you give someone access to MySQL Server, all MySQL Security guarantees is you can… have executed prepared statement. Innodb Table Cache Leak – Innodb never shrinks its internal table cache (data dictionary) so by creating and… can reduce system performance beyond being functional. General Overload As MySQL does not have much of resource utilization control you can…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
… table it often makes sense to keep it compressed. Unfortunately MySQL does not provide compressed BLOB/TEXT columns (I would really… of both worlds by taking COMPRESS/UNCOMPRESS functions from the MySQL code and having them work on the application side as… think about how many rows you will be able to shrink down so they fit back to the page or at…
Comment: MySQL File System Fragmentation Benchmarks
October 10, 2008 By 28 Comments
… really dangerous ! Because there is a “bug” in MySQL InnoDB which don’t shrink the file ibdata1 after a DROP Database without… here: http://bugs.mysql.com/bug.php?id=15748 http://bugs.mysql.com/bug.php?id=1287 http://bugs.mysql.com/bug.php… a production enviroment…. http://crazytoon.com/2007/04/03/mysql-ibdata-files-do-not-shrink-on-database-deletion-innodb/ best regards gregor
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
…what caused your system tablespace size to explode – they will shrink to the normal size and all what you have …’re running Percona Server the following can be helpful: mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ | rseg_id | space_id | zip_…
Comment: Finding out largest tables on MySQL Server
April 24, 2012 By 27 Comments
… that the size of the table.ibd file will not shrink if data is deleted. However, what I’m wondering is…/lib/mysql/databasename # ls -lh tablename* -rw-rw—- 1 mysql mysql 8.7K 2010-08-05 16:31 tablename.frm -rw-rw—- 1 mysql mysql…
Comment: Choosing innodb_buffer_pool_size
January 20, 2011 By 39 Comments
…. the main db is innodb, myisam is used for the mysql-system-tables(small-sized). the production-innodb-database allocates now… 19GB big. i know that innodb – ibdata – files will never shrink, so i have to drop and import the data to… 16GB of RAM, most of this would be available to mysql because there is no other productive service running. so far…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
September 30, 2009 By 29 Comments
… log entries collect in the tablespace… from here (http://dev.mysql.com/doc/refman/5.1/en/multiple-tablespaces.html) i… remain at 100GB. and now i have no way of shrinking this back (unless i do a mysqldump and load which… .ibd / .frm files and then put them on a new mysql instance. is there any way of avoiding the ibdata file…
