Hi Guys
I just have a quick question.
I have done some research into how to determine the size of your Innodb
buffer pool.
All of the sources I used, specified that the Innodb buffer pool size
should be the same size as your database + 10%.
However, as far as I
Hi,
First thing that comes to my mind is that it is probably the best time to put
your application server and database server on different hosts. Having said
that, in this case increasing buffer pool size is still advisable as per my
understanding. Your swap consumption will go up in that case
Well, my question is specifically related to in the event that the buffer usage
reaches 100%
Quoting Nitin Mehta ntn...@yahoo.com:
Hi,
First thing that comes to my mind is that it is probably the best time to put
your application server and database server on different hosts. Having
On Wed, May 19, 2010 at 12:02 PM, Shawn Green shawn.l.gr...@oracle.comwrote:
Victor Subervi wrote:
On Wed, May 19, 2010 at 10:59 AM, Shawn Green shawn.l.gr...@oracle.com
wrote:
Shawn Green wrote:
look again closely at your FK definitions. The pattern should be
FOREIGN KEY
Right now I have the spamassassin bayesian rules database in mysql myisam
tables on our mail server. I want to move it to our database server.
Mysqltuner tells me that the read/write ratio is 10/90. 90% writes.
Given a database that is doing 90% writes, what database engine should I
use?
Hi,
I'm not sure if this is already an open issue or not - a Google search resulted
in various discussions but I didn't find any open support/feature request.
It would be really handy if during the create database statement, one could
specify something like:
CREATE DATABASE foo QUOTA=10G;
to
On Thu, 2010-05-20 at 16:27 -0700, Tim Gustafson wrote:
Hi,
I'm not sure if this is already an open issue or not - a Google search
resulted in various discussions but I didn't find any open support/feature
request.
It would be really handy if during the create database statement, one
Ummm, you're going to have the same problem either way when
the limit is reached, be it a MySQL quota or system quota,
if its full, its full.
Yes, but mySQL could return a more friendly you're out of space message and
not corrupt the data files if a given statement would cause the database to
On May 20, 2010 11:35:32 am John G. Heim wrote:
Right now I have the spamassassin bayesian rules database in mysql myisam
tables on our mail server. I want to move it to our database server.
Mysqltuner tells me that the read/write ratio is 10/90. 90% writes.
Given a database that is doing
On May 20, 2010 08:32:56 pm Noel Butler wrote:
On Thu, 2010-05-20 at 16:27 -0700, Tim Gustafson wrote:
Hi,
I'm not sure if this is already an open issue or not - a Google search
resulted in various discussions but I didn't find any open
support/feature request.
It would be really
Use postgres, you can assign tablespaces to a partition
of the size you want. When it gets full, writes are
refused. I'm not sure how nicely that is handled ( in
terms of error output ) but the advantage is that Pg is
ACID compliant, so you won't lose data.
Wow, that's the first time I've
Right now I have the spamassassin bayesian rules database in mysql myisam
tables on our mail server. I want to move it to our database server.
Mysqltuner tells me that the read/write ratio is 10/90. 90% writes.
Given a database that is doing 90% writes, what database engine should I
use?
Given a database that is doing 90% writes, what database engine should I
use?
You may also want to increase your key_buffer_size:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_key_buffer_size
Tim Gustafson
Baskin School of Engineering
UC Santa Cruz
Hi,
I'm beginner to try to fix a mysql bug by myself,
but i got a trouble that mysqltest: set debug_sync= 'RESET'' failed: 1193:
Unknown system variable 'debug_sync'
Could someone know that?
Thank you very much..
On May 20, 2010 09:55:41 pm Tim Gustafson wrote:
Use postgres, you can assign tablespaces to a partition
of the size you want. When it gets full, writes are
refused. I'm not sure how nicely that is handled ( in
terms of error output ) but the advantage is that Pg is
ACID compliant, so
Hi,
I'm beginner to try to fix a mysql bug by myself,
but i got a trouble that mysqltest: set debug_sync= 'RESET'' failed: 1193:
Unknown system variable 'debug_sync'
Could someone know that?
Thank you very much..
I've try the configure option -- ' --enable-debug-sync',
but it cannot work.
I've also to use google to search related information about it,
but i still cannot to solve it.
If anyone know that,
please tell me, thanks.
- Original Message -
From: 謝孟儒 mjhs...@iis.sinica.edu.tw
To:
I also read the URL
http://forge.mysql.com/wiki/MySQL_Internals_Test_Synchronization#Test_Synchronization
But it cannot work.
Sorry, mysql version is mysql-6.0.0-alpha
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Tim Gustafson wrote:
Hi,
I'm not sure if this is already an open issue or not - a Google search resulted
in various discussions but I didn't find any open support/feature request.
It would be really handy if during the create database statement, one could
specify something like:
CREATE
First, generally speaking, putting a quota on an entire database means
you are probably doing it wrong. In a perfect world, it seems to be
that building a database which can maintain a size without constant
mothering would be best, this doesn't always happen for one reason
or another, but of
20 matches
Mail list logo
