Hot answers tagged xtradb
2
When I head the word 'Percona Server', the first thing that jumps at me is : "Does the DB Server have multiple CPUs?" These days, that is taken for granted. What is unfortunate is that most people forget to configure MySQL or Percona Server to summon those multiple CPUs.
MySQL 5.1 with InnoDB 5.1 Plugin, MySQL 5.5 and Percona Server have options to increase ...
2
I think you want wsrep_sst_method=skip not wsrep_sst_mode=skip
mysql> show variables like 'wsrep_sst%';
+---------------------------+------------+
| Variable_name | Value |
+---------------------------+------------+
| wsrep_sst_auth | |
| wsrep_sst_donor | |
| wsrep_sst_method | ...
2
OBSERVATION #1
Since your buffer pool is 6G (6144M), the innodb_log_file_size should be 1536M (25% of 6G)
OBSERVATION #2
You have sync_binlog set to 1. This provides the safest ACID compliant setup. It can also slow things down dramatically. You say it seems as though its writing each row 1 at a time to disk. That's the case because each completed DML ...
1
If the table reportingdb.norep_zonebannertmp_bk does not exist on one of the nodes in the Cluster, this could be the source of your problem. Why? TRUNCATE TABLE is DDL. That will close the current transaction PXC has during WriteSet Operations. This cannot be rolled back. I would expect a PXC communication problem at COMMIT time because TRUNCATE TABLE causes ...
1
IMHO there should be no real difference. However, let me add this:
I actually wrote something up on this a while back
How do I properly perform a MySQL bake-off?
Why mysql 5.5 slower than 5.1 (linux,using mysqlslap)
Query runs a long time in some newer MySQL versions
In my posts, I mentioned InnoDB 5.1 Plugin outperforming native InnoDB 5.1, 5.5, 5.6 ...
1
InnoDB in Percona Server 5.0.91 and MySQL 5.5.x has three options
innodb_read_io_threads
innodb_write_io_threads
innodb_io_capacity
These options were introduced in MySQL 5.1.38 InnoDB Plugin
Tuning these will engage more CPUs within InnoDB/XtraDB
I have discussed this in past posts in the DBA StackExchange along with other InnoDB tuning suggestions
...
Only top voted, non community-wiki answers of a minimum length are eligible
