vbtechsupport.com

Tagged: innodb

cpanel / mysql / projects

MySQL Benchmarks: MySQL 5.5.11 vs Percona 5.5.10-20.1 vs MariaDB 5.2.5 – InnoDB and MyISAM

Updated MySQL benchmark results for MySQL 5.5.11 vs Percona 5.5.10-20.1 vs MariaDB 5.2.5 were made possible as I managed to gain further access to the Quad Intel Xeon Nehalem-EX L7555 Octo-Core 1.86Ghz, 64GB memory server.  Apparently, it sat untouched for nearly 3 weeks after I last used the server as...

cpanel / mysql / projects

MySQL Benchmarks – MySQL 5.0.92 vs 5.1.55 vs 5.5.10 vs Percona 5.1.55 vs Percona 5.5.8 vs MariaDB 5.2.5

It’s not everyday that I get the opportunity and access to a 64 cpu core monster server with Quad Intel Xeon L7555 1.86Ghz Nehalem-EX processors and 64GB DDR3 memory! Yes, technically it’s 4×8 = 32 physical cpu cores with additional 32 virtual cores via Intel Hyperthreading. I’d like to thank...

mysql

MariaDB 5.2.5 MySQL released

Late news but MariaDB MySQL 5.2.5 was released a couple of weeks back. MariaDB 5.2.5 is based on MySQL 5.1.55 with XtraDB InnoDB plugin from Percona Server 5.1.54-12.5. MariaDB version based off MySQL 5.5 seems to close too. MariaDB 5.2.5 release notes Download MariaDB 5.2.5 here: http://downloads.askmonty.org/mariadb/5.2.5. Tried a test...

mysql

MySQL Table Engine Data Usage statistics

Came across a useful MySQL query at themattreid.com blog to use MySQL information_schema to calculate MySQL table engine data usage statistics for Innodb and MyISAM. select round(sum(innodb_data_size + innodb_index_size) / (innodb_data_free + sum(innodb_data_size + innodb_index_size))) * 100 as ‘innodb_tablespace_utilization_perc’ , (data_size + index_size) / gb as total_size_gb , index_size /...