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.
    • scottalanmillerS
      scottalanmiller @technobabble
      last edited by

      @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.

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

        @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?

        T 1 Reply Last reply Reply Quote 0
        • 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