throttling mysql database

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jippie

    throttling mysql database

    not sure what I'm looking for.
    It's just my site has a mysql database with a lot of data in it,
    and I can create a simple CSV file.

    The problem is when anybody tries to connect to the site while I'm
    creating the csv file, they can't login until I'm finished, which is a
    bit strange.
    It's an old PC so it takes a while.

    the select statment is very simple, using two tables, but it does
    return about 15000+ records. I'm using the DB stuff in pear,

    At first I thought it was the bandwidth so now I store CSV output as a
    file on the server first. This didn't help.

    jippie
Working...