… thing to check for. VARIABLE=${VARIABLE:-Threads_connected} You need to change the threshold to 15, and the variable to Threads_running. Check… script can log into MySQL (if necessary, put a password into .my.cnf, or in the MYSQLOPTIONS variable). Now you can simply…, and sometimes the disks are responding very well but the server is abusing them and overloading them. And sometimes, of course…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… > show status like ‘Open%tables’; +—————+——-+ | Variable_name | Value | +—————+——-+ | Open_tables | 30 | | Opened_tables …MySQL server or causing all the connections to get depleted. There are some other interesting consequences as well for application that use MySQL…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… normally do is set the variable log_slow_verbosity to ‘full’, this variable is available in Percona Server and allows us to log… overview section. So say if you were using the vanilla MySQL server, you would see an entry like this in the slow… considering the fact that tmp_tbl_size variable is set to 32M on the server, so on-disk tables are probably being…
Post: Announcing Percona Server 5.5.24-26.0
June 1, 2012 By 9 Comments
… corruption. This bug was introduced in MySQL 5.5.18 and Percona Server inherited it from MySQL. Bug fixed #915814 (George Ormond Lorch… #997496 (Alexey Kopytov). Variable `thread_statistics` was a reserved word in Percona Server 5.5. As a result, the server variable with that name had to be quoted with backticks when used. Bug fixed #997036 (Vladislav Lesin). Release notes for Percona Server…
Post: Debugging MySQL SSL problems
November 8, 2012 By Leave a Comment
… for the mysql cli that will output the actual SSL error (nary to be found!) Running: SHOW VARIABLES LIKE ‘%ssl%’ (mysql was adamant… a basic HTTP-ish server: /usr/bin/openssl s_server -cert /etc/mysql/ssl/server-cert.pem -key /etc/mysql/ssl/server-key.pem -www Now… MySQL server outside the chroot and confirm SSL worked fine there. MySQL worked fine outside the chroot, and so did the basic openssl server…
Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
February 28, 2013 By 11 Comments
…MySQL Database Server on an Android Tablet[/caption] Following Roel’s post, Percona Server on the Raspberry Pi: Your own MySQL Database Server…mysql, which we start mysql> show variables like ‘version%’; +————————-+——————————+ | Variable_name | Value | …
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… for MySQL Server code and various small static buffers. This is memory which you can consider used when you just start MySQL Server. The rest of memory is available for connections. For exampe with 8GB server you might have everything… in practice and how memory consumption reacts to changing various variables. For example you may find out increasing sort_buffer_size…
Post: Announcing Percona Server 5.5.25a-27.1
July 21, 2012 By Leave a Comment
….1 milestone at Launchpad. New Features: Percona Server has extended standard behavior of variable secure-file-priv. When used with no argument… INTO OUTFILE statements will fail with the following error: “The MySQL server is running with the –secure-file-priv option so it… with MySQL 5.0 or older, importing that table could crash Percona Server in some cases. Bug fixed #1000221 (Alexey Kopytov). Server started…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_…stock MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server …
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…variable innodb_enable_unsafe_group_commit was deleted. The existing MySQL variable innodb_support_xa can be used instead. (Yasufumi Kinoshita) Old system variable…MySQL 5.0 or Percona Server versions prior to 5.1.7 could crash the server. (Yasufumi Kinoshita) MySQL bugs 56433 and 51325 – These MySQL…
