ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    mysql issue

    IT Discussion
    mysql
    3
    16
    5.9k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • T
      technobabble @scottalanmiller
      last edited by technobabble

      @scottalanmiller said:

      @technobabble said:

      Scott, it's a standard VPS server with WHM/cPanel that I use to host my client's websites.

      A standard VPS you would have SSH access to and you can do anything that you want. I've never see a VPS that didn't act like a VPS. In fact, if you don't have that access, I'm not sure it technically even qualifies as a VPS. It's just a non-shared web hosting VM.

      Of course I have SSH access. Doesn't mean I remember how to access it or use it. However now I have something to work with!

      scottalanmillerS 1 Reply Last reply Reply Quote 0
      • T
        technobabble @scottalanmiller
        last edited by

        @scottalanmiller said:

        @technobabble said:

        I remember having to use Putty to access the mysql years ago for a tweak in vBulletin and to do manual backups.

        Then hopefully you just need to remember your login 🙂

        Is cPanel handling your OS updates?

        The OS updates have to be done outside of WHM...which is why my WHM/cPanel updates are not up to date. Moving versus updates gets me a newer hardware!

        scottalanmillerS 1 Reply Last reply Reply Quote 0
        • scottalanmillerS
          scottalanmiller @technobabble
          last edited by

          @technobabble said:

          @scottalanmiller said:

          @technobabble said:

          Scott, it's a standard VPS server with WHM/cPanel that I use to host my client's websites.

          A standard VPS you would have SSH access to and you can do anything that you want. I've never see a VPS that didn't act like a VPS. In fact, if you don't have that access, I'm not sure it technically even qualifies as a VPS. It's just a non-shared web hosting VM.

          Of course I have SSH access. Doesn't mean I remember how to access it or use it. However now I have something to work with!

          I thought that the whole post was about lacking SSH access and needing to do this without it 🙂

          T 1 Reply Last reply Reply Quote 0
          • scottalanmillerS
            scottalanmiller @technobabble
            last edited by

            @technobabble said:

            @scottalanmiller said:

            @technobabble said:

            I remember having to use Putty to access the mysql years ago for a tweak in vBulletin and to do manual backups.

            Then hopefully you just need to remember your login 🙂

            Is cPanel handling your OS updates?

            The OS updates have to be done outside of WHM...which is why my WHM/cPanel updates are not up to date. Moving versus updates gets me a newer hardware!

            Shouldn't you be updating as well? Having an unpatched server is problematic. I would update at least weekly.

            1 Reply Last reply Reply Quote 0
            • T
              technobabble @scottalanmiller
              last edited by technobabble

              @scottalanmiller said:

              @technobabble said:

              @scottalanmiller said:

              @technobabble said:

              Scott, it's a standard VPS server with WHM/cPanel that I use to host my client's websites.

              A standard VPS you would have SSH access to and you can do anything that you want. I've never see a VPS that didn't act like a VPS. In fact, if you don't have that access, I'm not sure it technically even qualifies as a VPS. It's just a non-shared web hosting VM.

              Of course I have SSH access. Doesn't mean I remember how to access it or use it. However now I have something to work with!

              I thought that the whole post was about lacking SSH access and needing to do this without it 🙂

              Nope...wanted people to know although it was a linux box, it was used only for webhosting using the WHM/cPanel software. Sorry for the confusion.

              1 Reply Last reply Reply Quote 0
              • scottalanmillerS
                scottalanmiller
                last edited by

                Gotcha, a bit of a red herring there. Doesn't really play into the issue 🙂

                1 Reply Last reply Reply Quote 0
                • scottalanmillerS
                  scottalanmiller
                  last edited by

                  So first step, get onto the box using SSH.

                  1 Reply Last reply Reply Quote 0
                  • T
                    technobabble
                    last edited by

                    Roger that!

                    1 Reply Last reply Reply Quote 0
                    • scottalanmillerS
                      scottalanmiller
                      last edited by

                      🙂 Now I'm not 100% sure where that setting is tuned, my guess is that it is done so using SQL direction from the MySQL client.

                      1 Reply Last reply Reply Quote 0
                      • stacksofplatesS
                        stacksofplates
                        last edited by

                        looks like you might be able to do this

                        mysql -u <username> -p <password>
                        

                        then at the prompt

                        mysql>show global variables like 'table%';
                        +-------------------------+--------+
                        | Variable_name           | Value  |
                        +-------------------------+--------+
                        | table_definition_cache  | 256    | 
                        | table_lock_wait_timeout | 50     | 
                        | table_open_cache        | 64     | 
                        | table_type              | MyISAM | 
                        +-------------------------+--------+
                        
                        mysql> SET GLOBAL table_definition_cache=128;
                        

                        you can replace 128 with whatever you need.

                        1 Reply Last reply Reply Quote 1
                        • scottalanmillerS
                          scottalanmiller
                          last edited by

                          There you go, that should do it!

                          1 Reply Last reply Reply Quote 0
                          • 1 / 1
                          • First post
                            Last post