MySQL
From ICISWiki
Database backends > MySQL
Performance Tuning
Query Optimization Tips
Server Configuration
- MySQL Performance Blog
- Tuning MySQL Server by IBM
- Linux Magazine Article - need to be a registered user to access the article. Registration is Free.
As a summary, setting the right values for the following variables in the MySQL Configuration file will help maximize server performance.
- key_buffer_size
- table_cache
- max_allowed_packet
- sort_buffer_size
- read_buffer_size
There are also variables in the configuration file that are storage-engine specific, such as:
- innodb_buffer_pool_size
- innodb_additional_mem_pool_size
- innodb_log_file_size
- innodb_log_buffer_size
- innodb_flush_logs_at_trx_commit
FREE database migration tool: MS Access to MySQL
(Posted April 18, 2007)
Freeware! Download now at: http://www.bullzip.com/products/a2m/info.php
NEW Transactional Storage Engine for MySQL: PBXT
(Posted March 12, 2007)
MySQL.org: "PBXT is an ACID compliant transaction engine that offers all the right features for MySQL users who are on the hunt for an engine to keep their transactional data safe. PBXT sports crash recovery, unlimited row-level locking, MVCC, foreign keys/server-enforced referential integrity, automatic storage management, minimal configuration setup, and online backup support. And if that doesn’t get your attention, did I mention that PBXT (at least from some simple testing I’ve done) provides very good performance too?"
Read more at: http://dev.mysql.com/tech-resources/articles/pbxt-storage-engine.html
New Release of MySQL Connector/J 5.0.5 (GA)
(Posted March 12, 2007)
MySQL Connector/J 5.0.5 is a new version of the Type-IV pure-Java JDBC driver for MySQL
- suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0, MySQL-5.1 beta or the MySQL-5.2 Falcon "Preview"
- list of changes: http://dev.mysql.com/doc/refman/5.0/en/cj-news-5-0-5.html
- download at: http://dev.mysql.com/downloads/connector/j/5.0.html
Falcon: New MySQL Storage Engine
(Posted February 15, 2007)
- designed to support high-volume user traffic in tandem with very fast and secure transaction management
- supplies data management professionals with all the right features needed to support critical transaction-based systems that manage key needs in their business.
- Download at: http://www.mysql.com/why-mysql/white-papers/falcon-getting-started.php
MySQL Tools for Visual Studio 1.1.0 (Alpha)
(Posted February 1, 2007)
MySQL Tools for Visual Studio is a downloadable plug-in for Visual Studio 2005 that allows Windows developers to quickly build MySQL data-driven applications with Visual Studio. Download MySQL Tools at: http://dev.mysql.com/downloads/visual-studio-plugin/index.html
solidDB: Alternative for Innodb storage engine.
(Posted January 26, 2007)
SpikeSource, December 20 2006: "According to early figures, solidDB is running twice as fast in terms of transactions per second against a 1million row database. Released under dual licensing, solidDB is officially supported and is free for download and use with MySQL on both Linux and Windows."
- More information available at: http://dev.soliddb.com/doc/docs-win/doc_html/soliddb_storageengine.html
- Release notes: http://dev.soliddb.com/doc/docs-win/doc_html/release_notes.html
Do the new features in MySQL 5.0 apply to all storage engines?
(Posted January 25, 2007)
The general new features such as views, stored procedures, triggers, INFORMATION_SCHEMA, precision math (DECIMAL column type), and the BIT column type, apply to all storage engines. There are also additions and changes for specific storage engines. See: http://dev.mysql.com/doc/refman/5.0/en/faqs-storage-engines.html#qandaitem-26-2-3.
NEW features of MySQL 5.0 include cursors, triggers, stored procedures and views.
(Posted January 25, 2007)
See: http://dev.mysql.com/doc/refman/5.0/en/mysql-5-0-nutshell.html.
