TinyPortal

Development => Support => Servers & hosts => Topic started by: deep034 on December 05, 2006, 04:08:21 PM

Title: need help, my server is slow
Post by: deep034 on December 05, 2006, 04:08:21 PM
Hey guyz, currently I use SMF and TP combined to make my website into a portal.

OfficialPimpSpace (http://www.officialpimpspace.com/)

The whole website is based on mysql and running on pure data. But I get alot of error like Lost connection to MySQL, and my overhead sometimes goes over 40KB in just couple hrs.

So i need help, any advice which I can take to decrease the overheads, and yes I set mines to optimize tables everyday but is there option to do like 3 times a day b/c thats what i really need.

Currently I have shared hosting with godaddy. But im sure its of the server that all this happens and im planning on getting dedicated servers. but until then i need some help, is there any way to optimize tables more often??

Any advice would be good, thanks!
Title: Re: need help, my server is slow
Post by: IchBin on December 05, 2006, 09:41:11 PM
Your site loaded absolutely fine for me. Although you are graphics intensive on your site. You may want to tone that down some. The host can always be a problem. The more custom scripts you have the slower it will be also. You don't need to run table optimization once a day for a site the size of yours. In fact, I would think that for a site the size of TinyPortal.net you would only need to do it every couple of weeks.
Title: Re: need help, my server is slow
Post by: deep034 on December 05, 2006, 10:19:42 PM
my overhead goes beyond 40KB in few hrs, is that lot.

btw im going dedicated soon, buying two servers. on for mysql and the other for web graphics and etc.
Title: Re: need help, my server is slow
Post by: Xycose on December 06, 2006, 12:05:30 AM
Loaded plenty fast for me too, maybe it's just you? If your going to upgrade, I would upgrade to a VPS(Virtual Private Server) first, because most likely, thats all you need now, and it's a ton cheaper then 2 dedicated.
Title: Re: need help, my server is slow
Post by: deep034 on December 06, 2006, 12:15:09 AM
i understand what you guyz are saying, but you cant compare TP to any myspace resource sites. TP is mostly just a forum and a small community (not trying to affend anybody). But you might have seen some popular myspace website, so much stuff is used like images, mysql databases and lot of bandwidth and good servers are required for that.
i know my website isnt slow right now, that not what i was trying to say. I get lot of Lost connection to MySQL errors and my overheard for tables are pretty high too. i know my website loads pretty fast.

My website has only been up for about couple weeks and already getting 1400-2000uniques per day, which is lot for a really new site. I know in a few months it will reach 10000 per day or even more so I need to act beforehand and get the good servers. if i dont it will hurt later.

Can you imagine one of your scripts running on more than 10000 profiles, which puts lot of load on the servers and database. so im just acting before hand. but im thinking of purchasing one dual xeon processor first and then upgrade as i need more.
Title: Re: need help, my server is slow
Post by: G6Cad on December 06, 2006, 12:28:17 AM
And again, it is NOT SMF or TinyPortals fault, it's a host thing and a server settings issue if you loos the connection to the database. You have to sort that issue out with your host.

Quotebut you cant compare TP to any myspace resource sites. TP is mostly just a forum and a small community

TP is NOT a forum, it's a MOD for a forum called SMF  ;) that gives you a whole new world of features for your SMF install.

Title: Re: need help, my server is slow
Post by: deep034 on December 06, 2006, 12:33:01 AM
i know i was just sating it that its related to a forum (love TP :))
i know its not the fault of smf or tp, looks like this topic went off a little.

my original questions was is there any way to optimize tables more than once a day??
my overhead goes over 40KB in few hrs, does this happen to you guyz too or is it just me??
Title: Re: need help, my server is slow
Post by: Thurnok on December 06, 2006, 04:21:53 AM
I think the confusion is based on the fact you titled this thread "need help, my server is slow", then someone mentioned it loaded fast to them, and you replied that you knew your server wasn't slow.

So, you should probably try to make a topic subject more related to the actual issue, since it is afterall.. the Topic.  ;)

As far as your MySQL woes, a lost connection to MySQL error means that the program (in this case, a php program called SMF) had a connection to your MySQL server, but it was closed before or during a transaction.  The issue depends on how your host is configured.  Some hosts run the HTTP Services and MySQL Services on the same server.  If that is the case, your server is probably overloaded.  If your host has a seperate MySQL server, then either the MySQL server you are accessing (and probably many other HTTP Servers at the host are accessing the same MySQL server) is overloaded, or the network connection between your HTTP Server, and the MySQL Server has problems or is overtaxed with accesses.  Anyway you look at it, you will need to contact your Host provider and have them resolve that issue.

As far as comparing TP/SMF to MySpace or any other site, it is irrelavent.  TP/SMF can perform as well as any other php/perl/python/other program out there given it is performing on the same servers and backbone.  Obviously MySpace has a large server farm, and large bandwidth.  If you do the same, your TP/SMF site will perform as well, if not out-perform MySpace.  When you said you can't compare TP to MySpace, you were right, but for the wrong reason.  It's simply because it is very unlikely that you will find someone with a TP/SMF site running on the same hardware/backbone as MySpace or other large social networking type of site.

