PHP DB - Re: [PHP-DB] mysql different server different EXPLAIN result

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: [PHP-DB] mysql different server different EXPLAIN result

Niel

2007-07-24, 6:59 pm

Hi

> I'm running 3 servers with mysql database
> - Local : 5.0.18-log, MySQL Community Edition (GPL)
> - Main Server : 4.1.22-standard-log, MySQL Community Edition - Standard
> (GPL)
> - Backup Server : 4.1.20, Source Distribution
>
> I copied a database from the Main Server to Local and Backup Server and
> run a SQL
> explain command on the database but i get different EXPLAIN result. I
> think because
> i copied it from one source shouldn't it show the same EXPLAIN result
> cause i didn't
> change any of the index, keys or records

Not if that's what has changed between versions. Check the change log
for details of what was altered, to see if it's relevant.

--
Niel Archer

Sponsored Links