June 19, 2013

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

…in the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or …use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If you’re …before it occurs. For example, if you see a large number of long-running queries in the output …

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

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

…avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact… it will have the same impact. For large datasets effective compression results in the need…InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno….

Filed Under: MySQL

Post: What's required to tune MySQL?

July 27, 2011 By 4 Comments

… you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt its … need more than simply looking at your my.cnf file. It’s sometimes possible to look at … large gains that go far beyond configuration alone. [1] I prefer to avoid the word “tuning,” because database …

Filed Under: Insight for DBAs, MySQL

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

October 28, 2012 By 4 Comments

…true’. Q: Can you quickly show the my.cnf settings again? A: Sure, see this post … built-in mysql replication are independent from each other. Q: I installed Percona as cluster database working with… apply here, in large zabbix deployments, you may want to partition your large history tables, so …

Filed Under: MySQL, XtraDB Cluster

Post: New SpecJAppServer results at MySQL and Sun.

November 12, 2008 By Leave a Comment

…database 4 cores was enough. Does it mean the J2EE system got saturated before the database ? Or does it mean MySQL…MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf…_size = 1600M – another Benchmark optimization. Such large logs typically will cause too long…

Filed Under: Benchmarks

Post: Why you should ignore MySQL's key cache hit ratio

February 28, 2010 By 28 Comments

…manage to reduce Key_reads, we might make the database server faster overall, and perhaps the query of …set — the index blocks that are frequently used. How large is that? This is yet another thing that’…a shame. When you are new to MySQL, trying to configure my.cnf, and you have heard guidance that …

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

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

June 9, 2011 By 13 Comments

…-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld…. concurrently. Because the customer was running a database which was way bigger than 16G, I’… system alignment should have really interesting effects. Large stripe on the other hand should somewhat…

Filed Under: MySQL

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

February 26, 2013 By 1 Comment

…features introduced with InnoDB full-text search), that’s largely where the similarities end. NOTE 1: I was …our database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw-rw—-. 1 mysql mysql … lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that …

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

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

…mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main database, I believe different applications work best on different database…innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as … a good way to get large data manageable. MySQL Master Master Manager can help …

Filed Under: Insight for Developers Tagged With:

Post: How innodb_open_files affects performance

November 18, 2009 By 4 Comments

… be open or closed. Furthermore besides MySQL table_cache Innodb maintains its own (… tables: 091118 18:43:36 InnoDB: Database was not shut down normally! InnoDB: …max_files_open in InnoDB: my.cnf. InnoDB: fil_sys open file LRU…300 is not being that large liability even with large number of tables and…

Filed Under: Insight for DBAs, MySQL Tagged With:
« Older Posts