.bootstrap - Safe with most medications

• 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. Slow Query Log Analyzes Tools
9. MDB Tools to export (migrate) from mdb (Microsoft Access format) to MySQL
10. Migrate existing Ext3 filesystems to Ext4