Question : I’m running a Percona-Server instance off an Ubuntu server install. I’m using an application that needs to access […]
Tag: percona-server
Is the innodb_lazy_drop_table problem solved?
Question : I’m researching database configuration for MySQL/MariaDB. I’ve been reading the configuration chapter in “High Performance MySQL”. In there, […]
innodb buffer pool size not changing
Question : I have Percona fork of MySQL 5.7 installed where I have defined innodb_buffer_pool_size in /etc/percona-server.conf.d/mysqld.cnf as follows innodb_buffer_pool_size […]
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 […]
Syntax Error when Creating a Temporary Table Using A Subquery That Contains A Union All
Question : So what I’m trying to do is create a temporary table with a unioned set of results that […]
MySQL Handler_read_rnd_next == tablescans without indexes?
Question : I am in the process of tuning our Percona 5.5 server, and have been using percona’s tools to […]
-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 […]