…currently connections to a single node (by default, localhost). The state of…number of nodes in the cluster. Node This is state data about the local node that the tool happens to be connected…open transactions. In…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
…: Optimization phase currently remains). …of problems with PHP prepared statements. It is getting…connection or multiple connections. Do not forget to close prepared statements – Many memory leaks reported in MySQL…In newer versions you can also use prepared_stmt_count variable to track number of open…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…current number of waiters, plus you can see wait status information “wait is ending” in…number of locked rows – there are normally many rows for each lock structure. For each of connections for MySQL…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…philosophy of openness. It also…the current performance, future…of GNU/Linux, I keep working to get a picture of…the connection properly)….paste in mysql> show global variables like ‘%table_size%’; …of the analysis we do. A lot of times, customers will tell us up front to limit the work to some number of…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…in 587MB of raw data, mostly in one table (lineorder). Each of the 13 queries were executed serially in a single connection…In MySQL 5.6 the default value of…NUMBER_READ_AHEAD_EVICTED: 0 READ_AHEAD_RATE: 1240.5728847456533 READ_AHEAD_EVICTED_RATE: 0 LRU_IO_TOTAL: 531 LRU_IO_CURRENT…Opening…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…currently, I needed to change it in my.cnf and restart the nodes) wsrep_provider_options = “pc.ignore_quorum = true” break again connection…number of…
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
…number of presentations about MySQL, Percona Server, and MariaDB. We also have been open in supporting the events of other organizations including MySQL Connect organized by Oracle in…
Post: Rare evil MySQL Bug
November 20, 2009 By 7 Comments
…in accept: Resource temporarily unavailable filling out disk space Depending on the case you may be able to connect to MySQL… in production so we had to restart MySQL quickly currently I have a test MySQL… gets pretty high socket number – probably because of large innodb_open_files I tested with in …
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…Open Source friendly. So what does this tool do and how it works ? Currently…of solve it with using read-only user for slave connection…of servers in clusters to upgrade OS or add more RAM to the system. This tool works well for number of…
Post: Living with backups
November 6, 2008 By 28 Comments
…getting in the way of…in at runtime anyway. To check what is the current setting you need to query your block devices. In case of… opening…MySQL status every second and in case the number of connected threads goes above 50, it sends STOP signal to the archiving process. Whenever the number of connected…
