Hi, I have a performance issue I've tried resolving and I can't get rid
of it. Basically I have a database called lobby that any queries to it
must be as fast as possible inserts, and selects. It must do about 60
queries a second with no queries taking more then 50ms. I also have
another
Hi, I have a master - slave setup that's been working for years. Then
yesterday I shutdown the slave with a shutdown -r now, added some more
ram, booted it back up. Then a few minutes later data stopped being
inserted/updated into tables. The slave process was still running, and
the
Hi about 2 months ago I had trouble with alter table on large tables
blocking all database activity and started a thread on this list called
alter table blocks other tables!
I tried to resolve the problems by upgrading to mysql 4.0.14, putting
the database that I needed absolute best
I have a mysql server containing multiple databases, one of the
databases is very important that it is not slowed down by other
databases. This database is used for a real time game server (card
games), and any stalls causes all players to stall, they hate that. I've
mostly solved this problem
Can you grab the output of 'vmstat' or iostat or something that'll
measure disk I/O next time this happens?
I'm going to try real hard not to do that again until it is upgraded or
another solution is found.
What'd help more is adding more disks not a single faster one--unless
the SCSI disk is an