On Thu, Sep 4, 2008 at 3:23 PM, Ryan Schwartz <[EMAIL PROTECTED]> wrote:
> I'll have to crack open my copy - haven't read through it in a while
If you have the first edition, I recommend getting the newer one. It
has a lot more tuning info.
- Perrin
--
MySQL General Mailing List
For list archi
On Sep 4, 2008, at 1:48 PM, Ranjeet Walunj wrote:
Hi ryan.
As pointed by Johnny, it is difficult to give optimization advise
without exactly knowing the performance of your machine.
I'm assuming you are using the machine as Database Server and not
running application (Web/other) on the sa
Ryan Schwartz wrote
mysql> show variables like '%buffer%'\G
*** 1. row ***
*** 3. row ***
Variable_name: innodb_buffer_pool_size
Value: 8388608
*** 4. row *
On Thu, Sep 4, 2008 at 12:15 AM, Ryan Schwartz <[EMAIL PROTECTED]> wrote:
> We're seeing a huge surge in our qps and I'd like to make sure we're tuned
> as well as we can be. I'm wondering if I've got some variables maybe set too
> large (is that even possible?) ? We do have a fair bit of innodb, s
Here's all the buffer variables:
mysql> show variables like '%buffer%'\G
*** 1. row ***
Variable_name: bulk_insert_buffer_size
Value: 8388608
*** 2. row ***
Variable_name: innodb_buffer_pool_aw
All,
We're seeing a huge surge in our qps and I'd like to make sure we're
tuned as well as we can be. I'm wondering if I've got some variables
maybe set too large (is that even possible?) ? We do have a fair bit
of innodb, so perhaps I should add some non-defaults there, but I'm
not so su
On Tue, Sep 11, 2001 at 03:17:47PM -0500, Weslee Bilodeau wrote:
> > > They average around 500 connections/second at any given time, two
> > > have a master/slave setup.
> >
> > Connections/sec or Queries/sec? That's a lot of connections per
> > second? Can you use persistent connections? It wo
> > They average around 500 connections/second at any given time, two
> > have a master/slave setup.
>
> Connections/sec or Queries/sec? That's a lot of connections per
> second? Can you use persistent connections? It would save a lot of
> overhead.
Half and half, at the moment .. We had a pro
On Mon, Sep 10, 2001 at 04:54:57PM -0500, Weslee Bilodeau wrote:
>
> Basic (maybe?) question on some optimal variables for MySQLd's my.cnf
> configuration ..
>
> Right now, I have three MySQL servers, each with 2 GB ram, dual-CPU
> P3 1ghz.
Nice. :-)
> They average around 500 connections/second
Basic (maybe?) question on some optimal variables for MySQLd's my.cnf
configuration ..
Right now, I have three MySQL servers, each with 2 GB ram, dual-CPU P3 1ghz.
They average around 500 connections/second at any given time, two have a
master/slave setup.
MySQL is prettty much the only thing r
10 matches
Mail list logo
