… load onto their database server. Their MySQL server became CPU-bound, while their …’ve optimized the majority of the most frequently-accessed code, even if not… like it might contain SQL reserved words? If we did that, how would… This type of security issue is as common a SQL injection, and you can …
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
…the wsrep_local_state_comment — basically a plaintext word describing the state of the node in terms…replication queue activity, and I find this is common except during cluster stalls. There are clearly a…zeroes, but we do see some replication conflicts. Mostly these are brute force aborts, but I …
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…common case. If you have a very simple workload, you can calculate these values by hand. But for most…the expense of the PK lookups). In other words, if you’re optimizing for throughput in …type=uniform –max-time=300 –mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf …
