MySQL Optimization and Performance Tips

February 21, 2008 at 19:52 · 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.

VN:F [1.8.5_1061]
Rating: 0.0/10 (0 votes cast)
VN:F [1.8.5_1061]
Rating: 0 (from 0 votes)

Related posts:

  1. Optimize MySQL Performance With MySQLTuner
  2. Optimize MySQL for Low Memory Use
  3. MySQL Performance Monitoring and Optimization Tools
  4. MySQL Concatenate: Adding String At The End Of Field Data
  5. Linux Terminal Speed Performance Comparison
  6. Howto: How to Reset the MySQL Root Password
  7. Bash shortcuts tips and tricks
  8. Installing Xen on Debian Etch 4.0
  9. Tomcat Performance: Linux faster than Windows
  10. Howto Wiretap – Sniff Network Traffic

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

    UN:F [1.8.5_1061]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.5_1061]
    Rating: 0 (from 0 votes)

  2. Satya Prakash Karan said,

    October 12, 2008 @ 12:08

    Good simple and stringht.

    UN:F [1.8.5_1061]
    Rating: 0.0/5 (0 votes cast)
    UN:F [1.8.5_1061]
    Rating: 0 (from 0 votes)

RSS feed for comments on this post · TrackBack URI

Leave a Comment