I know they're not great queries as such but I naively expected "everything" would run faster on mysql 5.5 regardless, not 3 times slower!
I have seen that link in the past and again I just assumed given both machines are similar for disk access the bad query results would be comparable. Do you mean the bad queries are just measuring disk speed or do you mean I should use disk speed as a test? Sysbench fileio is much faster on the new machine than the old one. Daniel Reindl Harald Thu, 24 Oct 2013 03:36:10 -0700 Am 24.10.2013 12:20, schrieb Daniel Schütze: > The simple query select count(*) from dbmail_fromfield; takes 8seconds on > the new and 3 seconds on the old. makes no sense to measure anything but disk speed http://www.mysqlperformanceblog.com/2006/12/01/count-for-innodb-tables/ > A scan query of select * from dbmail_fromfield where fromfield like > "%EXAMPLE%"; takes 9 seconds on the new and 3.3 seconds on the old. is a query not using indexes > Also of course these are not queries which dbmail actually performs when it > is running for real they are generally useless examples, see above > and I have read dbmail 5.1 is faster for single threaded queries what is a "single threaded query"? _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
