… give away. But first — have you ever wondered what servers are in your MySQL replication hierarchy? We have, too. As consultants, a… version 1.0.6-unknown +- [redacted].compute-1.amazonaws.com Version 5.1.43-60.hardy.7-log Server ID 19924124 Uptime… InnoDB version 1.0.6-unknown +- 10.153.116.5 Version 5.1.57-rel12.8-log Server ID 1165 Uptime 20…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… ask is MySQL Replication Lag. The story is typically along the lines everything is same as before and for some unknown reason… as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most… buffer pool. Automatic Buffer Pool Save/Restore available in Percona Server is great help in this case. Changing Slave Role Changing…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… Rev 78 for 5.0.83 unknown-linux-gnu (x86_64) xtrabackup: cd to /data/vadim/mysql/export/ xtrabackup: This target seems…. Both files should be copied to remote server. Now on remote server you have to run MySQL server ® with XtraDB6 storage engine, you can take one of our binary builds with 5.1.36. On new server we…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… meta data to be lost. Not good for system running mySQL Server. As far as I understand this problem is limited to…: 54 GB Reserved blocks uid: 0 (user unknown) Reserved blocks gid: 0 (group unknown) First inode: 11 This has a lot of… is probably not needed for partition you store MySQL data on, as chances are MySQL server is only one doing writes on this…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 868 Server version: 5…’ to clear the current input statement. percona1 mysql> use test ERROR 1047 (08S01): Unknown command If you try to insert data just…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… valid MySQL account and they have been normally treated very quickly by MySQL. The moment you give someone access to MySQL Server, all MySQL Security… you can stop one from overtaking the server. This will not really change until MySQL Server implements Global Resource Management as otherwise you… old MySQL versions which typically have more issues. P.P.S Nothing I write here is security hole which is unknown to MySQL…
Post: How to check MySQL Config files
February 12, 2008 By 7 Comments
… option the server when would refuse to start when it restarted, either on operating system restart or recovering from MySQL Server crash. In any case it is quite nasty. Unlike Apache MySQL service control script does not…/mysqld –help 080212 12:39:30 [ERROR] /usr/libexec/mysqld: unknown variable ‘myis_test=1′ This does not do complete check…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
… truly wonderful things, including more in depth testing of the server. Amazingly enough, spin-offs from this work included being able… shows. In MySQL 5.5 you can find in sql/datadict.cc a function named dd_frm_type(). In MySQL 5.1, for some reason yet unknown to humans, it lives in sql/sql_view.cc as mysql_frm_type…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
… unknown expected votes 1 Resources configured. ============ Online: [ monitor hamysql ] Install MySQL For the sake of simplicity, we will just install the MySQL version in the Ubuntu repository by doing: root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL …
Comment: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… if not the default port ‘dsn’ => ‘mysql:host=hostname;dbname=percona’, … $explainhosts = array( ‘label1′ => array( ‘dsn’ => ‘mysql:host=hostname1:3306′, ‘user’ => ‘user… Fatal error: Can’t connect to the database server. (test@:/) SQLSTATE[HY000] [2005] Unknown MySQL server host ‘localhost:3306′ (0) [#2005] in /home/html…
