…MySQL…allow…set_connectionblogpercona.commanual character_set_databaseblogpercona.commanual character_set_filesystemblogpercona.commanual character_set_resultsblogpercona.commanual character_set_serverblogpercona.commanual character_set_systemblogpercona.commanual character_sets…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
…together and when dumped to binary log as one big chunk which can’t be interleaved by any …chopping and run update in chunks if application allows it. In MySQL 5.1 with row level replication you will…SELECT query and the table to which store its result set and use in your application in all cases when…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… created a conference website that allows people to create an account … Erisman, who has experience running big events at his previous employers …results, how to do super-advanced and extreme things with MySQL, how to use MySQL…somewhere, telling about his experiences setting up replication, than to …
Post: MySQL Session variables and Hints
December 28, 2006 By 2 Comments
MySQL has two ways to find tune execution of particular query. First is MySQL Hints, such as SQL_BIG_RESULT… hints are used much more frequently than setting session variables for given query execution even … The great solution I think would be to allow per session variables to be changed only …
Post: MySQL Stored Procedures problems and use practices
June 12, 2007 By 21 Comments
…not a big fan of Stored Procedures, At least not in the form they are currently implemented in MySQL 5…and other doing same thing using direct statements. This allows to debug and profile most of the things …if it can help you to avoid sending large result set back to the client as in this case server…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
…MySQL Storage Engines, and pluggable storage engines as MySQL 5.1 lays ? It is very much advertised this allows…you can do. Such limit is not a big surprise though as execution layer is much …of rows in result set and LIMIT implementation – these can optimized but not by use of MySQL Storage Engine …
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… is too big, and now we again hit the limit set by innodb_log_file_size. The 15-minute average result for this… I can get with MySQL 5.5.8. The 15-minute average result is 37235.06 NOTPM. This allows me to draw a… space. And, the Percona Server result is ~2x better than the best result I received with MySQL 5.5.8 (with innodb_doublewrite…
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 12 Comments
…so I can get grouped result set together with total value for the groups: mysql> select grp, count(*) …allow us to use ORDER BY together with GROUP BY WITH ROLLUP can we still do something to get the result set… set (0.00 sec) As I forced FileSort execution method for GROUP BY by using SQL_BIG_RESULT…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… this setting provides the best throughput innodb_io_capacity=20000; a difference from the FusionIO case, it gives better results for MySQL… different settings of innodb_io_capacity for MySQL 5.5.8. Small innodb_io_capacity values are really bad, while 20000 allows us… tpcc-mysql workload with 1000W. The main factors that allow us to get a 1.4x improvement in Percona Server are: Big log…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… significant amount of data. One big reason for this is the … pivot_results cd shard-query/ $ ./run_query < queries.sql | tee raw |./pivot_results & [1] 12359 …/log/mysqld-innodb.log max-allowed-packet=1M net-buffer-length=16K…COMMITTED user=mysql wait-timeout=86400 To be continued You can now set …
