June 18, 2013

Post: Replaying database load with Percona Playback

October 25, 2012 By 9 Comments

…to show how to meassure the impact of my.cnf changes replaying a slow query log. The service starts with an empty my.cnf…is in production and where our customers are working. DEV is where we are going to test all …The tool is under active development. If you find any bugs we would appreciate it being …

Filed Under: Insight for DBAs, MySQL

Post: Profiling MySQL Memory Usage With Valgrind Massif

January 9, 2013 By 3 Comments

… /path/to/mysqld {mysqld options…} Note that ‘{mysqld options}’ could for instance include –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in order to point mysqld to your settings file etc. After… other cmd line options to match the snapshot frequency etc. to your specific requirements. However, you’ll likely find that the default options…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

Post: Debugging MySQL SSL problems

November 8, 2012 By Leave a Comment

…!) Trying to find an option for the mysql cli that will output the actual SSL error (nary to be … ssl, and it had my SSL files correctly) Checking grants Double-checking the my.cnf for misspellings Restarting mysql…be some cases where it’s helpful to also run that in the root.  However, in my case the…

Filed Under: MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… wasn’t to find out how to make InnoDB FTS blazingly-fast, but simply to get a sense of how it works compared to traditional…_innodb3 where fts_doc_id=1; Philosophically, I find that kind of behavior unsettling. I don’t like case-sensitivity in my table… names to begin with (I may be one of the few people that likes lower_case_table_names = 1 in /etc/my.cnf…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6

February 21, 2013 By 6 Comments

… /etc/my.cnf,i add wsrep_cluster_address=gcomm:// to fill it ,the mysql server will not running [root@mysql1 ~]# vi /etc/my.cnf [mysqld…: 0×0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something… visiting http://www.percona.com/software/percona-server/. You may find information in the manual which will help you identify the…

Filed Under: MySQL Tagged With: , , , , , ,

Post: Data compression in InnoDB for text and blob fields

May 30, 2012 By 2 Comments

…`t1` WHERE `id` < 1000 compare this to: SELECT AVG(LENGTH(COMPRESS(`colTextField`))) FROM `t1` WHERE `…to effect the table compression modification (given the long run-time of the ALTER TABLE), you may find…to enable the  dynamic variable innodb_file_format=BARRACUDA (don’t forget to set it in my.cnf…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software

Post: Aligning IO on a hard disk RAID – the Benchmarks

June 9, 2011 By 13 Comments

…to live in the first terabyte of the device which seems to have affected the performance here (IMO that’s because of where…87 with the following my.cnf configuration: [mysqld] datadir=/data…to look at IO alignment on Flash cards to see what benefits we can get there from proper alignment. You can find…

Filed Under: MySQL

Comment: How much memory can MySQL use in the worst case?

February 12, 2009 By 17 Comments

… on my servers. I mean I’m certainly hitting a MySQL/InnoDB memory leak because whatever values I put in my my.cnf, I… used than when I first launched mysqld. So far all my attempts to find where the leak was failed (the issue is that I…). Unfortunately in this aspect, MySQL is not really good to display information about where it spends all the used memory :-( If you…

Filed Under: Insight for DBAs Tagged With:

Post: Updated msl (microslow) patch, installation walk-through!

April 20, 2008 By 17 Comments

…starting 5.1.21 release. Below you will find the files to download, but first let me walk you … command line (shell) on the server and go to the directory where the sources archive and the patch is. …the logging. If you don’t specify it in my.cnf file, the remaining part of the configuration will …

Filed Under: Percona Software Tagged With:

Post: MySQL: what read_buffer_size value is optimal ?

September 17, 2007 By 25 Comments

… should set this variable to some high value. Sample my.cnf values on large memory … tests. mysql> select count(*) from dt2 where slack like “a%”; +———-+ | count(*) | +———-+ | 4705992 | +———-+ 1 row… realistic load and realistic data (including fragmentation) to find what works best…

Filed Under: Benchmarks, Insight for DBAs Tagged With:
Newer Posts »