Global Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open up…. However you should keep in mind some limitations of the current implementation. This post is …servers have gtid_mode set to ON. Could it be interesting to run file-based replication when …
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…not really change until MySQL Server implements Global Resource Management as…limit on undo segment size. Another possibility is to use queries which use large temporary tables or sort files… stored procedure and set 1M result set to each of them… temporary tables, so by opening large amount of cursors…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…in mysql> show global variables like ‘%table_size%’; +———————+———–+…MySQL server’s limitation… set …openings in chess — the great chess players study openings…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… 2 rows in set (0.00 sec) Adding ignore quorum and restart both nodes: set global… loss. Remove ‘/var/lib/mysql//grastate.dat’ file and restart if you wish…: trivial donor: options: gcs.fc_limit=9999999; gcs.fc_factor=1…11:42:51.292 INFO: Shifting OPEN -> PRIMARY (TO: 19) 2012-…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options…/mysql.sock bind-address=10.234.94.71 skip-locking key_buffer_size = 2000M max_allowed_packet = 32M # table_cache=20M # open-files-limit…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
…limiting factor for this system quite soon, so I decided to check what is limiting MySQL…set global long_query_time=0 and restarting slave does not pick up the change. I of course could just restart MySQL…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… in place, we can begin. Open command line (shell) on the…SET SESSION and SET GLOBAL. min_examined_row_limit=# Don’t log queries which examine less than min_examined_row_limit rows to file…SET SESSION and SET GLOBAL. Downloads msl patch for MySQL 5.0.45 msl patch for MySQL 5.0.51a msl patch for MySQL…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…MySQL thread id 30898, query id 100626 localhost root Updating update iz set…MySQL thread id 8079, query id 728899 localhost root Sending data select sql_calc_found_rows * from b limit…showing details of file IO: ——– FILE I/O … read views open inside InnoDB Main …design as requiring global lock to …
Post: Living with backups
November 6, 2008 By 28 Comments
…MySQL tables into a text file or ordinarily copies the binary files…files, in order not to saturate the I/O you can limit… current setting you …file that was opened with O_DIRECT flag, the file needs to be aligned to the file…€¦ my $sth= $dbh->prepare(‘SHOW GLOBAL STATUS LIKE “Threads_connected”‘); ……
