…. Configuring Galera The configuration here is quite easy: wsrep_provider_options = “socket.ssl_cert=/etc/mysql/cert.pem; socket.ssl_key=/etc/mysql/key.pem” We simply configure the wsrep provider with our certificate and key files on…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… of descriptors optimization. Server Configuration: [mysqld] user=root port=3306 innodb_status_file=0 innodb_data_file_path=ibdata1:100M:autoextend…max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 …
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… by log copying thread is now configurable by innobackupex –log-copy-interval. Making the interval configurable allows to reduce the time between… been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer satisfied mysql dependency which is required…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5… by log copying thread is now configurable by innobackupex –log-copy-interval. Making the interval configurable allows to reduce the time between…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops… in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and Percona Server shows much better results Configurations…_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… tries and wait time between tries for all operations are configurable. Also, we removed –lock-wait-timeout which set innodb_lock… was not really aware of them. And it’s highly configurable, so you can make the tool try very hard to… pt-mysql-summary 2.2 have all the standard MySQL options built-in, like other tools: –user, –host, –port, –password, –socket, –defaults-file…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… malloc after the startup phase and hence its rather complex configuration. Probably most readers of this blog know (or should know… interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and pre-allocate the innodb… S3. Why? The push to S3 was especially puzzling since MySQL was not involved. The server was running with nearly 7GB…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… we did some R&D on Percona MYSQL server and found that Percona need some configuration setting regarding to memory allocation. So we did some memory allocation setting in my.cnf file. On first….cnf file, site performance was good. But from second day again performance degradation started and now it is slow again. MySQL load…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 29, 2013 By 26 Comments
…’s patch above, or TokuDB for MySQL or TokuDB for MariaDB, I consistently get failure in ./configure: CMake Error: The following variables… sure they are set and tested correctly in the CMake files: TOKUFRACTALTREE_LIB linked by target “tokudb” in directory /data/tmp…
Post: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
We’ve released an updated version of the MySQL Configuration Wizard we announced at the end of last year. If … things like sharing configuration files and emailing them to yourself. The new release also adds features like downloading the configuration files so you don’t have to copy-paste them. If you share a configuration file, then the URL…
