7 messages in com.mysql.lists.mysqlabout Load of MySQL
FromSent OnAttachments
thanyaluk jirapech-umpai13 Sep 1999 03:20 
Jani Tolonen13 Sep 1999 09:23 
thanyaluk jirapech-umpai15 Sep 1999 04:51 
Matthias Urlichs15 Sep 1999 05:03 
Bob Kline15 Sep 1999 05:10 
thanyaluk jirapech-umpai15 Sep 1999 05:34 
Matthias Urlichs15 Sep 1999 09:36 
Subject:about Load of MySQL
From:Jani Tolonen (ja@mysql.com)
Date:09/13/1999 09:23:41 AM
List:com.mysql.lists.mysql

thanyaluk jirapech-umpai writes:

Hi All,

I want to use mysql as a database server that have a lot of queries via web server. I use Perl + DBI + DBD for acess mysql. My work is so big. I must handle about 1000 connections of queries at a time. mostly is select , update , insert queries. Does mysql database server can handle this siuation ??? I think if i use about 2 web servers (Apache) that access one database server (Mysql) ?? Is it will work fine ? Or any suggession to me about handle with hard load ???

Thank you, Thanya.

Hello Thanya,

Yes, MySQL is able to handle 1000 connections, just start the server with option mysqld -O max_connections=1000.

And to your question about Apache, the answer is: yes.

Please check the crash-me tests and benchmark from our www pages. Right now our pages are down, due to hardware breakdown, but here are some mirrors:

mysql.he.net www.ntua.gr/mysql www.minet.net/devel/mysql mysql.eunet.fi

Regards,

- Jani

-- +-------------------------------------------------------------+ | TcX ____ __ _____ _____ ___ | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen | | /*/ /*/ /*/ \*\_ |*| |*||*| ja@mysql.com | | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +-------------------------------------------------------------+