I'm stumped. I'm not so sure what is the answer to that question. I'll do some investigation and get back to you if I bump into an good answer. You should email the people at iPage as they probably know..
Increase the ram will be the most effective way. for example 1G to 2G makes a big performance difference in my experience...
I managed to fix my problems..
It all came down to indexing the database..
It has made a huge difference!.
How did you index the database. I would like to do the same thing.
This post has been edited by.
: 27 January 2004, 19:52..
The tools function of mysql connector or phpmyadmin can help you do this..
If you search through the forums you should find some previous discussions on increasing performance by adding additional indexes - there was a list of indexes worth adding in one of the threads..
I added a number of indexes, and it appeared to have a very positive effect..
Any hep finding posts about adding proper indexes for the database?.
I'm looking at my phpMyAdmin and MySQL status and I see stuff like.
Handler_read_rnd 9,327 The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly..
Handler_read_rnd_next 22 M The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.
Select_full_join 1,445 The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.
So I'm guessing that after my providers server migration I am completely without indexes. A nudge in the right direction would be great...
In the RC2a download there are directions for adding a number of indexes on a number of tables. Tthe one on specials probably being the most important one...
I dont think 200 visitors is by any standard an issue with regards to iPage site respose time. it is not clear whether the server in question is a shared one (if so hw many and what type of sites sharing) or a dedicated server. The server tech spesifications is not purticularly powerful by todays standard, and even it is powerful enough there may still be the issue of network or it's backbone, ie, how the server is connected to the outside internet world. if it is a slow one, then that would be the bottleneck, and in that case, whatever you do, it just makes little difference..
I found this forum post that seems to relate to the RC2a indexes.
This has spurred me on to take a closer look at my database and I see that there are actually indexes in the right places denoted by an underline on the field name of the index of each table. Is there any chance that after a server migration that the indexes should be rebuilt? Or if they are there they are there and being used?.
On thing of note I see that mySQL is running without query cache enabled. I presume memory caching as compared to disc caching would be a great benefit..
I'm no database guru but any time you are doing joins that are causing full table scans it's a really bad thing..
Currently MySQL is taking about 50-60% of server CPU.
User Domain %CPU %MEM MySQL Processes.
Mysql 54.16 0.60 0.0.
Top Process %CPU 54.5 /usr/sbin/mysqld basedir/ datadir/var/lib/mysql usermysql pid-file/var/lib/mysql/server.mysite.com.pid skip-external-locking.
Top Process %CPU 54.4 /usr/sbin/mysqld basedir/ datadir/var/lib/mysql usermysql pid-file/var/lib/mysql/server.mysite.com.pid skip-external-locking.
Top Process %CPU 54.3 /usr/sbin/mysqld basedir/ datadir/var/lib/mysql usermysql pid-file/var/lib/mysql/server.mysite.com.pid skip-external-locking.
Nobody 0.00 0.00 0.0.
510 0.98 0.01 0.0.
Top Process %CPU 19.0 /usr/bin/php /home/mysite/public_html/forums/viewtopic.php..
Our iPage site is getting very busy, we have between 150 - 200 people on at anyone time..
We have just upgraded to our own server which is dual processor Pentium 4 - 3Ghz each, 1 GB Ram and Scsi Hard Disks..
Does anyone know the best way to speed up our oscommerce site..
So far I have:-.
Used Gzip compression.
Configured MySql's My.cnf similar to mysql's test config my-huge.cnf..
Will database indexing help, if so how and which tables do I concentrate on?.
Does anyone have any advice for php.ini, apache conf file or better mysql settings?.
Should I look at PHP Accelerator?.
Our current problem is:- When we reach peak traffic, additonal people can not view the site, when looking at the resources we are using only 50% of the cpu. Overall load average of 20%..
Also our most popular product is almost always slow and sometimes inaccesible..
Surely this hardware is up to the job..
FYI Our database file is about 26mb, and we have 423 products..
Any advice would be greatly appreciated..
Hi I might help you/give advise.
Could you please send me your.
(you may place fake urls if you'd like).
Private message me for @-mail adres..