On Jul 14, Hickey,Thom wrote:
> I was able to rerun my tests using mysqld (as opposed to safe_mysqld). I'm
> happy to report that the times now almost exactly match MySQL 3.23.58.
It's VERY strange. It cannot have any affect on the speed.
Are you sure you run the correct version of mysqld ?
That is, I can suspect that either safe_mysqld used wrong .my.cnf or
run wrong mysqld, or when you run mysqld directly you used wrong mysqld
or it used wrong my.cnf. I could start all your tests with
SELECT VERSION(); SHOW VARIABLES; - to be sure you are using correct
mysqld and correct my.cnf.
By the way, if you want to disable query cache you can turn it of with a
command line switch :)
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany