I noticed replication delays in MySQL 5.1. Data synchronizing is takes long on MySQL 5.1 slaves while MySQL 4.1 and MySQL 5.0 slaves working quite brilliant.
We have MySQL 4.1 acting as Master database while MySQL 4.1, MySQL 5.0 and MySQL 5.1 acting as slaves.
Can someone please let me know what are the SQL changes between MySQL 5.0 and MySQL 5.1. Because i noticed SQL queries are working as fast in MySQL 5.1 compare to MySQL 5.0. I analyzed this from slow queries log.
We have lot of queries with GROUP BY, ORDER BY and LIMIT clauses together. and LIMIT clauses with 4000,10 or 2000,10 etc. Also we have lot of SELECTs with JOINs on multiple tables.
Please let me know major SQL changes between MySQL 5.0 and MySQL 5.1.