Re: mysql different server different EXPLAIN result
| From: | Niel | Date: | Tue, 24 Jul 2007 17:12:24 +0000 |
| Subject: | Re: mysql different server different EXPLAIN result | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43853@lists.php.net to get a copy of this message | ||
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