Question : I am in the process of tuning our Percona 5.5 server, and have been using percona’s tools to […]
Tag: percona-server
-number”
Question : From your status lists, here is what I see 96GB Buffer Pool Buffer is 85.8345% Full (88477548544 / […]
How to properly replicate and archive at once
Question : I have a 300GB database that is growing around 5GB a day. It stores time-based data, and as […]
Is there a way to get slow-query-log-like profiling information on a single query?
Question : Specifically, I’m looking for this information: # Query_time: 0.011922 Lock_time: 0.000088 Rows_sent: 107 Rows_examined: 663 Rows_affected: 0 Rows_read: […]
MySQL InnoDB does not return the last row on select with DESC order
Question : We have a table scheme like following: CREATE TABLE IF NOT EXISTS `offers` ( `id` int(11) NOT NULL […]
Optimize Percona MySQL InnoDB 3.2TB database
Question : (Before you will call me an idiot or start laughing, please remember it’s a real deal on my […]
MySQL/Percona Server is taking long and I’d prefer to skip all this waiting even if it means data loss
Question : Originally posted to https://www.facebook.com/groups/GNUAndLinux/permalink/10155020539805019/ but no replies received. I run Percona Server 5.6.21-70.0-688 x64 on Ubuntu Server 12.04 […]
How do you identify InnoDB table corruption?
Question : I have some tables that are partitioned and have several indexes on a replicated slave. After copying the […]
Remove node from percona xtradb cluster
Question : I have a 5 node cluster. When I run backups it locks the entire cluster. I use DDL […]
Replicating into a Percona XtraDB Cluster
Question : We have a 2 node (plus an arbiter) Percona XtraDB cluster. It is used for data indexing/archiving. It […]