Re: how to limit the cpu usage in MySql

2002-07-11 Thread Alexander Barkov

Probably execution with "nice" will help.

Edwin Wang wrote:
> I want to find a way to limit how much of a system processor (cpu) the
> mysql server will use, so that I don't run the risk again of having
> googlebot or other web robots interrupt my other server operations in my
> computer.
> 
> Thank you
> 
> Edwin
> 
> 
> -
> 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
> 
> 
> 



-- 
For technical support contracts, visit https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Mr. Alexander Barkov <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Izhevsk, Russia
<___/   www.mysql.com   +7-902-856-80-21


-
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




Re: how to limit the cpu usage in MySql

2002-07-05 Thread Ralf Narozny

Hello!

If you are using Unix/Linux you might want to 'nice' the mysqld 
processes or raise the priority of your more important services.

Greetings
 Ralf

Edwin Wang wrote:

>I want to find a way to limit how much of a system processor (cpu) the
>mysql server will use, so that I don't run the risk again of having
>googlebot or other web robots interrupt my other server operations in my
>computer.
>
>Thank you
>
>Edwin
>  
>
sql query

-- 
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de




-
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




RE: how to limit the cpu usage in MySql

2002-07-05 Thread Alain Fontaine

Hello,

If your main concern is spider-bots, why not use a (possibly dynamic!)
robots.txt file?

-Message d'origine-
De : Edwin Wang [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 4 juin 2002 17:53
À : [EMAIL PROTECTED]
Objet : how to limit the cpu usage in MySql


I want to find a way to limit how much of a system processor (cpu) the
mysql server will use, so that I don't run the risk again of having
googlebot or other web robots interrupt my other server operations in my
computer.

Thank you

Edwin


-
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


-
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




how to limit the cpu usage in MySql

2002-07-05 Thread Edwin Wang

I want to find a way to limit how much of a system processor (cpu) the
mysql server will use, so that I don't run the risk again of having
googlebot or other web robots interrupt my other server operations in my
computer.

Thank you

Edwin


-
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