| Re: MySQL Optimization |
| by brash on 2005/3/16 1:56:34 You should be able to get an idea by typing; top -U<username> at the command prompt. |
| Re: MySQL Optimization |
| by bjbtexas on 2005/3/16 1:37:46 The database is on the same server as part of my total disk quota. I have a Virtual Private Server with: Guaranteed RAM: 256+ Max RAM: 8GB Guaranteed CPU: 208.8+ Mhz 4 Max CPU: 2x3133.4Mhz Before I upgraded, my shared server was faster! I feel they are not delivering what they promised, but I haven't figure out a way to prove it. |
| Re: MySQL Optimization |
| by brash on 2005/3/16 0:55:16 Is your database hosted on a different server to your website? If so, are you using persistent or non persistent connections? The times returned by the MySQL counter and page timer seem ok, the MySQL query count for the front page is consistently around 60 queries which is a little on the high side, but nothing over the top. I did notice that the page execution time did spike up well over 1 second every now and then, but if you are using a shared hosting service this is not unusual. |
| Re: MySQL Optimization |
| by bjbtexas on 2005/3/15 23:57:11 I added the page timer. I also added the Optimize Module and ran it and it seems to be faster now! Thank you! What about MySQL root access. Is there anything to tune up there? I don't know enough about the logs to know what I'd be looking at -- I'm a MS admin by trade  . The level3 support people tell me there is nothing going on. I had them turn on full logging and this is what the came up with: I understand your problem but as I can see thevar/lib/mysql/server.advenquest.net.err you have restarted MySQL server too many times that day. It is possible that when your MySQL was down the M$ spider was digging you site and you got such result. I was complaining because I was #1 on MSN for the term "Snow Skiing" on my site http://www.snow-skiing.com I’m back to # 1 without the "unable to connect to database..." error as the text on the page. They then said they shut off auto restart on the mySQL? -- It didn't help. |
| Re: MySQL Optimization |
| by brash on 2005/3/15 22:30:51 Might also be worth having a scan of this post I made a while back. I also wrote this MySQL query counter and PHP script execution timer which only takes about 5 minutes to install and will give you a very good idea of what system resources are being used. |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|