…49 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: InnoDB free:…Index_Length fields. Doing more tests with Inserts I can see Innodb seems to always…can cause significant space use overhead if small tables are used The information in INFORMATION_…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
… NULL Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: 1 row… to incremental compression which Archive engine uses, still it should have done much … converting MyISAM table rather than incremental insertions. I also compared it to compressed MyISAM …
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 141 Comments
…, with increment of 1Mb/day) — I have used a table MyISAM, info from phpmyadmin: Collation utf8_general_ci lenght row 122 row dimension avg 194… configure InnoDB for best performance?) – what parameters i need to insert manually in my.cnf for best performance & low disk usage…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL (Yasufumi Kinoshita). Compatibility Collations Two new collations, utf8_general50_ci and ucs2_general50_ci…collations introduced: utf8_general_ci to utf8_general50_ci, and ucs2_general_ci to utf8_general50_ci. Blueprint:utf8-general50-ci…
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
… a bit with INSERT … SELECT I decided to check is Innodb locks …:31:51 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: InnoDB free: 1591296…of memory, which is small fraction of memory used on serious systems. Furtermore you would unlikely need…
