… … innodb_data_home_dir = /var/lib/mysql innodb_log_group_home_dir = /var/lib/mysql … #>innobackupex-1.5.1 –databases=saturn –user…: Using mysql Ver 14.14 Distrib 5.1.31, for unknown-linux-gnu (x86_64) using readline 5.1 innobackupex: Using mysql server version…: Connected to database with mysql child process (pid=32443) 090321 00:41:00 innobackupex: Connection to database server closed 090321 00:41…
Comment: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 26, 2012 By 33 Comments
… of concurrently running threads. Ovais, you’ve written that the MySQL Server implementation has the buffer pool mutex as a bottleneck, while…. But I doubt it’ll be as great when the server is better tuned. I agree with what you originally wrote…’ve done too much good work to just leave that unknown.
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
January 19, 2012 By 102 Comments
…’m having problems. I have 3 servers, both have the standard mysql db’s setup as in mysql_install_db, created a replication…, status=complete): unknown error p_mysql:0_start_0 (node=tabit, call=20, rc=1, status=complete): unknown error p_mysql:0_start_0 (node=meissa, call=20, rc=1, status=complete): unknown error Any idea’s…
Comment: Introducing percona-patches for 5.1
May 18, 2010 By 21 Comments
… have a server on Ubuntu Hardy with the following installed: ii libmysqlclient15off 5.0.90-percona-b21.hardy.3 MySQL database client… Percona SQL database server binaries Is the userstat patch included? mysql> set global userstat_running = ‘ON’; ERROR 1193 (HY000): Unknown system variable ‘userstat…
Comment: Choosing innodb_buffer_pool_size
January 24, 2010 By 39 Comments
…in the middle of a working day. For an unknown reason… the crash recovery takes to nothing. … copied fine expecially the mysql directory… Cool (I thought) now with a working mysql installation + the exact logs…on our server are 10MB while ibdata is 50MB, users are 6 and server was win 2003 server …
Comment: Copying InnoDB tables between servers
July 1, 2010 By 11 Comments
… Debian (via apt-get install percona-server-server) Once mysqld is running and I login via the mysql client tool, I get the following error when setting the “innodb_expand_import” variable. “Unknown system variable ‘innodb_expand_import’” Is the XtraDB plugin installed and loaded by default? How can I see my MySQL software…
Comment: Modeling InnoDB Scalability on Multi-Core Servers
January 31, 2012 By 11 Comments
…, Thank you for your tip, I downloaded the latest percona server but ran into the following error. Any idea ? Thanks, Hiromichi… number 1604009568 120131 16:00:44 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable ‘innodb-adaptive-hash-partitions=8′ 120131 16:00… sequence number 1604009568 120131 16:00:49 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 120131 16:00:49 mysqld_safe…
Comment: Interesting MySQL and PostgreSQL Benchmarks
December 1, 2006 By 20 Comments
… issue was unknown to me before reading your blog. It seems amazing to me that a feature/engine in MySQL that is touted as a perfect replacement for enterprise solutions in regards to Oracle, MSSQL Server, DB2 etc… InnoDB for a long time, how can MySQL expect enterprise level clients switch to MySQL? The money such clients would save on…
Comment: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
Our (MySQL) failure rate is… unknown, really. The #1 cause of database downtime has been me (…. I have to say I’m completely blown away by MySQL‘s stability. Apart from the datafile corruption a couple of…, growing by about 120 GB/yr. These are commodity (Dell) servers – cheap and easy. Hell, with the starting price of EMC…
