MySQL on virtual hosting

[Sweethome.co.il Webmaster]

Dear list,

Does any of you guys operate a mysql server in virtual hosting environment?
I need some advice on tuning and restriction based on system resources.

My system is running RH7.2 , on an Intel based server, 2x1Ghz CPU's and 1 
giga of RAM.
I have 2 hd's in raid 1 mode (hardware). I currenly run MySQL 3.23.53

Here are few questions I have in mind, any other advice on keeping this 
system in a
sane state will be appreciated.

1. From the following, what would be the best OS to run MySQL as of today?
FreeBSD, Linux, OpenBSD

2. Is it possible to limit number of connections per user or database?
MySQL can eat pretty much resources, if webmasters write bad code, I need 
to restrict
them or charge extras for the usage as well as to protect the system 
against DOS attacks,
which in this case will need to exploit a bad script which accesses the 
database.
Restricting httpd connections is irrelevant here, so I must be able to 
control MySQL
connections.

3. A lot of ready scripts or novice webmasters know very well how to open a 
connection
but closing it... that's beyond them :) What is a sensible timeout and what 
exactly
is the parameter that can kill these connections?

4. If you run a similar system, what would be the most important parameters 
for load
tuning, and how would you set them?

Thanks for all answers,

		Justin Grindea	
		[EMAIL PROTECTED]







-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL Process ID & Unix PID

[Sweethome.co.il Webmaster]

Hi,

Is there a way to compare between a  mysql process ID showed in top or ps
with a process ID from mysqladmin processlist ?

I'm asking this because we operate a mysql machine used for webhosting and
it has many users and many databases. If users do crazy stuff that result in
high usage of resources, we need to determine who is the user, which 
database is
it accessing and finally what script causes the problem.

Any ideas or utils/scripts for digging this info apreciated.

	Tnx.	
		Justin Grindea
		System Administrator
		SweetHome.co.il





-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php