… do it all, create a new file called 91-mysql.conf in limits.d, but it no work. mysql soft nofile… put file 91-mysql.conf contents into limits.conf and get same 1024 value. What do i wrong? My OS Centos 6.4…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
In your my.cnf conf I don’t see barracuda file format and did you create your table using row_format = compressed with InnoDB which enables tablespace compression ?
Post: linux.conf.au 2012 roundup
January 24, 2012 By Leave a Comment
… helping people admin machines – go and watch those talks. linux.conf.au (for me) is one of the cannot-miss events… few (err… only) talks that is repeatedly accepted into linux.conf.au. Why? Because Jon manages to compress a whole year… time working on Drizzle. Mentoring: we’re Doing It Wrong My Talk: Multi-tenancy, multi-master, sharding, scaling and analytics with…
Comment: Percona build7 with latest patches
November 20, 2008 By 26 Comments
Yasufumi, how the less or more optimal my.conf file should looks for persona MySQL to keep let’s …-only mode, and also in read/write (50/50) mode? my current conf: (for MySQL 32bit) [mysqld] max_connections=2000 key_buffer…
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
… evaluating InnoDb as alternative because deletes are awfully slow and my partitioned table with 800 million rows crashed.. Our servers have…, 8 cores 3 GHz. high speed Raid level 1 disks my.conf parameters –> key_buffer_size=512M table_open_cache = 512 sort… thread_cache_size = 20 query_cache_size =0 Here is my current schema.. CREATE TABLE ObjectInstances_MRG_T ( `ObjInstance` VARCHAR(20…
Comment: Why MySQL could be slow with large tables ?
August 22, 2010 By 141 Comments
Eddie, this depends on 1. Your MY.CONF settings http://www.notesbit.com/index.php/web-mysql/mysql/mysql-tuning-optimizing-my-cnf-file/ 2. The type of table it is — is it MYISAM or INNODB? For InnoDB, you may also fix the INNODB specific settings.
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 17 Comments
… on RHEL 5. I add the following line to /etc/my.conf: innodb_log_file_size = 104857600 #also tried innodb_log_file…
Comment: What's required to tune MySQL?
July 27, 2011 By 4 Comments
I must 100% agree to Baron, few months ago I did “tuning” and bench-marked results. Configuring my.conf for InnoDB 70% read workload gave me only 5-7% improvements of query response times.
Comment: 5.4 in-memory tpcc-like load
May 3, 2009 By 11 Comments
… case it’s important to know both). What was your my.conf during this test and how many sessions did you run…
Comment: Returning to InnoDB scalability
August 4, 2006 By 42 Comments
… usable was to put innodb_thread_concurrency=4 in our my.conf . For the SHOW MUTEX STATUS output , here you go :: mysql…
