So, we have a webmail application that uses a mysql server for holding
it's session information. Obviously this causes many
reads,updates,inserts, and deletes to happen. Here are my lock
statistics.
| Table_locks_immediate| 73099 |
| Table_locks_waited | 32187 |
This ratio
On Tue, Sep 02, 2003 at 10:37:34AM -0700, James Kelty wrote:
So, we have a webmail application that uses a mysql server for holding
it's session information. Obviously this causes many
reads,updates,inserts, and deletes to happen. Here are my lock
statistics.
| Table_locks_immediate|
Well, there isn't a my.cnf file, so other that setting the
max_connections with the -O option, it's whatever is default for
3.23.56.
-James
On Tue, 2003-09-02 at 10:50, Jeremy Zawodny wrote:
On Tue, Sep 02, 2003 at 10:37:34AM -0700, James Kelty wrote:
So, we have a webmail application that
On Tue, Sep 02, 2003 at 10:58:03AM -0700, James Kelty wrote:
Well, there isn't a my.cnf file, so other that setting the
max_connections with the -O option, it's whatever is default for
3.23.56.
Since you didn't answer the other questions, I'm going to do some
guessing here... I'll guess that
Whoa, ok. Sorry. I didn't read the questions about the data and index
files. I'm, uh, not exactly sure how to tell that, can you give me a
hint there as well? *look sheepishly around*...
-James
On Tue, 2003-09-02 at 11:06, Jeremy Zawodny wrote:
On Tue, Sep 02, 2003 at 10:58:03AM -0700, James
On Tue, Sep 02, 2003 at 11:23:57AM -0700, James Kelty wrote:
Whoa, ok. Sorry. I didn't read the questions about the data and index
files. I'm, uh, not exactly sure how to tell that, can you give me a
hint there as well? *look sheepishly around*...
Sure.
First you need to figure out where
Ahhh! Ok, yeah the index file was 1.0k and the data file was 8.6M.
-James
On Tue, 2003-09-02 at 12:17, Jeremy Zawodny wrote:
On Tue, Sep 02, 2003 at 11:23:57AM -0700, James Kelty wrote:
Whoa, ok. Sorry. I didn't read the questions about the data and index
files. I'm, uh, not exactly sure
you add indexes, we will need the output of
SHOW CREATE TABLE your_table;
for your table(s). Also need examples of queries that you're running.
Matt
- Original Message -
From: James Kelty
Sent: Tuesday, September 02, 2003 2:23 PM
Subject: Re: Many Read and Writes...
Ahhh! Ok, yeah
