… Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar Example Schema…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad… tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter values…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
You are hitting a fundamental (and in my opinion bad) part of the design of MySQL 5.6 global transaction ID. In general, there is no ordering implied between events, because multi-threaded slave may… events missing. Well, if the user is not using multi-threaded slave, perhaps the notion of “last executed” and “specific point…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…- mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this …read_buffer_size=131072 max_used_connections=13 max_threads=2002 thread_count=6 connection_count=6 It is possible…56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another …
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… server can easily handle the write load of all the MySQL instances. The original idea was to configure them with raid… this, maybe it is related to better raid controller write cache use. Even the fairly slow gzip-1 mode works well… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… to faster restore time XtraBackup makes MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We…
Post: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
…, free, fast-paced and very technical MySQL educational event for wide range of people interested in MySQL – Developers, System Administrators, DBAs, etc… speaking opportunities available – if you would like to share your MySQL story at this event please email Matthew Dowell by Tuesday…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log tells us why the IO thread has…:21:26 3130 [ERROR] Slave I/O: The slave IO thread stops because the master has GTID_MODE OFF and this…:32:08 2563 [ERROR] Slave I/O: The slave IO thread stops because the master has GTID_MODE ON and this…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… there was some short-term glitch you encountered. At any rate this is a very old post – and as you mentioned…’s the url: http://www.percona.com/forums/questions-discussions/mysql-and-percona-server I’ll sure someone from our community…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… illumos ZFS by giving up 10% total ram for metadata caching, but it is just the price you should be willing… OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker. Maybe you guys…
