essage -
>> From: "Artem Kuchin" <[EMAIL PROTECTED]>
>> To: "Russell E Glaue" <[EMAIL PROTECTED]>, mysql@lists.mysql.com
>> Sent: Sunday, December 9, 2007 9:03:45 AM (GMT-0600) America/Chicago
>> Subject: Re: How to auto repair db on hosting
]>
To: "Russell E Glaue" <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Sent: Sunday, December 9, 2007 9:03:45 AM (GMT-0600) America/Chicago
Subject: Re: How to auto repair db on hosting with quota
I won't convert thread style, so, i'm top-posting :)
All this would be gr
h two
extra steps to copy back and forth from the temp directory.
-RG
- Original Message -
From: "Artem Kuchin" <[EMAIL PROTECTED]>
To: "Russell E Glaue" <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Sent: Sunday, December 9, 2007 9:03:45 AM (GMT-0600) America/Ch
I won't convert thread style, so, i'm top-posting :)
All this would be great if it worked. The main problem is that
temporary directory option for mysqld iS NOT USED while doing
table repair. All files while repairing tables are placed
in the same directoty with the same owner and group as the or
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
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 tem
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
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
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, and
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 sita
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]>;
Sent: Friday, December 07, 2007 8:11 AM
Subject:
> -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
12 matches
Mail list logo
