hello, sorry for my english,
I have a compaq bi PII 400 Mhz with 512 Mo of ram. Linux mandrake 8 kernel 2.4.6 MySQL 3.23.36, apache 1.3.19 with php 4.0.4pl1 disk free space /usr/ : 2Go /var/ : 2,4 Go I want to create a benchmark with linux + apache + php + mysql vs linux + apache + php + postgresql vs W2000 + IIS5 + asp + SQL Server I use Microsoft Web Application Stress Tool (http://webtool.rte.microsoft.com/) test with linux + apache + php + postgresql and W2000 + IIS5 + asp + SQL Server passed but the test (<=7 clients http (first test is ok)) with linux + apache + php + mysql crash mysql (/etc/rc.d/init.d/mysql start|stop, mysql, mysqladmin and any query don't work) /etc/my.cnf: # Example mysql config file for large systems. # # This is for large system with memory = 512M where the system runs mainly # MySQL. # # You can copy this file to # /etc/mf.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock #datadir =/home/database/mysql skip-locking set-variable = key_buffer=256M set-variable = max_allowed_packet=1M set-variable = max_connections=1000 set-variable = table_cache=256 set-variable = sort_buffer=1M set-variable = record_buffer=1M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable = thread_concurrency=8 log-bin server-id = 1 # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=64M #set-variable = bdb_max_lock=100000 # Uncomment the following if you are using Innobase tables #innobase_data_home_dir = /usr/share #innobase_log_group_home_dir = /usr/share #innobase_log_arch_dir = /usr/share #innobase_data_file_path = ibdata1:25M;ibdata2:37M;ibdata3:100M;ibdata4:300M #set-variable = innobase_mirrored_log_groups=1 #set-variable = innobase_log_files_in_group=3 #set-variable = innobase_log_file_size=5M #set-variable = innobase_log_buffer_size=8M #innobase_flush_log_at_trx_commit=1 #innobase_log_archive=0 #set-variable = innobase_buffer_pool_size=16M #set-variable = innobase_additional_mem_pool_size=2M #set-variable = innobase_file_io_threads=4 #set-variable = innobase_lock_wait_timeout=50 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=128M set-variable = sort_buffer=128M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=128M set-variable = sort_buffer=128M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout my table with 5000 rows : CREATE TABLE test ( idtest int(11) NOT NULL auto_increment, testchar varchar(255), testdate datetime, testnum int(11), testbool tinyint(1), testvarchar varchar(255), PRIMARY KEY (idtest) ); testmysql.php : <HTML> <BODY> <?PHP $dbconn = mysql_connect ("localhost", "root", ""); $template="idtest : <!--IDTEST--> - testchar : <!--TESTCHAR--> - testdate : <!--TESTDATE--> - "; $template=$template . " testnum : <!--TESTNUM--> - testbool : <!--TESTBOOL--> - testvarchar : <!--TESTVARCHAR--><br>"; $Affiche=""; $cpt=0; $sql="SELECT * FROM test LIMIT 3000, 20"; $sqlok=mysql_db_query ("testapache", $sql, $dbconn) ; if ($sqlok) { while ($result=mysql_fetch_array ($sqlok, MYSQL_ASSOC)) { $cpt++; $templatetmp =$template; foreach ($result as $key => $value) { $templatetmp = eregi_replace("<!--".$key."-->",$value,$templatetmp); } $Affiche = $Affiche . "<li>Enregistrement " . $cpt . " : <br>" . $templatetmp; } } echo $Affiche; mysql_close ($dbconn); ?> </BODY> </HTML> do you have an idea ? Bien à vous Philippe http://www.devparadise.com/ --------------------------------------------------------------------- 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
