Global Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open…. 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 …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in… = 2000M max_allowed_packet = 32M # table_cache=20M # open-files-limit=20000 table_cache = 3072 open_files_limit = 9216 tmp_table_size=1000M sort_buffer_size…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… which highlighted replication could be the limiting factor for this system quite soon…time when it is set online, meaning changing it via set global long_query_… the time Innodb takes to open tables first time after start. … Happily it supports “raw” query log file which is basically queries one query…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…. Once you have it all in place, we can begin. Open command line (shell) on the server and go to the… SET SESSION and SET GLOBAL. log_slow_rate_limit=# Rate limit statement writes to slow log to only those from every (1/log_slow_rate_limit… both SET SESSION and SET GLOBAL. min_examined_row_limit=# Don’t log queries which examine less than min_examined_row_limit rows to file. If…
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… ‘/var/lib/mysql//grastate.dat’ file and restart if you wish to …: trivial donor: options: gcs.fc_limit=9999999; gcs.fc_factor=1….11:42:51.292 INFO: Shifting OPEN -> PRIMARY (TO: 19) 2012-07…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…change until MySQL Server implements Global Resource Management as otherwise …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
…safe –defaults-file=/etc/my.cnf –pid-file=/var… in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name |…As with settings and status, these set the stage… MySQL server’s limitation of one-…openings in chess — the great chess players study openings…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… root Updating update iz set pad=’a’ where i=2 ***… use. Innodb tries to limit thread concurrency allowing only…is section showing details of file IO: ——– FILE I/O ——– I/…in queue 1 read views open inside InnoDB Main thread process …is by design as requiring global lock to provide consitent …
Post: Living with backups
November 6, 2008 By 28 Comments
… data files, in order not to saturate the I/O you can limit …To check what is the current setting you need to query your …file that was opened with O_DIRECT flag, the file needs to be aligned to the file…= 1; } … my $sth= $dbh->prepare(‘SHOW GLOBAL STATUS LIKE “Threads_connected”‘); … if ($$row[1] …
