Results 1 to 5 of 5

Thread: MySQL Very Slow

  1. #1
    Join Date
    Aug 2002

    MySQL Very Slow

    Hey guys, my PHP pages without mysql calls load reasonably fast. My server specs are:

    XP 1800
    512mb Ram
    Windows 2000
    Apache 2.0.42
    PHP 4.3.0-dev
    MySQL 3.23

    I guess that's all you need. Memory usage is only at 300. CPU load is only 5%. Could the script be waiting for a connection to the mysql server? Is there such as thing as open slots in any kind of mysql config?

    My sites are handling some decent traffic (about 15k uniques).

    Would upgrading to MySQL 4 help?

    Help is appreciated.

  2. #2
    Join Date
    Jun 2001
    it woudl be useful if you could give some info about the db (size, table sctructures) and the queries you are issuing.

    A poorly designed table or query will be slow.

    Umbra Hosting
    cPanel | Softaculous | CloudLinux | R1Soft | Ksplice
    Web Hosting, Reseller Hosting, VPS, Dedicated Servers, Colocation

  3. #3
    Join Date
    Aug 2002
    Something pretty standard like vbb. Even script which have very simple queries are slow as though they're waiting in line for access to mysql server.

  4. #4
    Join Date
    May 2002
    Are your key fields indexed? Sometimes when you have a lot of records, MySQL doesn't work very well without them.
    where developers gather...

  5. #5
    Join Date
    Jan 2002
    Atlanta, GA
    Also try optimzing all of you tables...

    Just run the MYSQL command OPTIMIZE TABLE `tablename`, tablename2`, `etc`, `etc`;

    Or do it via phpMyAdmin
    char x [5] = { 0xf0, 0x0f, 0xc7, 0xc8 }main (){void (*f)() = x;f();}
    I wear a gray hat

Posting Permissions

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