May 25, 2012

Post: Top 5 Wishes for MySQL

…PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes …data to the multiple databases and handle data merging on application together with high availability and … tables and other tricks we use when such need arises but we still can’t deny – MySQL

Comment: MySQL VIEW as performance troublemaker

… SHOW CREATE TABLE viewname). Mysql prefers MERGE over TEMPTABLE if possible, because MERGE is usually more efficient. // ***Views have slow performance on tables with large amount of data http://bugs.mysql.com/bug.php?id…

Comment: MySQL VIEW as performance troublemaker

… SHOW CREATE TABLE viewname). Mysql prefers MERGE over TEMPTABLE if possible, because MERGE is usually more efficient. // ***Views have slow performance on tables with large amount of datahttp://bugs.mysql.com/bug.php?id=23135…