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
      last edited by technobabble

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

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

      I reinstalled my backup and will worry about the upgrade after I have moved to an updated WHM/cPanel account at A Small Orange.

      scottalanmillerS 2 Replies Last reply Reply Quote 0
      • 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