help 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 Wr
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 su
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 My
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 K
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 tha
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: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
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 see
