News: Welcome to the TinyPortal Support site.

Login  |  Register
HTML5 Icon HTML5 Icon
TP on Social Media
Welcome, Guest. Please login or register.
Did you miss your activation email?

September 19, 2019, 11:25:23 AM

Login with username, password and session length

Recent

Members
  • Total Members: 3752
  • Latest: Alizee
Stats
  • Total Posts: 188917
  • Total Topics: 20754
  • Online Today: 126
  • Online Ever: 629
  • (November 08, 2018, 01:36:54 PM)
Users Online
Users: 2
Guests: 57
Total: 59

Author Topic: need help, my server is slow  (Read 8129 times)

0 Members and 1 Guest are viewing this topic.

deep034

  • Guest
need help, my server is slow
« on: December 05, 2006, 09:08:21 AM »
Hey guyz, currently I use SMF and TP combined to make my website into a portal.

OfficialPimpSpace

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!

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: need help, my server is slow
« Reply #1 on: December 05, 2006, 02: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.

deep034

  • Guest
Re: need help, my server is slow
« Reply #2 on: December 05, 2006, 03: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.

Xycose

  • Guest
Re: need help, my server is slow
« Reply #3 on: December 05, 2006, 05:05:30 PM »
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.

deep034

  • Guest
Re: need help, my server is slow
« Reply #4 on: December 05, 2006, 05:15:09 PM »
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.

Offline G6Cad

  • Friends
  • *
  • Posts: 12643
    • FamiljeGodis
Re: need help, my server is slow
« Reply #5 on: December 05, 2006, 05:28:17 PM »
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.

Quote
but 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.


deep034

  • Guest
Re: need help, my server is slow
« Reply #6 on: December 05, 2006, 05:33:01 PM »
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??

Offline Thurnok

  • Friends
  • *
  • Posts: 784
Re: need help, my server is slow
« Reply #7 on: December 05, 2006, 09:21:53 PM »
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.

deep034

  • Guest
Re: need help, my server is slow
« Reply #8 on: December 05, 2006, 11:08:15 PM »
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.

Xycose

  • Guest
Re: need help, my server is slow
« Reply #9 on: December 05, 2006, 11:46:07 PM »
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.