Thread: Crashing MySQL

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    20
    Rep Power
    0
    I have a MySQL database with 25 tables running on Apache. One of my tables (shopper table) has close to 300,000 records and I use this table quit frequently for queries. I came across a problem using a query to access my shopper table and another table (this table has around 15,000 records) to pull the necessary information. The problem is that when I run this query it runs for a long period of time then the database crashes (with no query result). Can MySQL handle only a certain amount of records before it becomes overburdened? Also, I am using PHP 3 to run this query. Thanks.
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    18
    "I came across a problem using a query to access my shopper table and another table (this table has around 15,000 records)..."

    Can we assume you are joining the two tables? How are you joining them (post your query). If you aren't doing the join right you'll end up with a temp table of 45G records!
  4. #3
  5. Full Access
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jun 2000
    Location
    London, UK
    Posts
    2,019
    Rep Power
    16
    Exactly how many is 45G?
  6. #4
  7. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    18
    45,000,000,000
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    32
    Rep Power
    14
    Yeah, with big tables like that a bad JOIN can be a major problem... And use EXPLAIN to make sure you have your indexes set up right...

Similar Threads

  1. mysql and MS foxpro
    By wijbenga in forum MySQL Help
    Replies: 16
    Last Post: February 5th, 2004, 11:46 AM
  2. Upgrade from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: December 16th, 2003, 12:27 AM
  3. mysql database help!
    By TweetyPie in forum MySQL Help
    Replies: 2
    Last Post: August 1st, 2003, 06:20 AM
  4. Replies: 3
    Last Post: July 10th, 2003, 07:47 PM

IMN logo majestic logo threadwatch logo seochat tools logo