Activity Stream
48,167 MEMBERS
6831 ONLINE
besthostingforums On YouTube Subscribe to our Newsletter besthostingforums On Twitter besthostingforums On Facebook besthostingforums On facebook groups

Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 31
  1.     
    #21
    Member
    Quote Originally Posted by Lifetalk View Post
    Tables that have a lot of 'SELECT' queries being run on them will often end up being fragmented.
    Hmmm... why does this happens? I mean the 'fragmented' part.

    (Great thread, btw! Cheers)

  2.     
    #22
    I r Super Cop
    I cannot seem to find the my.cnf file on kloxo! Any help will be appreciated.

    I am not that good with ssh so i want to edit that file through kloxo. I am comfortable that way.
    Follow besthostingforums on FB

    Looking for an Article Writer? Check out my services here.

  3.   Sponsored Links

  4.     
    #23
    Member
    Website's:
    eih.bz pornDDL.me sexytattoochicks.tumblr.com


    I'm worried about OPTIMIZE TABLE query, as I'm sure my mysql server will die.
    I have tables with 4MILL records, ~12GB ..

    How can I optimize such a big table, without any problems.?

  5.     
    #24
    The Wise One
    Website's:
    twilight.ws ddlrank.com
    Quote Originally Posted by pi0tr3k View Post


    I'm worried about OPTIMIZE TABLE query, as I'm sure my mysql server will die.
    I have tables with 4MILL records, ~12GB ..

    How can I optimize such a big table, without any problems.?
    Run it with the nice command.

  6.     
    #25
    Super Member
    Quote Originally Posted by Rox View Post
    I cannot seem to find the my.cnf file on kloxo! Any help will be appreciated.

    I am not that good with ssh so i want to edit that file through kloxo. I am comfortable that way.
    It should be in the /etc/ folder?

    What operating system are you running?

    So kiss me and smile for me, say that you'll wait for me <'3

  7.     
    #26
    I r Super Cop
    Centos
    Follow besthostingforums on FB

    Looking for an Article Writer? Check out my services here.

  8.     
    #27
    Super Member
    Yes, it should be in the /etc/ folder called my.cnf

    Can you not find it?

    So kiss me and smile for me, say that you'll wait for me <'3

  9.     
    #28
    I r Super Cop
    I cannot find the /etc/ folder lol
    Follow besthostingforums on FB

    Looking for an Article Writer? Check out my services here.

  10.     
    #29
    Super Member
    the /etc/ folder should be a folder in your / directory, so you need to go to the highest directory then locate the etc folder, if in SSH type "cd /etc/" without quotes

    I suggest you try SSH, it is very good once you are used to doing stuff, and nano is an extremely easy editor to use, as simple as notepad.

    So kiss me and smile for me, say that you'll wait for me <'3

  11.     
    #30
    I r Super Cop
    Arh! Will use SSH. Thanks for this post Sp
    Follow besthostingforums on FB

    Looking for an Article Writer? Check out my services here.

Page 3 of 4 FirstFirst 1234 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [Hiring] someone to optimize DLE script
    By downfreak in forum Completed Transactions
    Replies: 4
    Last Post: 25th Sep 2011, 05:31 AM
  2. [Hiring] Someone to optimize Mysql
    By samipk in forum Completed Transactions
    Replies: 3
    Last Post: 19th Jul 2011, 09:01 PM
  3. mysql usage 99.8%|Site Not Loading|Please help to optimize
    By raj1126 in forum Technical Help Desk Support
    Replies: 18
    Last Post: 11th Nov 2010, 05:59 AM
  4. Looking for someone to optimize Wordpress and IPB
    By Neokenzo in forum Webmaster Discussion
    Replies: 2
    Last Post: 24th Nov 2009, 05:50 PM
  5. How to optimize mysql
    By vgnheart in forum Server Management
    Replies: 1
    Last Post: 20th Jun 2009, 10:59 AM

Tags for this Thread

BE SOCIAL