I am new to MySQL. Please excuse my ignorance if this question has been
previously discussed. I was not able to
find an answer to my question by searching the archives.
I have MySQL installed on a dedicated AMD-64 computer with the MS XP Pro
operating system.
MS-SQLServer is installed on
jatwood [EMAIL PROTECTED] wrote on 28/04/2005 22:35:45:
I am new to MySQL. Please excuse my ignorance if this question has been
previously discussed. I was not able to
find an answer to my question by searching the archives.
I have MySQL installed on a dedicated AMD-64 computer
It sounds like you either have incorrect indexes or you didn't adjust
the MySQL configuration variables (i.e. key_buffer, join_buffer_size,
read_buffer_size) appropriately for your data set size and what your
query is doing (i.e. full table scan).
SHOW STATUS can help you figure out what needs
Hi,
If you're in a transactionnal env., and have a test env. of mysql with myisam
tables, and want to compare, you will not have what you want.
Myisam tables have only table locking. sql server 2000 and Yukon have row
locking mecanism. So you have to have innodb storage type.
Also, if your