…hours worth of dump data, the script will run for 60 hours replaying it. This was important for…for our purposes (usually). foreach (sort keys %{$queries{$conn}}) { my $dt = $_; while((time() – $offset) connect(“DBI:mysql…prepare($_); $sth->execute(); $sth->finish(); } } $dbh->disconnect(); ###print “…
Comment: Solving INFORMATION_SCHEMA slowness
April 20, 2012 By 25 Comments
…procedures. It was taking the tool about one hour just to finish this query: “SELECT table_schema, table_name … rest of the percona tools that use the MySQL INFORMATION_SCHEMA ) allowing it to momentarily set innodb_… kind of queries), and leave the original value for that variable after it finishes. …
Post: Converting Character Sets
March 17, 2009 By 22 Comments
… have begun to migrate their databases to utf8. Googling for “mysql convert charset to utf8″ results in a plethora of sites…) Add FULLTEXT indexes back For those of us routinely waiting hours, if not days, for a single alter statement to finish, this is unacceptable…) Usage: convert_charset –database=database [options] Options: –askpass Prompt for a MySQL password –charset The target character set to convert to –collate…
Comment: Why MySQL could be slow with large tables ?
July 6, 2007 By 141 Comments
…(we actually) getting reprimanded for sending queries that take a long time to finish. (30min up to 2/3 hours). My queries are… partially de-normalised state and then loading them into the MySQL server. I suspect that this may make things faster. (At…, thereby minimising load on the main server or even the mysql server. (running on 5.0, so I can’t even…
Post: Some fun with R visualization
February 23, 2012 By 5 Comments
My previous post I finished with the graph with unstable results. There I won’t … for 4 and 16 tables cases running MySQL 5.5.20. Let me remind how I do measurements. I run benchmark for 1 hours…
Comment: Innodb Performance Optimization Basics
April 24, 2008 By 75 Comments
…buffer_pool_size). The MyISAM table finishes approximately 4 times faster than the … “Start Time for InnoDB: ” . $time_start . “\n”; $db = mysql_connect(“localhost”,”user”,”password”); for ($i=1;$i MyISAM results: 1532.69 seconds. (25.54 minutes) InnoDB results: 6815.43 seconds. (1 hour…
