…MySQL creative error message: mysql> show tables; +—————-+ | Tables_in_test | +—————-+ | queue | | test_innodb | +—————-+ 2 rows in set (0.00 sec) mysql> show…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… tool takes what are usually global counters in SHOW GLOBAL STATUS and calculates the change each… to understand that this tool only currently connections to a single node (by default, localhost). … force aborts are applying writesets rolling back locally open transactions. In fact, this is a sysbench…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH…you can skip this step. 2) While holding connection open run: lvcreate -L16G -s -n dbbackup /dev/Main/Data…them – you just need to use SHOW SLAVE STATUS instead of SHOW MASTER STATUS to find out …
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…, however, which showed MySQL 5.6.10 to be much slower than MySQL 5.5.30 even with only a single connection. I felt… connection I modified the queries to use ANSI JOIN syntax. No other changes to the queries were made. Test Environment The MySQL….173893 | 13.027019 | 4979 | 21399 | 0 | 0 | 90 | 90 | | 5 | Opening tables | 0.270664 | 0.295955 | 0.025996 | 0.024996 | 34…
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
… many mature open source projects, such as Apache Software Foundation, Linux Foundation or FreeBSD Foundation. A Foundation structure shows to … about MySQL, Percona Server, and MariaDB. We also have been open in supporting the events of other organizations including MySQL Connect organized …
Post: Making the impossible: 3 nodes intercontinental replication
January 11, 2012 By 29 Comments
In this post I want to show new possibilities which open with Percona XtraDB Cluster. We will create 3 nodes Cluster … 3 node traditional MySQL ring replication, but this is not what you want to use day-to-day. To show how it… that the communication is done using open channels, and you may want to establish an encrypted connection, using it in real life…
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
… statement text not only “Execute” but in SHOW INNODB STATUS you would still see statements … connection or multiple connections. Do not forget to close prepared statements – Many memory leaks reported in MySQL …_stmt_count variable to track number of open statements diretly. You can also adjust max_…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
…flights to come to Percona Live straight from MySQL Connect or cutting their stay short on one of… his inspiring Keynote. Clustrix have been showing their scalable MySQL compatible database solution built from the ground… Santa Clara – the call for papers is open until October 13 so do not delay your …
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…_mode). mysql> show warnings; +——-+——+————————————————————+ | Level | Code | Message | …ERROR 122 (HY000): Cannot open table handle for…mysqld but could not connect to mysqld anymore…
Post: Wanted: Better memory profiling for MySQL
May 18, 2008 By 4 Comments
…connection buffers which was not really freed to operation system ? Could it be some buffers associated with opened…based on per connection settings ? It also could be memory leak in MySQL or runaway stored… I would see it implemented similary to SHOW STATUS – threads could account statistics for …
