…will be also available on percona.tv). Let’s take tpcc schema and running standard MySQL ® 5.0.83, and assume …files should be copied to remote server. Now on remote server you have to run MySQL server ® with XtraDB6 storage engine, you … Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 …
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 868 Server version: 5.5…
Post: Announcing Percona Server for MySQL 5.6.10-60.2
March 14, 2013 By Leave a Comment
… 5.6.10-60.2[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.6.10-60.2 on March 14… 5.6.10, including all the bug fixes in it, Percona Server 5.6.10-60.2 is the third ALPHA release in the Percona Server 5.6 series. All of Percona‘s software…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…were single server from generic application. Right. Default configuration for Percona …, 1000000 rows affected (1 min 14.12 sec) Rows matched: 1000000 …Percona XtraDB Cluster related configuration # PXC Settings for Version: ‘5.5.29-55-log’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 Percona…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… I diagnosed it on one customer’s server. The server is running a Percona build of 5.0.84, so I have microsecond logging…_read: 0 # administrator command: Quit; # User@Host: webuser[webuser] @ [10.14.82.196] # Thread_id: 3329398985 Schema: app_db # Query_time… disabling or reconfiguring some part of the server. Interestingly, the above is happening on a server that’s really NOT running that…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…you can see them in information_scheme database in Percona Server though). The structure of these tables is following: …_SPACE_OR_CHKSUM 4 /* in < MySQL-4.0.14 space id the page belongs to (== 0) but … has valid checksums: #./innochecksum /var/lib/mysql/ibdata1 # 5. Now you can start MySQL and take a …
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
July 4, 2012 By 38 Comments
… long term stability of linux distros. I don’t use Percona though, only stock oss MySQL. I only had experience with… what the world was so concerned about. Development server had java and mysql-5.5.14 take 100% cpu each, though both continued to…. Great for desktop, not so for database servers. Ergo now all my database servers run Gentoo, production uptimes are 1.5y, 1…
Comment: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… may try galera replication http://www.mysqlperformanceblog.com/2011/07/14/percona-server-5-1-with-galera-replication/
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
… results are quite discouraging. My setup: Dell PowerEdge R900, running Percona-Server-5.1.57-rel12.8 (will be in public release soon… can see 1 Mutex at 0xe13880 ‘&buf_pool_zip_mutex’ 14 Mutex at 0xe13780 ‘&LRU_list_mutex’ Apparently using compressed tables…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… how to properly build the server to use it (bug 61587). We at Percona regularly use Memcheck for … 5.5: mtr-helgrind-55.patch Now let’s see what kind of goodies does Helgrind find on MySQL server… a previous write of size 8 by thread #14 ==9090== at 0x6BC4594: srv_error_monitor_thread (srv0srv….