Yes, I can imagine one of my scripts running on 10,000 profiles - TinyPortal.net has over 13,600 members/profiles and SMF's site has over 70,600 members/profiles.  So we can indeed imagine, and in fact do know what kinds of HTTP Server and MySQL Server loads there can be.  Like I said, its more of a Hardware/bandwidth thing.

As far as table overhead, 90% of your overhead is probably from the sessions table.  This is normal, as sessions tables generally are the most overhead.  While 40k is not extremely significant, it is certainly more than you probably would get on a normal basis for your site due to the server issues you are having I would surmise.  Fixing your server issues, will most likely drop your overhead as well.
Title: Re: need help, my server is slow
Post by: deep034 on December 06, 2006, 06:08:15 AM
Quote from: Thurnok on December 06, 2006, 04:21:53 AM
Yes, I can imagine one of my scripts running on 10,000 profiles - TinyPortal.net has over 13,600 members/profiles and SMF's site has over 70,600 members/profiles.  So we can indeed imagine, and in fact do know what kinds of HTTP Server and MySQL Server loads there can be.  Like I said, its more of a Hardware/bandwidth thing.

let me clear things a bit, my website is not another social network, its a resource website for myspace. and the 10,000 i gave was the lowest possible, i know websites that have tools running on over 200,000 profiles. i guess you mis understoof me, most websites out there for myspace recieve way more traffic than even SMF website, over 100000uniques per day.
and when i talk about scripts/tools running on myspace profiles, im talking about that they are hosted on ur server and perform queries in ur database. so i dont think u can imagine more than 200000 profiles trying to access your database frequently everyday. so i hope these things make some points clear.

and as for tp/smf, i wanted to build a network for all the myspace users instead of just a another myspace resource website that offers stuff. with the help of smf/tp i can track wut all the users are doing and i use that to my advantage to add more content to those sections. smf/tp are like the best things ever, even though i have to do most of the php stuff for all my sections and to make them use it through smf but its definitly worth it. it also gives me the chance to send updates to all my members which helps lot. i get about 30 new members everday so with just one click i can send thousands of emails which will bring back at least 50% of those users. so its amazing and lof users asked me how do i do it, and how much would i charge to give them the modifications i have made. but its priceless since the results im seeing. i dun want anybody to copy the exact same thing i have, which are lot out there.

so thanks for all your help and yes im going to go dedicated soon since i will need it in a few more months. thank you so much.
Title: Re: need help, my server is slow
Post by: Xycose on December 06, 2006, 06:46:07 AM
Do you want to be helped? it almost seems like you don't want to find an answer so whatever exact question your attempting to ask.
Title: Re: need help, my server is slow
Post by: deep034 on December 06, 2006, 07:20:40 AM
well i got the answer for my questions, thanks for who helped in some way,

SMF/TP rocks, :)
Title: Re: need help, my server is slow
Post by: IchBin on December 06, 2006, 05:12:36 PM
Thanks for clearing up the topic at hand deep. :) I think we all were a little confused. I hope your forum takes off as much as you anticipate.
Title: Re: need help, my server is slow
Post by: deep034 on December 06, 2006, 05:29:59 PM
Quote from: IchBinâ„¢ on December 06, 2006, 05:12:36 PM
Thanks for clearing up the topic at hand deep. :) I think we all were a little confused. I hope your forum takes off as much as you anticipate.

ya i hope so too, but my site is less of a forum. forum is just there to just get feedback from users and kinda get a little community chat going, its more like a portal for all the myspace users to get what they need and they can submit their work like layouts, etc. from the looks of what you guyz were saying earlier, looks like you were confused between myspace and myspace resource sites. they are completely different and without myspace there wouldnt be any resource sites. :)

thanks and i cant wait for TP v9.7 to come out, but as you've seen my forum has been modified lot by me so i dont think i'll be able to install the new SMF 1.1 . I already gave it a shot but i get an error when tryin to download it through the package manager saying (the package is corrupt..) :(

but i got what i need and wont need SMF 1.1 that much since I have RC3. thanks for everything guyz and keep up the good work!
Title: Re: need help, my server is slow
Post by: Thurnok on December 06, 2006, 06:18:28 PM
Quote from: deep034 on December 06, 2006, 06:08:15 AM
let me clear things a bit, my website is not another social network, its a resource website for myspace. and the 10,000 i gave was the lowest possible, i know websites that have tools running on over 200,000 profiles. i guess you mis understoof me, most websites out there for myspace recieve way more traffic than even SMF website, over 100000uniques per day.
and when i talk about scripts/tools running on myspace profiles, im talking about that they are hosted on ur server and perform queries in ur database. so i dont think u can imagine more than 200000 profiles trying to access your database frequently everyday. so i hope these things make some points clear.

When I say that I DO know, unless you know me, then you should not dispute that fact or attempt to infer that I do not.  If you would like some information of how many servers I have in my server farm, and how many client devices access those servers, and the number of platforms I support, you can PM me and I'll be happy to fill you in.

Otherwise, try to keep your posts regarding your issue, and not about what you think you know vs. what you think someone else doesn't know.