Announcement

Collapse
No announcement yet.

optimize database

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

  • optimize database

    Hi i have a problem with webhosting. My hosting has limit
    The maximum amount of data transmitted from / to databases count on the server during the day is 10 GB


    my hosting admin talk that I am using 26 GB

    what can I do to reduce it?

  • #2
    My 2 cents:

    Disable guest searching and maybe even guest viewing of the forums. Switching from the vB internal search engine to the MySQL FULLTEXT one may help as well.

    Although really it just sounds like you need a better host.
    FinalGear.com Forums -- Top Gear and general automotive forums

    Comment


    • #3
      How to switch to MySQL FULLTEXT?

      Any others proposals?

      The list is the longest performing queries:

      Code:
       # Time: 080728 17:19:04
      # # [email protected]: css[css] @  [xx.128.186.175]
      # # Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
      # use css;
      # INSERT into vBgoogle_searches VALUES ('soccerjam
      # v2.07','http://xxxx.com/showthread.php?t=237',1);
      # [email protected]: css[css] @  xx.128.186.175]
      # # Query_time: 2  Lock_time: 0  Rows_sent: 19  Rows_examined: 19
      # use css;
      # SELECT *
      #                         FROM vBdatastore
      #                                                 WHERE title IN
      #                                                 ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache'
      #                                                 ,'products','pluginlist','cron','profilefield','loadcache','noticecache','userstats','birthdaycache','maxloggedin','iconcache','eventcache','
      #                                                 mailqueue','blogstats','blogcategorycache');
      #
      # Time: 080728 17:05:47
      # [email protected]: css[css] @  [xx.128.186.175]
      # Query_time: 3  Lock_time: 0  Rows_sent: 2  Rows_examined: 8
      use css;
      SELECT prefix.*
                              FROM vBforumprefixset AS forumprefixset
                              INNER JOIN vBprefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
                              INNER JOIN vBprefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
                              WHERE forumprefixset.forumid = 10
                              ORDER BY prefixset.displayorder, prefix.displayorder;
      # Time: 080728 16:35:46
      # [email protected]: css[css] @  [xx.128.186.175]
      # Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
      use css;
      SELECT hits FROM vBgoogle_searches where kw='nicki do cs';
      # [email protected]: dif_2[dif_2] @  [xx.128.186.169]
      # Query_time: 2  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
      use dif_2;
      SELECT * FROM pliki WHERE id_pliku=1815;

      Comment

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