Adam Douglas writes:
> Ahh what do you mean "all tables are not related with common columns"? They
> are not suppose to be related with a common columns. PostalCodeInfo and
> Company table are completely two different things.
>
> Yes that is correct, I've resolved the issue with PostalCodeInfo for
> indexing in the query. I had column types not matching the same through my
> tables. But I'm still lost as to why I can not get CompanyShipInfo to use
> indexing in the query.
>
> That's find but shouldn't I still be able to go down even further as to how
> many rows are analyzed? CompanyShipInfo has 235 rows and all are being read
> by the query. Here's the new explain of the query below.
>
> Another thing that happens is when I tried to ALTER PostalCodeInfo and
> PostalCodeReps table schemas MySQL seemed to be hung and put the CPU usage
> at 99.0% to 99.02% (never ending it seems). Both those tables only have
> 42657 rows each. Any ideas why these two tables seem to hang when anything
> major is done on them? Funny thing is it seems to be random when you execute
> a query that uses these two tables. Is there something I'm missing for MySQL
> configuration or bad table design? I'll post the table schema's below the
> explain query.
MySQL is truly doing it's best in your case.
If of 6 tables you have a broken chain of relations, you will have a
Cartesian product.
Regarding ALTER TABLE, that is also expected behaviour, as MySQL is
re-building indices and has to use lot's of CPU.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php