PDA

View Full Version : Can You Guys Improve Your Servers/Software Performance?


tennisbum79
May 27th, 2011, 02:26 PM
THis is one the main tennis forum in the world, yet whenever there a little increase in the volume of the users, it crashes.

You have been in business for a long time now, and there several opens ource development tools availbale to help improve your software performance.
Given the unemployment rate in the US, you should have no trouble finding developers who can optimize your software(or software architecture)

Getting "Database error" page is not pleasant

Super Dave
Jun 1st, 2011, 02:12 PM
Tons of db errors lately.

Kəv.
Jun 2nd, 2011, 07:21 AM
I could not get on for 2 hours yesterday.

Wert.
Jun 2nd, 2011, 08:56 AM
^Neither me...

Jorn
Jun 2nd, 2011, 11:34 AM
Less than 600 ppl in GM and still i get database errors...

It going down TF after the SF today...

ElusiveChanteuse
Jun 2nd, 2011, 02:55 PM
Indeed. I wonder why. Don't think it has happened as frequently as recently during the AO.

Mrs. Dimitrova
Jun 2nd, 2011, 05:30 PM
Yes. Please fix it if you can. :shrug:

Ivanovic2008
Jun 3rd, 2011, 04:02 AM
Yea it's twice a day for 10 minutes and pretty annoying

Aaron.
Jun 3rd, 2011, 04:05 AM
Become premium :p

although I think we still get errors even though they say we're not supposed to

Kim's_fan_4ever
Jun 3rd, 2011, 08:28 PM
Become premium :p

although I think we still get errors even though they say we're not supposed to

You wish :( I get database errors all the time. Even when Fed won :facepalm:

Zamboni
Jun 5th, 2011, 09:46 AM
Become premium :p

although I think we still get errors even though they say we're not supposed to
That has never been said ;)


I asked the webmaster about the database errors and yes they are traffic related, and there's a technical team been assigned to it. That's all I can say, sorry.

ElusiveChanteuse
Jun 5th, 2011, 10:41 AM
Hopefully it will be solved asap as Wimbledon will be in 3 weeks time.:scared:

Jorn
Jun 15th, 2011, 06:40 PM
I still get Database errors (when many online in GM) and other Forums. Will something be done before Wimbledon in next week?

iGOAT
Jun 19th, 2011, 03:30 PM
More database errors lately :yawn:.

Bismarck.
Jun 21st, 2011, 02:03 PM
Serena sent the servers today into overdrive. :lol:

Mrs. Dimitrova
Jun 21st, 2011, 02:04 PM
TF crashed again when Jelena lost and Serena won at the same time. We're gonna be experiencing a lot of database errors until Wimbledon is over. :lol:

tennisbum79
Jul 11th, 2011, 02:16 AM
That has never been said ;)


I asked the webmaster about the database errors and yes they are traffic related, and there's a technical team been assigned to it. That's all I can say, sorry.
Suggest to your technical team to look at

Optmizing the Database SQL querries
For existence SELECT SQL, add ROWNUM =1 (assuming you are using oracle database)
Add INDEX to table column name used most often in WHERE clause
Remove LIKE in WHERE clause where unnecesary
Avoid selecting field you not need
If using java, optimize you code.

Take a look at long loop and try to shorten them
Avoid memory leak, clean up unused objects
Avoid connection leak, dispose of unused database objects
Add caching ( to most referenced objects that do not change) where appropriate
Upgrade to higher version of Java

Kworb
Jul 11th, 2011, 10:10 AM
Suggest to your technical team to look at

Optmizing the Database SQL querries
For existence SELECT SQL, add ROWNUM =1 (assuming you are using oracle database)
Add INDEX to table column name used most often in WHERE clause
Remove LIKE in WHERE clause where unnecesary
Avoid selecting field you not need
If using java, optimize you code.

Take a look at long loop and try to shorten them
Avoid memory leak, clean up unused objects
Avoid connection leak, dispose of unused database objects
Add caching ( to most referenced objects that do not change) where appropriate
Upgrade to higher version of Java


I doubt they can do all this when they still run a really old version of vB.

longtin23
Jul 12th, 2011, 01:26 PM
Recently I have got many db errors including just now...

tennisbum79
Jul 12th, 2011, 10:43 PM
Recently I have got many db errors including just now...
It is only going to get worse and worse as we approahc the USA open.

One thing to take into consideration is, following Na Li success, more Asian fans may join this forum due to its "world wide popularity"; which is very good thing(and a tribue to the posters here) as it adds diversity of perspective the TF.
With that said, I am afraid the constant database failures might scare away the new members.

The Kaz
Jul 18th, 2011, 02:32 PM
I only get them after a GS final :shrug:

I must be one of the lucky ones :lol:

alicechen
Jul 28th, 2011, 06:06 AM
I wonder why.
Coach Glasses (http://www.discount-coach-handbags-outlet.com/coach-glasses-c-10.html)
discount coach handbags (http://www.discount-coach-handbags-outlet.com)
microsoft office 2010 (http://www.office2010c.com)

tennisbum79
Aug 1st, 2011, 04:18 PM
I only get them after a GS final :shrug:

I must be one of the lucky ones :lol:

Yes, you are one of the lucky ones

I get them at any tournament during or at the end of matches whenever Venus, Serena or Maria are involved.

It does not even have to be a final.

tennisbum79
Aug 29th, 2011, 01:21 PM
Hopefully, we'll have fewer of occurences of the dreaded "Database error" page

tennisbum79
Sep 3rd, 2011, 07:19 PM
Another crash again.

Here is error page in the code.


...
<!--
Database error in vBulletin :
mysqli_real_connect() [&lt;a href='function.mysqli-real-connect'&gt;function.mysqli-real-connect&lt;/a&gt;]: (08004/1040): Too many connections
/usr/sites/wtaworld.com/www/htdocs/includes/class_core.php on line 1040

...


Thhis suggest a connection either a leak, or the number of maximum connections configured in your connection pool has been exceeded.

You could increase the maximum as a temporary relief

Wert.
Sep 3rd, 2011, 09:02 PM
^ No.

Im free member and I had only few DBs in my entire life
For those 7 months,I had like 4 DBs in total :woohoo:

Wert.
Sep 3rd, 2011, 09:46 PM
I wonder why.
Coach Glasses (http://www.discount-coach-handbags-outlet.com/coach-glasses-c-10.html)
discount coach handbags (http://www.discount-coach-handbags-outlet.com)
microsoft office 2010 (http://www.office2010c.com)


:facepalm:

Again :o

tennisbum79
Sep 25th, 2011, 12:18 AM
I'm getting so many DB errors :o

Don't premium members get less DB errors? :o
I don't think the database connection pool play favorite with the user class:lol:

Jorn
Sep 26th, 2011, 07:10 PM
Whats going on tonight? only 22 members in GM, after a few minuts there's 85 online there...