… package managers like apt and yum can test and resolve dependencies before even installing …easy as stopping MySQL, updating symlinks or your my.cnf basedir, starting MySQL and running mysql_upgrade. Unlike… alter MySQL‘s default behavior i.e. disabling and totally disallowing use of query cache or…
Post: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
…do just that called the Configuration Wizard. I tested it out once just to see what …options to prevent common problems MySQL users run into because of too-permissive MySQL behaviors. These are the kinds… a visual EXPLAIN tool, a configuration advisor, a query analysis tool, a way to register a server…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…test | Query | 0 | NULL | show processlist | | 6 | msandbox | localhost | test | Query | 3 | Waiting for table metadata lock | RENAME TABLE test_2 to test | | 10 | msandbox | localhost | test…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
… the complete SQL. These tests were done using ‘run_query.php’, which is the example application which comes with Shard-Query. As the name… queries runs significantly faster than just running the SQL via MySQL. The remainder of Vadim’s queries use subqueries in the FROM clause, which Shard-Query…
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
…running query – Run an ANALYZE TABLE on a table accessed by the long running query So first we need a long running query…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
… you test your SELECT queries against multiple MySQL servers and reports on how each type of query performs from every server you let it test… you are upgrading your hardware alongside your MySQL version, you should also consider running these tests on similar hardware and OS configuration. Sometimes…
Post: Concatenating MyISAM files
November 19, 2012 By 5 Comments
… mysql> flush tables; Query OK, 0 rows affected (0.01 sec) Then, at the shell command line: root@django:/var/lib/mysql/test# ls test… (0.00 sec) mysql> flush tables; Query OK, 0 rows affected (0.00 sec) root@django:/var/lib/mysql/test# myisamchk -rq test_concat – check… wrong number of deleted records myisamchk: error: Run recovery again without -q MyISAM-table ‘test_concat’ is not fixed because of errors…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…; Query OK, 0 rows affected (0.00 sec) Populate the table with data for the benchmark. # sysbench –test=oltp –db-driver=mysql –mysql-engine… Let’s run the bechmark against the 3307 port. # sysbench –test=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… we used for testing. Even though box had 8 cores it is little use for MySQL as only one query is ran concurrently… box had. MySQL Also was very slow running some queries so we changed scripts a bit to kill extremely long running queries to get results for others this means we can’t really get a valid TPC-H result from MySQL,though…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
… quality control queries automatically, we can run them at any time: $ cat generate_foreign_key_checks.sql | mysql -N | mysql -E *************************** 1. row *************************** test.Bar… same SQL queries for quality control: mysql> CREATE TABLE test.MY_KEY_COLUMN_USAGE LIKE INFORMATION_SCHEMA.KEY_COLUMN_USAGE; mysql> INSERT INTO test.MY…
