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:
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, so
Ryan Schwartz wrote
mysql show variables like '%buffer%'\G
*** 1. row ***
*** 3. row ***
Variable_name: innodb_buffer_pool_size
Value: 8388608
*** 4. row
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
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
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
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 would save a
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 problem
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
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 at
10 matches
Mail list logo