… assign a permanent DNS name (like pi.yourdomain.com) by binding the reserved IP to a DNS …server [########################################################] 100% Installing MySQL system tables… OK Filling help tables… OK [...more setup information, please read...] [Optional] Set Percona server …
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… option too. Assuming root, here’s how to do it: cd /root mkdir -p bin cd bin wget http://aspersa.googlecode.com… the other settings, but this is often all you need. Finally, make sure that the script can log into MySQL (if necessary…. There are many things that can cause a stall in MySQL, and they usually begin microscopically and get worse over time…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… duplicate-key checking. The most important difference between these two options is that the second one is a global variable that… and needs a server restart to change its value. Both options cause phantom reads (non repeatable reads) so in order to… source of information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
….com | | wsrep_provider_version | 2.1(r113) | | wsrep_ready | OFF | And if you test to use the mysql server: [root@percona1 ~]# mysql…| +—-+—————+——–+ 2 rows in set (0.00 sec) Adding ignore quorum and restart both nodes: set global wsrep_provider_options=”pc.ignore_quorum=true…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…com) 1.1.8-rel25.3 started; log sequence number 246661644 120619 13:21:19 [Note] Recovering after a crash using mysql…log global mode http option tcplog option dontlognull retries 3 option redispatch maxconn 2000 …state variable. To set it up, create the clustercheck user. mysql> grant process on *.* …
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…quite likely would not have change their result set but MySQL has no way to identify which … statements which you can calculate by (Com_insert+Com_delete+Com_update+Com_replace)/Qcache_hits . These are …your all query cache option query_cache_limit was implemented which limits result set which can be …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… a full rundown over every option in the file. But again… | 1708212 | | Bytes_sent | 216162991863 | 7796961 | | Com_admin_commands | 255868807 | 11893 | | Com_alter_db | 0 | 0…mysql.* tables, running mk-duplicate-key-checker to find redundant indexes, and so on. As with settings and status, these set…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…set (0.00 sec) mysql> SHOW INDEX_STATISTICS LIKE ‘hosting2%’; +——————————————–+———–+ | Index | Rows_read | +——————————————–+———–+ | hosting2.wp_options.option… in this article, then Bluehost.com CEO, Matt Heatton, has published …
Post: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
January 19, 2007 By 17 Comments
… support them Right ? Wrong. In fact setting tmp_table_size is not enough as MySQL also looks at max_heap_table_size… what you would read in MySQL manual as far as I understand it: From http://dev.mysql.com/doc/refman/5.0/en…:00, ted@ted.mysql.internal +6 -0 BUG #4291 fix: new configuration option “disk-tmp-table-size” introduced to set maximum expected on…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 20, 2008 By 34 Comments
… settings are bad to use? Most likely using 1GB as readbuffer for a general mysql server is far worse than having it set… my.cnf which comes with mysql is that those figures doesnt seem to reflect recommendations from mysql.com themselfs. Even if there are special cases where 1GB readbuffer might be a better option I believe that optimal options for…
