MySQL Optimization and Performance Tips

at · Tags: , , , , , , ,

  • Store IP addresses as INT, not CHAR – by using INET_ATON to convert from a string to an integer and by using INET_NTOA to convert from an integer to a string
  • Use non-persistent connection, since they are light-weight – much faster create than compared Oracle or PostgreSQL

  • Use the right storage engine; this means for example the ARCHIVE-engine for logs and other kind of INSERT-only operations, and the MEMORY-engine for fast in-memory data that should go away on server restart

More general MySQL optimization and performance tips are available in this Slideshow.

Related posts:

  1. Optimize MySQL for Low Memory Use
  2. Optimize MySQL Performance With MySQLTuner
  3. MySQL Performance Monitoring and Optimization Tools
  4. MySQL Concatenate: Adding String At The End Of Field Data
  5. Howto: How to Reset the MySQL Root Password
  6. Linux Terminal Speed Performance Comparison
  7. MySQL: Remove Duplicate Entries
  8. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
  9. Slow Query Log Analyzes Tools
  10. Migrate existing Ext3 filesystems to Ext4

Popular Related Items »

2 Comments »

  1. Cody said,

    June 15, 2008 @ 16:05

    Good point, this improved my SQL performance.

    Thanks,
    Cody

    http://www.ticket-vault.com

  2. Satya Prakash Karan said,

    October 12, 2008 @ 12:08

    Good simple and stringht.

RSS feed for comments on this post · TrackBack URI

Leave a Comment