…3 (it crashed and hung every so often). Latest updated RedHat 5.4 promised some more fixes to SystemTap…mysqld dm-0 R 4358144 0 2883 2879 pam_timestamp_c dm-0 R 6528 0 2324 2296 …project and currently author is fighting with resolving userspace issues. I gave to this a try, but on my current RedHat…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…0.8.2 still says: “MySQL Proxy is currently an Alpha release and should not be used…forward to. Q: What about write splitting (updates,inserts) on multiple MySQL servers? Or is it possible … the system timestamp into a dummy table once per second on the master. As these timestamp values replicate to…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… timestamp included in the last executed sql statement. As some of them are looping, the timestamp …on the passive master, but that could also create another loop in case the replication of events with the current…-options-slave.html#option_mysqld_log-slave-updates [4] http://dev.mysql.com/doc/refman/…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
… was renamed to innodb_current_row_locks. (Yasufumi Kinoshita)…timestamp_always. (Oleg Tsarev) Old system variable slow_query_log_microseconds_timestamp was renamed to slow_query_log_timestamp… Fixes Bug #724674 – Ported an updated version of the original… importing .ibd files created on MySQL 5.0 or…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… 5.5.29-30.0 is now the current stable release in the 5.5 series. All… log was displayed incorrectly when slow_query_log_timestamp_precision variable was set to microseconds. Bug fixed #887928… that is present only on slave server while there are updates on the replicated table on the master which is …
Post: Edge-case behavior of INSERT...ODKU
October 27, 2012 By 6 Comments
…) NOT NULL, host_id TINYINT UNSIGNED NOT NULL, last_modified TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY(id), UNIQUE KEY(username) ) ENGINE… currently set to 2. If we do an INSERT … ODKU on this table, we see the following: (root@localhost) [test]> insert into update_test (username,host_id) values (‘foo’,1) on duplicate key update…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… include them via supplemental repositories i.e. updates on CentOS. If you are using InnoDB, it … exec_time=1 error_code=0 SET TIMESTAMP=1329980395/*!*/; DROP TABLE `salaries` /* generated by server */ … Now… binary log is created, looking at the current binary logs after restoring the snapshot, I …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…replication_delayblogpercona.commanual innodb_rollback_on_timeoutblogpercona.commanual Innodb_row_lock_current_waitsblogpercona.commanual Innodb_…commanual tx_isolationblogpercona.commanual unique_checksblogpercona.commanual updatable_views_with_limitblogpercona.commanual Uptimeblogpercona.commanual …
Comment: Edge-case behavior of INSERT...ODKU
October 28, 2012 By 6 Comments
…updated, then selecting out the current values from the table into a local array to establish what needs inserting / updating…. of some intermediate table/log. Write the timestamp to THAT log and use that in … Also, safest is to use select for update on the user table to avoid race conditions — …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
….000000 # InnoDB_pages_distinct: 973 SET timestamp=1325146286; select count(*) from auto_inc;…of the Percona Server instance running on my personal Amazon micro instance. …, 26.23M rss, 62.49M vsz # Current date: Thu Dec 29 07:09:32 … 0.0022 1.00 0.01 UPDATE wp_options # 7 0x7AEDF19FDD3A33F1 0.1381 …
