Questions tagged [percona-server]
Percona Server is a fork of MySQL Community Edition, focusing on performance improvements.
122
questions
3
votes
1
answer
376
views
MySQL Replication not proceeding
I have a weird replication problem I have not seen before. It's basic mysql replication with single master and two slaves. One of the slaves is not executing replication events and seems just stuck ...
- 5,203
2
votes
1
answer
889
views
Strange Locking issues while playing back logs via percona playback
Problem while replaying logs
I am in the process of benchmarking a new DB node (specs at the end) and have run across some strange behavior:
As described here i:
Created a dump (innobackupex ftw)
I ...
- 300
2
votes
2
answers
2k
views
any documentation on tpcc-mysql benchmark tool
Where can I find tpcc-mysql documentation? I google it but I can't find any documentation about it.
- 663
2
votes
1
answer
2k
views
Unknown storage engine 'XtraDB'
I installed Percona Server 5.6.12-rc60.4, when I want create table such as :
CREATE TABLE IF NOT EXISTS `mydb`.`table` (
`id` INT NOT NULL AUTO_INCREMENT ,
`title` VARCHAR( 64 ) NOT NULL ,
PRIMARY ...
- 663
2
votes
1
answer
801
views
How big can innodb_doublewrite_file grow?
When I use the enable innodb_doublewrite_file ...
How big can this file grow ?
How can I calculate the optimal disk size, if it would be used only for this file?
2
votes
1
answer
728
views
How often should MySQL (stock, Percona, etc.) be upgraded?
My organization runs several data-driven web applications backed by various flavors of MySQL on RHEL (i.e. we're just like everyone else!) Some of our web apps use the standard build of MySQL, and we ...
- 292
2
votes
2
answers
3k
views
Slow INSERTs to MEMORY table
I've been trying to work this issue out, been really killing me! We've been experiencing some slow database queries for a Prestashop installation that we host, and a look into the query log revealed ...
- 21
1
vote
1
answer
573
views
MySQL InnoDB does not return the last row on select with DESC order
We have a table scheme like following:
CREATE TABLE IF NOT EXISTS `offers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`campaign_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`price` double ...
- 111
5
votes
3
answers
8k
views
MySQL information_schema doesn't update
I have a database, say abc, in mysql server. It has only one table named test. test uses innodb engine and I've set innodb_file_per_table to true.
After I run the query delete from abc.test, I want ...
- 271
4
votes
1
answer
5k
views
InnoDB temporary table location
I have a busy InnoDB table that expands and contracts regularly in size on a daily basis based on it's load. Typically, we'd see the table grow to 80GB in size (50/50 data and indexes) and then shrink ...
- 143
3
votes
1
answer
9k
views
Very poor insert performance MySQL / Percona Server
I'm running a Percona-Server instance off an Ubuntu server install. I'm using an application that needs to access this database, and its having VERY poor performance. Once the database has been ...
- 33
2
votes
1
answer
3k
views
Queries getting stuck on very simple COUNT queries
process list:
| 16004 | metrics | xxx:64616 | metrics | Query | 29064 | Sending data | SELECT COUNT(*) FROM Plugin where LastUpdated >= '1356856200' | ...
- 21
27
votes
3
answers
62k
views
Should a MySQL replication slave be set to read only?
I've got replication running on Percona Server 5.5 by following this guide and wondered if I should add read-only=1 to my slave's my.cnf to make it read only?
The guide sets up replication for the ...
- 749
2
votes
1
answer
516
views
Assertion failure from InnoDB while restoring using Innobackupex
I thought I would give back to all those people who help me when I have a problem. This might be something old, but I did not find it anywhere so here goes:
We recently upgraded our production DBs ...
- 300
1
vote
2
answers
350
views
Is there a way to get slow-query-log-like profiling information on a single query?
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: 107
# Bytes_sent: 4152 Tmp_tables: 3 ...
- 260
11
votes
1
answer
10k
views
Capabilities of InnoDB INSERT Performance
Hi I am running the most recent version of Percona Server.
Server version: 5.5.24-55 Percona Server (GPL), Release 26.0
I have a 10 cpu box of these characteristics.
processor : 0
vendor_id ...
- 339
3
votes
1
answer
4k
views
MySQL Handler_read_rnd_next == tablescans without indexes?
I am in the process of tuning our Percona 5.5 server, and have been using percona's tools to plot our database's performance.
In the MySQL Handlers Plot, i have been noticing alot of "...
- 300
8
votes
1
answer
11k
views
Do you still use MyISAM or prefer Aria storage engine?
If Aria storage engine (previously called Maria) is the "new" MyISAM, which supports transaction and automatic crash recovery:
Why still use MyISAM ?
Should changing storage engine from MyISAM to ...
- 1,989
24
votes
2
answers
23k
views
Percona vs MySQL
What is Percona?
How does it differ from MySQL?
When should we consider switching (or upgrading) from stock MySQL to Percona?
To add some specifics in our situation we almost exclusively use ...
- 510
6
votes
1
answer
2k
views
Tuning dedicated Percona Server with XtraDB for OLTP
Hardware specs for an OLTP DB
dual quad core xeon with hyperthreading
24GB ram
Hardware RAID10 BBU
Software specs
Standard install of Ubuntu 10.04LTS with default LVM partitioning
Installed Percona ...
2
votes
2
answers
438
views
Is there any reason not to use Percona 'innodb_fast_checksum'?
I recently came across a change that Percona Server implemented over normal MySQL InnoDB. The new feature is innodb_fast_checksum
XtraDB can use a more CPU-efficient algorithm, based on 4-byte ...
- 23.3k
25
votes
4
answers
59k
views
How do you identify InnoDB table corruption?
I have some tables that are partitioned and have several indexes on a replicated slave. After copying the snap shot (verified safe) to a new slave and upgrading mysqld from 5.1.42 to 5.5.15 and ...
- 3,934