Announcement

Collapse
No announcement yet.

Problem script load server or problem with hosting?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Problem script load server or problem with hosting?

    Hello.
    Yesterday, my server, stop my site because, causing a high load on the server.

    In the last weeks and months', I don't made any change, only, upgrade my forum always to the last version.

    My server, report to me this data of the problem:

    It appears that you are running a vBulletin script. There are some optimization techniques that you can find for this here http://www.vbulletin-faq.com/optimiz...tin-server.htm. This should help you with caching and database optimizing that should increase performance while limiting server usage.

    Running Processes:
    danycabl 25463 1.8 0.2 45596 22612 ? SN 20:24 0:00 /usr/bin/php /home/danycabl/public_html/foro/search.php
    danycabl 25605 3.6 0.2 44416 21356 ? SN 20:24 0:00 /usr/bin/php /home/danycabl/public_html/index.php
    danycabl 25606 3.5 0.2 43588 20240 ? SN 20:24 0:00 /usr/bin/php /home/danycabl/public_html/foro/forumdisplay.php
    danycabl 25676 7.1 0.2 46220 22676 ? SN 20:24 0:00 /usr/bin/php /home/danycabl/public_html/foro/showthread.php
    danycabl 25732 4.7 0.2 43328 20172 ? SN 20:24 0:00 /usr/bin/php /home/danycabl/public_html/foro/register.php
    danycabl 25790 0.0 0.2 39724 18428 ? SN 20:24 0:00 /usr/bin/php /home/danycabl/public_html/foro/showthread.php

    Running Queries:
    *************************** 1. row ***************************
    USER: xxx
    DB: xxx
    STATE: closing tables
    TIME: 0
    COMMAND: Query
    INFO: SELECT IF(thread.visible = 2, 1, 0) AS isdeleted,



    post.pagetext AS description,
    thread.*


    FROM thread AS thread




    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)


    WHERE thread.threadid = 50559
    *************************** 2. row ***************************
    USER: xxx
    DB: xxx
    STATE: Opening tables
    TIME: 0
    COMMAND: Query
    INFO: UPDATE session
    SET lastactivity = 1322015072, location = '/foro//register.php', badlocation = 0
    WHERE sessionhash = '43bdbd12c01982342858463c2092e4b9'
    *************************** 3. row ***************************
    USER: xxx
    DB: xxx
    STATE: Opening tables
    TIME: 0
    COMMAND: Query
    INFO: SELECT
    IF(votenum >= 1, votenum, 0) AS votenum,
    IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
    post.pagetext AS preview,
    thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
    thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
    thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount,
    user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
    user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible





    FROM thread AS thread
    LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
    LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 0)



    LEFT JOIN post AS post ON(post.postid = thread.firstpostid)



    WHERE thread.threadid IN (0,725,724)
    ORDER BY thread.sticky DESC, lastpost DESC
    *************************** 4. row ***************************
    USER: xxx
    DB: xxx
    STATE: closing tables
    TIME: 0
    COMMAND: Query
    INFO: SELECT COUNT(*) AS count FROM user WHERE usergroupid = 4
    *************************** 5. row ***************************
    USER: xxx
    DB: xxx
    STATE: Sending data
    TIME: 6
    COMMAND: Query
    INFO: SELECT searchcore.searchgroupid, searchgroup.dateline
    FROM searchcore AS searchcore
    JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid)
    JOIN searchgroup AS searchgroup ON (searchgroup.searchgroupid = searchcore.searchgroupid)

    WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('fabricacion cable blackcat') LIMIT 500

    Current Site Requests:
    150.70.172.102 forocable.com /foro/threads/24396-ayuda-para-liberar-samsung-S5230
    187.138.27.37 forocable.com /foro/search.php?do=process
    187.138.27.37 forocable.com /foro/search.php?do=process
    190.154.60.123 forocable.com /foro/threads/2645-Script-s-comandos-para-modems
    190.154.60.123 forocable.com /foro/threads/41205-Clonar-un-sb5120-o-sbv5121-con-certs
    190.154.60.123 forocable.com /foro/threads/41205-Clonar-un-sb5120-o-sbv5121-con-certs
    190.164.198.215 forocable.com /foro/forums/113-Caj%C3%B3n-de-Sastre
    190.22.184.16 forocable.com /
    190.22.184.16 forocable.com /
    190.22.184.16 forocable.com /
    190.22.184.16 forocable.com /foro/articles.php?
    190.247.76.93 forocable.com /foro/private.php
    190.53.69.69 forocable.com /foro/images/firmas/firma_forocable_tun-tun.jpg
    200.108.111.119 forocable.com /
    201.167.24.165 forocable.com /foro/articles.php?
    201.167.24.165 forocable.com /foro/downloads.php?do=cat&id=18
    222.186.17.99 forocable.com /
    222.186.17.99 forocable.com /foro//register.php
    222.186.17.99 forocable.com /foro/sendmessage.php?do
    222.186.17.99 forocable.com /foro/sendmessage.php?do
    222.186.17.99 forocable.com /foro/showthread.php/11497-Colabora-con-la-comunidad-Cabler
    222.186.17.99 forocable.com /foro/threads/53095-A%F1ade-%93_nomap%94-al-nombre-de-tu-Wi
    222.186.17.99 forocable.com /index.php?
    24.41.149.32 forocable.com /
    24.41.149.32 forocable.com /foro/index.php?
    24.41.149.32 forocable.com /foro/index.php?
    24.41.149.32 forocable.com /foro/index.php?
    24.41.149.32 forocable.com /foro/index.php?
    24.41.149.32 forocable.com /foro/index.php?
    24.41.149.32 forocable.com /foro/private.php
    24.41.149.32 forocable.com /foro/threads/37081-Certificados-Digitais-Diversos-para-Cab
    24.41.149.32 forocable.com /foro/threads/37081-Certificados-Digitais-Diversos-para-Cab
    65.52.109.198 forocable.com /foro/archive/index.php/t-33286.html
    65.52.109.198 forocable.com /foro/archive/index.php/t-8707.html
    65.52.110.143 forocable.com /foro/threads/46781-bat-para-sb5120
    65.52.110.143 forocable.com /foro/threads/46781-bat-para-sb5120
    65.52.110.143 forocable.com /foro/threads/50559-Cert_negeart.exe/page6
    66.249.71.112 forocable.com /foro/downloads.php?do=file&id=558
    66.249.71.112 forocable.com /foro/threads/7540-Intercambio-de-macs-M%C3%83%C6%92%C3%86%
    72.28.208.64 forocable.com /foro/index.php
    96.232.157.61 forocable.com /foro/forumdisplay.php?f=32
    96.232.157.61 forocable.com /foro/forums/32-Normas-y-Disclaimer
    96.232.157.61 forocable.com /foro/forums/32-Normas-y-Disclaimer
    96.232.157.61 forocable.com http://www.forocable.com/foro/showth...11497-Colabora

    After suspending the script:
    20:24:51 up 96 days, 15:53, 3 users, load average: 60.43, 42.03, 21.55
    20:25:21 up 96 days, 15:53, 3 users, load average: 47.40, 40.76, 21.79
    20:25:51 up 96 days, 15:54, 3 users, load average: 31.64, 37.58, 21.34
    20:26:21 up 96 days, 15:54, 2 users, load average: 20.26, 34.26, 20.75
    20:26:51 up 96 days, 15:55, 2 users, load average: 13.31, 31.24, 20.17
    20:27:21 up 96 days, 15:55, 2 users, load average: 9.09, 28.50, 19.61
    20:27:51 up 96 days, 15:56, 2 users, load average: 7.55, 26.29, 19.16
    20:28:21 up 96 days, 15:56, 2 users, load average: 5.21, 23.93, 18.60
    20:28:51 up 96 days, 15:57, 2 users, load average: 3.75, 21.79, 18.06
    20:29:21 up 96 days, 15:57, 2 users, load average: 2.56, 19.79, 17.51
    I have a shared hosting, but never any problem.

    I view this report of my hosting, but I don't view what are the problem.

    Can help me for find the problem/issue?

    Now, I dissabled all addons and restart my site, but I want solved the issue, but I don't view what are the problem.

    Thanks and regards!

  • #2
    Those are just basic queries, nothing that should slow down any server under usual circumstances. Unfortunatately shared hosts are quick to point the finger to scripts like vBulletin even when the problem is their own over-loaded servers.

    How many users do you get daily on a daily basis?

    Comment


    • #3
      Hello.
      I was supposed to the server pointed out to me very quickly, without my forum a loading server problem.

      Now, I tell them reasons to see that my forum is not a server loading problem.

      How many users do you get daily on a daily basis?
      Awstats indicates an average of 5.000 number of visits a day.

      Thanks and regards!

      Comment


      • #4
        I don't know if the problem is related, but in the last weeks, I receive this error message from the forum by e-mail about 5 or 10 times a day (especially in the last days):

        Database error in vBulletin 4.1.8:
        Invalid SQL:
        SELECT searchcore.searchgroupid, searchgroup.dateline
        FROM searchcore AS searchcore
        JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid)
        JOIN searchgroup AS searchgroup ON (searchgroup.searchgroupid = searchcore.searchgroupid)

        WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('fastcert') LIMIT 500; MySQL Error :
        MySQL server has gone away
        Error Number : 2006
        Request Date : Thursday, November 24th 2011 @ 06:44:41 PM
        Error Date : Thursday, November 24th 2011 @ 06:45:03 PM
        Script : http://www.xxxx/foro/search.php?do=process
        Referrer : http://www.xxx/foro/threads/53030-hola-a-todos-necesito-ayuda-para-subir-un-5101
        IP Address : xxx
        Username : xxx
        Classname : vB_Database
        MySQL Version :
        Thanks and regards!

        Comment


        • #5
          MySQL server has gone away
          Contact your hosting provider - mysql server is overloaded. Or change virtual hosting to VPS-hosting - you can see load (and make changes in server) in "live" mode.

          Comment


          • #6
            If you're really getting 5,000 visitors a day you've probably outgrown shared hosting. As was said the error message is something you need to talk to your host about, the server is likely overloaded.

            How many users online does the forum report throughout the day? In other words in any given day what is the max users online as reported by your forum (guests + members)?

            Comment


            • #7
              Originally posted by BirdOPrey5 View Post
              If you're really getting 5,000 visitors a day you've probably outgrown shared hosting. As was said the error message is something you need to talk to your host about, the server is likely overloaded.
              Ok, but, if I need talk with my host because, the server is overloaded by my forum, or only because, the server, its overloaded (and my forum isn't the cause of this overload).(sorry, but my technical english isn't very good and when I talk, I know exactly tell my hosting so they can see that my forum is not the problem, if that is the case).

              How many users online does the forum report throughout the day?
              In other words in any given day what is the max users online as reported by your forum (guests + members)?
              Normally, most users activity on the day I see are about 400 users (guests + members), but I don't know how view the reported by forum the max users online in a day, I view this value in Active users.
              This value I have configured for 60 minutes.

              Thank you very much for your help and attention, and sorry if any phrase isn't correct by me.

              Comment


              • #8
                400 simultaneous users is pushing it for shared hosting- the best shared hosting could handle that but most will have the problems you are having. You will either need to upgrade your hosting package or find a new host.

                Comment


                • #9
                  In the day, the max users connect are 400 (more or less) but in the last 60 minutes, not at the same moment (I have configured the forum for view de users online in the last 60 minutes).
                  I don't know how view what users are connected simultaneous in the same minute.

                  Thanks and regards.

                  Comment


                  • #10
                    See "max-connetions limit:XX\XX" in mysqltuner.pl report. Will indicate how many users simultaneously access the database.

                    Comment


                    • #11
                      Hi.
                      Sorry, but I don' know how view mysqltuner.pl report...sorrys..

                      Edit: I search in google, I need install MySQLTuner, when I have install, I report the value.

                      Thanks and regards!

                      Comment


                      • #12
                        After several days of contact with the hosting, I am informed that, can not install MySQLTuner because my account is a shared account.
                        Hosting indicate that, my forum now works fine (I have dissabled all pluggins and mods), but I received, by mail, mails notifications of my forum with sql connects errors, like this:

                        Database error in vBulletin 4.1.8: Invalid SQL: SELECT searchcore.searchgroupid, searchgroup.dateline FROM searchcore AS searchcore JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid) JOIN searchgroup AS searchgroup ON (searchgroup.searchgroupid = searchcore.searchgroupid) WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('como hacer cable jtag') LIMIT 500;
                        ...
                        For this reasson, I can't view how users online simultaneously acces to database, but I think like Mr.Tampax that, the mysql server is overloaded.

                        But I don't know that I need to tell the hosting so they can see the problem.

                        Thanks and regards.

                        Comment


                        • #13
                          What is the entire error that you received? That just shows a query but not the specific error. There doesn't appear to be anything wrong with the syntax of the query.
                          Translations provided by Google.

                          Wayne Luke
                          The Rabid Badger - a vBulletin Cloud demonstration site.
                          vBulletin 5 API

                          Comment


                          • #14
                            This is the entire mail that I received:


                            Database error in vBulletin 4.1.8: Invalid SQL: SELECT searchcore.searchgroupid, searchgroup.dateline FROM searchcore AS searchcore JOIN searchcore_text AS searchcore_text ON (searchcore_text.searchcoreid = searchcore.searchcoreid) JOIN searchgroup AS searchgroup ON (searchgroup.searchgroupid = searchcore.searchgroupid) WHERE MATCH(searchcore_text.title, searchcore_text.keywordtext) AGAINST ('cmnonexp') LIMIT 500; MySQL Error : MySQL server has gone away Error Number : 2006 Request Date : Wednesday, December 14th 2011 @ 10:02:30 AM Error Date : Wednesday, December 14th 2011 @ 10:03:01 AM Script : http://www.myforum.com/foro/search.php?do=process Referrer : http://www.myforum.com/foro/forums/62-Software IP Address : xxx.xxx.xxx.xxx Username : zonerocks Classname : vB_Database MySQL Version :
                            Thanks and regards.

                            Comment


                            • #15
                              This is a server issue. You'll need to contact your host about this. Here are the reasons for the MySQL server going away:

                              https://www.vbulletin.com/forum/show...265#post310265

                              Also from the MySQL site:

                              http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
                              Vote for:

                              - *Admin Settable Paid Subscription Reminder Timeframe*
                              -
                              *PM - Add ability to reply to originator only*
                              - Add Admin ability to auto-subscribe users to specific channel(s)
                              - "Quick Route" Interface...

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...
                              X