June 18, 2013

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

… despair, you just have a bit more work ahead of you….sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0… int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE …of the actual SQL NULL value. This is basically a quick…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: ,

Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication

May 3, 2013 By 2 Comments

…pem Generating a 2048 bit RSA private key …………..+++ … be a default value, If you enter ‘.’, the…mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql…

Filed Under: XtraDB Cluster Tagged With: , ,

Post: Understanding the maximum number of columns in a MySQL table

April 8, 2013 By 5 Comments

… UI for generating reports. This evolved into the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM file… in MySQL, the defines can still found in the source. Basically, it’s why we can’t have nice things (like default values… are the options for ENUM or SET columns. The tricky bit is that it’s unique intervals, not actual intervals, so…

Filed Under: MySQL Tagged With: , , , , , , , ,

Post: Is Synchronous Replication right for your app?

May 14, 2013 By 18 Comments

…’s break it down a bit.  Our unit of locking in…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL… times specified by this variable (default is 1 retry).  This means …groups (user_id, group_id, joined) VALUES (100, 1, NOW()); Conclusion Choosing…

Filed Under: MySQL, Percona Software, XtraDB Cluster Tagged With: , , , , , ,

Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

November 29, 2011 By 102 Comments

…passwd: The credentials to test MySQL. Default is to run select count(*) on mysql.user table, so the … the important setting is “log_slave_updates = OFF” (default value). In some cases, if slaves are logging replication…in the main branch once it matured a bit. Finally, if you are interested by this …

Filed Under: MySQL

Post: What to tune in MySQL Server after installation

September 29, 2006 By 118 Comments

… them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how… times slower than MyISAM ? You probably forgot to adjust this value. Default value of 1 will mean each update transaction commit (or each…. Value 0 is a bit faster but is a bit less secure as you can lose transactions even in case MySQL Server crashes. Value 2…

Filed Under: Insight for DBAs Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… configuration of InnoDB full-text search and discovered a little bit of quirky behavior; here, we are going to run some… use the latin1 character set. mysql: CREATE TABLE innodb_ft_list2 ( value VARCHAR(18) NOT NULL DEFAULT ”) ENGINE=InnoDB DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.02 sec) mysql: SET GLOBAL…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Joining many tables in MySQL - optimizer_search_depth

April 20, 2012 By 8 Comments

… execution time to less than 50ms. Low values, such as 3,4 provided a bit better performance but I decided against using… 0 is automatic selection why do we have value of 62 being default in MySQL 5.5 which can produce very expensive plan… if we assume MySQL users do not join lots of tables (less than 7) when using 0 as default value would not impact…

Filed Under: Insight for DBAs, MySQL

Post: How Percona diagnoses MySQL server stalls

March 3, 2011 By 6 Comments

… show up as abnormally high values of Threads_connected or Threads_running… your definition of “abnormal” — by default it has some vanilla settings that …it and see which bits are diagnostic and which bits show nothing relevant. …that can cause a stall in MySQL, and they usually begin microscopically …

Filed Under: Insight for DBAs, MySQL

Post: How to Monitor MySQL with Percona's Nagios Plugins

February 22, 2012 By 11 Comments

… ships by default with many server installations) or a system administration mistake to delete one of MySQL‘s … there is no good one-size-fits-all value. This plugin, perhaps more than any other, should …_connections. Overflowing the max_connections setting is a bit like a lack of disk space: it is …

Filed Under: Insight for DBAs, MySQL
« Older Posts