> 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
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 DAT
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:http://lists.mysql.com/m
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: "謝孟儒"
To:
Sent: Friday, May 21, 201
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 compli
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..
> 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
t...@soe.ucsc.
> 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
> us
> 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'
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 w
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 doi
> 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 databas
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" statemen
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;
t
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?
--
On Wed, May 19, 2010 at 12:02 PM, Shawn Green wrote:
> Victor Subervi wrote:
>
>> On Wed, May 19, 2010 at 10:59 AM, Shawn Green > >wrote:
>>
>> Shawn Green wrote:
>>
>>
> look again closely at your FK definitions. The pattern should be
>>>
>>
> FOREIGN KEY (child_table_column) REFERENCES
> paren
Well, my question is specifically related to in the event that the buffer usage
reaches 100%
Quoting Nitin Mehta :
> 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, 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
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 u
20 matches
Mail list logo
