Questions tagged [xtradb]
XtraDB : Enhanced InnoDB Storage Engine
22
questions
0
votes
1
answer
39
views
Percona/XtraDB Database with many of writes to a small table uses less CPU than the same database with less writes?
I'm trying to understand why Percona and xtradb InnoDB/MySQL behaves the way it does and if there's anything I can change in the configuration to fix it.
I've a InnoDB database with only one table ...
- 1
0
votes
1
answer
319
views
Can XtraDB be enabled on MariaDB 10.2
Can we create a table in MariaDB 10.2 with XtraDB engine?
I have installed MariaDB 10.2 and I am trying to create a table with storage engine XtraDB and I am getting error
*mysql> CREATE TABLE T1(ID ...
1
vote
1
answer
1k
views
MySQL PXC node failing to receive state
I have three nodes that I want to setup into a Percona XtraDB Cluster (PXC). I have bootstrapped the first node and joined the second node, but cannot somehow join the third node. All configuration is ...
- 333
1
vote
1
answer
74
views
Percona xtradb Backup for OLTP
I have installed MySQL 5.7 community edition installed.
Can we use Percona xtradb backup tool for backup DB for banking site databases for OLTP?
- 133
0
votes
1
answer
300
views
Percona XtraDB cluster backup solution
We have a 3 node percona xtradb cluster and two slaves attached to it. One of the slaves we want to use it for taking backups. We have GTID based replication setup between the slave and the Xtradb ...
3
votes
1
answer
691
views
Hybrid Synchronous / Asynchronous Replication?
We have a situation where we would like to have synchronous replication in our main data center, but replicate asynchronously to another region. Our second data center is 3,000 miles away (Site B) and ...
- 467
2
votes
1
answer
691
views
SQLyog and MariaDB engine
I am quite new in MariaDB and I use SQLyog Community Edition as the frontend GUI. Whenever I create a new table, on the Engine dropdown, there is no XtraDB option. Is there any additional steps I am ...
- 23
1
vote
1
answer
563
views
In which situations is TokuDB higher performance? [closed]
I noticed that WordPress runs quite a bit faster when I use XtraDB (MariaDB's InnoDB replacement) instead of TokuDB. This is strange, because TokuDB is advertised as being 20x faster.
However, I ...
- 111
1
vote
1
answer
1k
views
mariadb 5.5.36 with innodb plugin
I installed mariadb 5.5.36 on a win32 system. Everything runs fine except innodb requests are 2 x slower than an identical MySQL installation. So I want to switch back to original innodb plugin to ...
- 11
4
votes
1
answer
982
views
Is the innodb_lazy_drop_table problem solved?
I'm researching database configuration for MySQL/MariaDB. I've been reading the configuration chapter in "High Performance MySQL". In there, it suggests that innodb_lazy_drop_table can be used to ...
- 143
1
vote
0
answers
365
views
MariaDB Galera Cluster
I have two mariadb servers in cluster that is working galera and xtradb.
it is my primary server configuration:
[mysqld]
datadir=/var/lib/mysql
query_cache_size=0
binlog_format=ROW
...
- 11
1
vote
1
answer
909
views
Native replication from Percona XtraDB Cluster to a standard stand-alone slave
I'm replicating from one node of a three-member Percona XtraDB cluster to a separate slave, using regular MySQL replication. The node is set to write binlog in ROW mode, with log_slave_updates=true ...
- 157
0
votes
1
answer
87
views
Indexes on XtraDB tables
I have old db with myisam tables, using mariadb and want try move to xtradb for row-level locking. Each table have 27 columns, primary index and other 11 indexes. Columns with indexes have many ...
- 253
1
vote
1
answer
8k
views
Why should I use InnoDB and MySql instead of XtraDB and MariaDB? [closed]
Why should I use InnoDB and MySql instead of XtraDB and MariaDB, except that InnoDB and Mysql happen to be installed by default on my servers?
Why isn't MariaDB and XtraDB installed by default ...
- 199
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
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
3
votes
1
answer
3k
views
MariaDB and XtraDB/InnoDB plugins
In my vps, I thought of switching from MySQL to MariaDB (using Monty's repository for Debian Squeeze). Copying over my.cnf from MySQL to MariaDB, I saw that the new config file (the one from the ...
- 239
3
votes
1
answer
2k
views
Does this make my XtraDB Cluster hang?
After seeing the following in the error log on the second node:
121003 7:16:06 [Note] WSREP: Member 0 (joiner) synced with group.
121003 7:16:06 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)
...
- 1,006
2
votes
1
answer
639
views
Percona XtraDB Cluster: How to skip SST when starting?
Is there a way to skip State Snapshot Transfer (SST) at startup on Percona XtraDB Cluster Server?
wsrep_sst_mode=skip doesn't work:
121003 6:49:55 Percona XtraDB (http://www.percona.com) 1.1.8-...
- 1,006
2
votes
2
answers
2k
views
Is there any performance difference among MariaDB (xtradb plugin) and XtraDB Server for InnoDB? [closed]
Title says it all. However i have to enter at least 30 characters.
- 131
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
1
answer
4k
views
MariaDB XtraDB Performance Tuning
I believe that innodb has a single read thread. However, with MariaDB you can set multiple read threads. I'm unsure what the recommended value would be.
Questions
Does anyone have any experience ...
- 1,100