…,domain names and other IP to help level the playing field for community participants as well as define the governance – the…’s relation with the MySQL Community and the MySQL Ecosystem. We’re not here to pick sides or get involved in politics. We’re here to make our customers successful running MySQL and, along the way, to contribute to the MySQL…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… in MySQL. This is very helpful for measurement as otherwise we might not catch some long running connections. Now let’s get… 1.00 0.00 SELECT data_template_rrd data_input_fields # 16 0xBE797E1DD5E4222F 0.0524 0.6% 79 0.0007 1… underlying tables involved and the query execution plan used by MySQL. The end result might be that you end up limiting…
Post: Maximal write througput in MySQL
February 28, 2010 By 10 Comments
… was asked what maximal amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have high… simple benchmark. I took sysbench update_key scenario ( update indexed field on simple table) and used Dell PowerEdge R900 with 16…_at_trx_commit = 1. So with binary logs serialization is getting even worse. Enabling sync_binlog makes things really bad, and…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
…to the ‘ping’ or ‘statistics’ command at the MySQL protocol level, which will increment Com_admin_commands… But high-traffic apps put tremendous effort into getting query times down, and some highly tuned …fine in the lab, and even in the field, until performance really starts to matter — and then…
Post: Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon
March 19, 2013 By Leave a Comment
…MySQL experts: Domas Mituzas, Database Engineer Harrison Fisk, MySQL Performance Engineer Yoshinori Matsunobu, Database Engineer Their breakout session is entitled “MySQL… Performance Replication” will cover his field experiences of having high …available until March 24th so get your pass now, before …
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… log in spite of this. You could still get a report of the most frequent queries, even …IN_SET(sql_text, ‘Sleep,Quit,Init DB,Query,Field List,Create DB,Drop DB,Refresh,Shutdown,Statistics,… command: ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql`.`slow_log`; GO echo “#” I host the script …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…summarized in the table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-… of concept setup is a good way to get used to a technology and experiment with … All the times here are estimates based on field experience, the values presented here are fairly …
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
… that it has something to do with character fields and character sets, then you’d be absolutely correct… the InnoDB data directory for this database to get the actual filename of the temporary table rather … there’s something of an inconsistency present when MySQL won’t allow us to change an FK-…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 31, 2012 By 20 Comments
hi, Peter i don’t know what the `mysql -A` it real meaning? what is the “getting field list from all tables”? can you explain it more detailed ?
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
…. So, table_id and index_id of the dropped table gets overwritten. mysql> CREATE TABLE actor ( -> actor_id SMALLINT UNSIGNED NOT NULL…: n_fields (compressed ulint, 1-5 bytes) field_no (compressed ulint, 1-5 bytes) field_len (compressed ulint, 1-5 bytes) field data We know that sakila/actor is field #0…
