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=10
# 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 . liEnregistrement . $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
