I am asking this question as a hosting PROVIDER, not
as a hosting client.
The sitation is like this (this is a simple example with small
numbers):
1) a client has 100mb quota for site and db files (set on unix group)
2) 80mb is already taken by 75MB database in ONE TABLE and 5mb of files
3)
Using Quota on Unix, you can specify a different quota soft_limit for temporary
space.
You can set MySQL to use /tmp as the temporary space, then set a soft_limit of
10mb and a hard_limit of 300MB.
This quota should be separate from the normal user space quota.
With MySQL temp dir set to /tmp,
The easiest way to get mysql working on os x is with a fink build. The
version is a little behind 5.0.38, but I can't imagine there would be
any problems with a source build from the latest. Maybe you could give
it a go, and report any problems, then I'll happily help out.
Simon Elliston
Steven Buehler wrote:
-Original Message-
From: Artem Kuchin [mailto:[EMAIL PROTECTED]
Sent: Friday, December 07, 2007 4:35 AM
To: mysql@lists.mysql.com
Subject: How to auto repair db on hosting with quota
I am asking this question as a hosting PROVIDER, not
as a hosting client.
The
-Original Message-
From: Artem Kuchin [mailto:[EMAIL PROTECTED]
Sent: Friday, December 07, 2007 4:35 AM
To: mysql@lists.mysql.com
Subject: How to auto repair db on hosting with quota
I am asking this question as a hosting PROVIDER, not
as a hosting client.
The sitation is like
I see topposting i popular in this mail list :)
Well, thank you for the idea. It seems to be workable. I
hope that while data is being repaired and it is located
in tmp the rights are set correctly so noone else can read the
files. I'll see it myself. Thank you very much.
Any idea on how to
Hi!
I have a table with several rows, some of which I need to duplicate.
The fields of table1 are field1, field2, field3 and field4. Field1 is
automatically incremented,
field2 will serve as a filter condition.
Normally to duplicate the rows that matched a certain condition I would do:
INSERT
Artem
set
my.cnf in unix
my.ini in windows
set max_connections
max_connections=100
M--
- Original Message -
From: Steven Buehler [EMAIL PROTECTED]
To: 'Artem Kuchin' [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, December 07, 2007 8:11 AM
Subject: RE: How to auto repair db on
At 09:39 AM 12/7/2007, rfeio wrote:
INSERT INTO table1 (field2, field3, field4) SELECT field2, field3, field4
WHERE field2=x
Have you tried:
INSERT INTO table1 (field2, field3, field4) SELECT field2, field3, ABCD
WHERE field2=x
Mike
--
MySQL General Mailing List
For list archives:
Those of us who view our mail in threads also post in threads. ;-)
Here is some info for your concerns.
We assume the client is going to run their database under their client
unix-system username.
You specify the temp directory in the my.cnf file.
The documentation (when I last read it) says
Hi All,
We fixed the error by creating a composite index on (user_id,billing_run)
On 12/5/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I am getting below error when i am updating a table
ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_5dc3_0.MYI';
try to r epair it
Its a
Regards,
Baron
Yes it is. Even worse, people love to convert a top-posted thread to
bottom-posted and verse vice-a!
I see topposting i popular in this mail list :)
And now for the bottom-posting part of this reply...
Any idea on how to limit connection per user? (so one user
cannot abuse
u want something like this
INSERT INTO table1 (field2, field3, field4) SELECT field2, field3, 'abcd'
from table_name
WHERE field2=x
On 12/7/07, rfeio [EMAIL PROTECTED] wrote:
Hi!
I have a table with several rows, some of which I need to duplicate.
The fields of table1 are field1,
Baron Schwartz wrote:
Regards,
Baron
Yes it is. Even worse, people love to convert a top-posted thread to
bottom-posted and verse vice-a!
I see topposting i popular in this mail list :)
And now for the bottom-posting part of this reply...
Any idea on how to limit connection per user? (so
I knew it had to be something REAL simple! :-)
Thanks guys, that worked perfectly!
Ananda Kumar wrote:
u want something like this
INSERT INTO table1 (field2, field3, field4) SELECT field2, field3, 'abcd'
from table_name
WHERE field2=x
On 12/7/07, rfeio [EMAIL PROTECTED]
15 matches
Mail list logo