SMF Support > Server Performance and Configuration
Forum slow, installed: MySQL 4.1.1 + APACHE 2.0.53 + PHP 5.0.3 + ZEND optimizer
verbam:
I have just installed MySQL 4.1.1 + APACHE 2.0.53 + PHP 5.0.3 + ZEND optimizer.
My previous installation was with a: miniportal 1.3.8 + php 4.3 + mysql 3.2.4 (and fast)
Previous installation, it needs 1 to 3 seconds to get some action but now:
--- Quote ---login forum: 10 seconds
switch from board item to board item 5 seconds
read board topics 7 to 12 seconds
logout forum: 7 seconds
--- End quote ---
--- Quote ---If i login as user instead administrator everything goes faster (login, logout, browse...) example: login: 5 seconds, but read a topic is the same slow (7 to 12 seconds) speed
--- End quote ---
--- Quote ---seems to be some cookie (control) problem, but can not find it.
i did NOT change anything in the portal or forum as it was with previous installation.
--- End quote ---
have changed the configuration off the cookies in all possible ways and it did not work.
so i have decide to store it back as it was.
do somebody have installed the same configuration ?
maybe i can see the ini or config files to check what is different (just replace names & passwords with"xxxxx")
--- Code: ---Operating system: Windows 2003 without IIS, DHCP, DNS ....installed.
MySQL 4.1.1
APACHE 2.0.53
PHP 5.0.3
ZEND optimizer
Board: SMF 1.0.2
--- End code ---
Needed:
Mysql = my.ini (***/mysql)
Apache = httpd.conf (***/Apache2/conf)
php = php.ini (windows directory)
If somebody can help me please .... :-[
CU (Thanks for reading this anyway)
[Unknown]:
--- Quote from: verbam on March 06, 2005, 04:30:04 PM ---Previous installation, it needs 1 to 3 seconds to get some action...
--- End quote ---
That is not fast. What sort of server is this on (CPU/ram)?
The numbers you're getting are horrid and seem to indicate heavy overall load on the server. Is it a shared server, with other people on it? Is the query cache enabled in MySQL? How much ram is MySQL using? Apache?
Please add the following to Settings.php, BEFORE the ?>:
$db_show_debug = true;
What query or queries are taking the longest?
How many posts are on the forum? How many people are using it at once? What sort of bandwidth/connection does it have?
-[Unknown]
Trekkie101:
Dont open in from within MK, open it outside MK portal ;) and it should go faster.
EDIT: Using the MK Portal CP
verbam:
--- Quote from: [Unknown] on March 06, 2005, 04:37:23 PM ---
--- Quote from: verbam on March 06, 2005, 04:30:04 PM ---Previous installation, it needs 1 to 3 seconds to get some action...
--- End quote ---
That is not fast. What sort of server is this on (CPU/ram)?
The numbers you're getting are horrid and seem to indicate heavy overall load on the server. Is it a shared server, with other people on it? Is the query cache enabled in MySQL? How much ram is MySQL using? Apache?
Please add the following to Settings.php, BEFORE the ?>:
$db_show_debug = true;
What query or queries are taking the longest?
How many posts are on the forum? How many people are using it at once? What sort of bandwidth/connection does it have?
-[Unknown]
--- End quote ---
0.001568078994751 is the maximum time for a query ( others are between 0.00001 and 0.0004)
My server is a Dell PIV 2.6 gig with 256Mb memory and 80 gig HD, it's NOT shared with anyone, query cache is enabled and the ram that MySQL AND Apache is using is MAXIMUM (PEAK) 64 MB.
It is a small forum with: 1681 Posts in 1321 Topics by 253 Members.
My bandwidth is large enough to connect 10 pc's on it & i use only 2 connections (i buy this 10 pc's contract because i did not want to have some limitation.
NOW: I have connected my previous disk again, to test the speed and it was OK.
BUT because i want to have the latest version from Mysql, php and Apache, i reconnected my new installed HD again and the speed went SLOW again.
With some adjustments on the sql server (query cache on + NO log files) the login proces goes faster but to READa topic it still take 7 to 8 seconds????????
Maybe i can send you my SQL PHP and APPACHE config files to check?
Here you can see the maximum values from the server: http://verbam.sytes.net/xtra/VERBRUIK_SERVER.PDF [nofollow]
Thanks for the reply
Danny
verbam:
--- Quote from: Trekkie101 on March 06, 2005, 04:47:48 PM ---Dont open in from within MK, open it outside MK portal ;) and it should go faster.
EDIT: Using the MK Portal CP
--- End quote ---
Thanks for the advice.
I am testing now on the forum allone and the problem remain.
i am wondering why!
Thanks again :)
Navigation
[0] Message Index
[#] Next page
Go to full version