…MySQL 5.5). If you want to know more details, please read on! MySQL 5.0/5.1 First let’s consider MySQL 5.0 and 5.1…mysql> show slave status\G Empty set (0.00 sec) mysql> start slave; ERROR 1200 (HY000): The server…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… downloaded here So let us first take a look at MySQL 5.1.23 vs 6.0.4 results for 10GB data set which… site. For example These Are results recently published for Microsoft SQL Server. Of course this is much more powerful system but still… about it in his MySQL 5.1 vs 6.0 in TPC-H Queries post As a Summary: We can see MySQL capabilities to run…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes… now 8 instead of 1 optimizing for higher concurrency workloads. Makes sense as servers have a lot more… be practical if someone tries to enable it. sql_mode has NO_ENGINE_SUBSTITUTION value by default…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… total response time of the server: that’s typical of a …recommendation on when to use ENUM vs. CHAR? Especially for one character … and they will only need 1 byte per value. If you …5.5, and most should still be valid with 5.6. Q: I have good command of SQL query writing and wanted to learn MySQL…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
…data with SQL statements. I wanted to see how fast MyISAM vs. MonetDB would…Infobright, anyway. The tests I loaded 1 million rows into the table. …), sum(c129) from t where c11 < 5; Graphs of query performance time …storage engine plugged into MySQL. It’s a complete server with a different optimizer, …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…: 5.1.14-log build number (revision)=IB_3.2_GA_5316(ice) MonetDB version: server… After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA… that, so I generated big SQL file which contained load statements. … experiment was not really about InfoBright vs MonetDB comparison. My goal was …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…Oracle,MS SQL, PostgreSQL may not work well for MySQL and other … data stored in different servers), multi-server partitioning to use combined memory…1..100 selects about 1% of the table. The times for full table scan vs range scan by index: mysql…table was scanned in less than 5 minutes. Now if we …
