Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Posts
    1

    Unanswered: MySQL Optimization / Configuration

    Hi,

    I have 2 machines each with an instance of MySQL 5.0.45 for Windows.
    The machines are :
    1. Desktop AMD Athlon XP 1800+, 1024 Gb DDRAM, HDD Seageate SATA II 7200 rpm *mb buffer
    2. Laptop Dell Insprion 6400 Intel Core 2 Duo , 1024 DDRAM 667, HDD 120 Gb 5400 rpm.

    Both have installed Windows Xp SP2 + Avast Home v 4.7 Antivirus.

    Both MySQL instances have a copy of the same database ( same tables, number of rows, indexes etc ) and are configured identicaly ( they have the same my.ini file ).

    The problem comes when i run a stored procedure that does some calculations on the database.
    On system 1 it runs in 11 seconds, but in system 2 it runs in 3 minutes and 40 seconds.

    What can i do ? What should i look at ? ( I am a developer not a dba, all the configurations to MySQL have been done from the wizard like installer.)

    Thanks,
    Razvan

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    Are the indexes the same on both databases?
    Which machine runs slower? What background processes is the slower machine running?

  3. #3
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    Scrap that first part of the question I missed the bit about the same indexes... Do:
    DESCRIBE <select statement here>

    On both machines and see if they're doing the same process to get the results. If you find there are differences your indexes may not be the same.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •