June 18, 2013

Post: Percona Server 5.1.53-12.4

… version. Functionality Added or Changed  Percona Server 5.1.53-12.4 is based on MySQL 5.1.53.  New… at the configure stage. If yes, -lrt is added to LIBS. (Alexey Kopytov) Bug #673929 – Query cache misses were being reported… found at Bugs in Percona Server. For general questions, use our Percona Discussions Group, and for development questions our Percona Development Group. For…

Comment: Making the impossible: 3 nodes intercontinental replication

… remove mysql-libs yes | yum -y install Percona-XtraDB-server Percona-XtraDB-client right BEFORE: yes | yum -y install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client and then the mysql

Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6

… setup percona cluster in vm, if in file /etc/my.cnf,i add wsrep_cluster_address=gcomm:// to fill it ,the mysql… = no; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page…+0×27)[0x8132e67] /lib/libc.so.6(__libc_start_main+0xdc)[0xb05e9c] /usr/sbin/mysqld[0x8132d81] You may download the Percona Server operations…

Comment: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster

… to ‘/var/lib/mysql/error.log’. 130131 12:44:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130131 12:44… cert_index: [root@node3 ~]# service mysql start Starting MySQL (Percona XtraDB Cluster).. SUCCESS! [root@node3 ~]# grep IST /var/lib/mysql/error.log | tail -n 1…

Post: Recovery after DROP & CREATE

… next 8 bytes is index_id. In revision 69 of Percona Data Recovery Tool for InnoDB two tools are added: s… an example: # ./s_tables /var/lib/mysql/ibdata1 sakila/actor sakila/actor 15 # ./s_indexes /var/lib/mysql/ibdata1 15 0-18 0-19… redo log: # ./s_tables /var/lib/mysql/ib_logfile1 sakila/actor sakila/actor 15 # ./s_indexes /var/lib/mysql/ib_logfile1 15 0-18…

Comment: Visualization tools for pt-query-digest tables

…if not the default port ‘dsn’ => ‘mysql:host=hostname;dbname=percona‘, … $explainhosts = array( ‘label1′ => array( ‘dsn’ => ‘mysql:host=hostname1:3306′, ‘user’ => ‘user’, ‘…Notice: Undefined property: Database_pdo::$db in /home/html/QDU/libs/Database/Database/pdo.php on line 166 PHP Notice: …

Comment: Percona Server 5.1.53-11.7

…]: *** [mysql] Error 1 make[2]: Leaving directory `/root/Percona-Server1/client’ make[1]: *** [all] Error 2 make[1]: Leaving directory `/root/Percona-Server1… by me: Open /Percona-Server/libmysql/Makefile Find line 226: LIBS = -lcrypt -lnsl -lm -lz Change this line to: LIBS = -lrt -lcrypt -lnsl…

Comment: Which Linux distribution for a MySQL database server? A specific point of view.

…, but Percona has rescued me from the MySQL side of that issue. I will say that mixing in Percona‘s libmysql libs and such… the wrong libs combined with getting upset about the mysql config directory (due to multiple packages maintaining it) – but after Percona retagged their… toss in my (perhaps garbled – I’ve been reading the mysql-master-ha wiki all afternoon) comments. :)

Comment: xtrabackup-0.3, binaries and stream backup

… my.cnf … innodb_data_home_dir = /var/lib/mysql innodb_log_group_home_dir = /var/lib/mysql … #>innobackupex-1.5.1 –databases=saturn –user…_64) using readline 5.1 innobackupex: Using mysql server version 5.1.31-percona-log innobackupex: Created backup directory /tmp/2009-03-21_00-40-56 090321 00:40:56 innobackupex: Starting mysql with…

Comment: 5.0.75-build12 Percona binaries

…’ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql‘ ‘–with-unix-socket-path=/var/lib/mysql/mysql.sock’ ‘–with-pic’ ‘–prefix=/’ ‘–with-extra-charsets…=/var/lib/mysql‘ ‘–infodir=/usr/share/info’ ‘–includedir=/usr/include’ ‘–mandir=/usr/share/man’ ‘–enable-thread-safe-client’ ‘–with-comment=MySQL Percona High Performance…