Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: MySQL on Ubuntu 10.04

  1. #1
    Join Date
    Jun 2010
    Beans
    65
    Distro
    Kubuntu 10.04 Lucid Lynx

    MySQL on Ubuntu 10.04

    Hi all, I've recently posted about using my ubuntu server to host MySQL. It currently serves as a file\print and Media Server. I installed MySQL on it. It dual boots with XP pro - no issue with that.
    I have also installed MySQL on the XPpro hard drive. I've noticed extreme lags when I'm running MySQL on the Linux machine. The specs are 1.7 GB and P4 2.8 GHz. I know it's not "super" but I don't have any lag when running the XP machine. Comparing the XP "server" as when I use localhost, the speed seems the same. But, when Linux is running MySQL is to slow to even support the application.

    does anyone have any suggestions? When I use Workbench, connected to Linux the Memory stays at about 24%. So it seems MySQL is not getting enough resource from the OS, but I'm far to new to Linux.

    Thank you for all help.

    -R

  2. #2
    Join Date
    Jun 2010
    Beans
    65
    Distro
    Kubuntu 10.04 Lucid Lynx

    Re: MySQL on Ubuntu 10.04

    Now that I'm working on this tonight, I'm having further issue with not even connecting to the SQL server. When attempting to open my connection I get an "Unable to connect to connect to to any of specified MySQL Hosts" I'm connecting with a User that I know has access, the UN and Password are correct, I've tried multiple time. Sometimes a restart will fix the problem, sometimes it does not. Any ideas? I've attempted to uninstall MySQL and the system just "hangs" during the process, but I was able to reinstall all the MySQL packages (using snaptic), but did not fix it at all. I'm tempted for a complete reinstall - OS and everything. Think it'd help?

    -R

  3. #3
    Join Date
    Apr 2009
    Location
    Located
    Beans
    236
    Distro
    Ubuntu 10.04 Lucid Lynx

    Re: MySQL on Ubuntu 10.04

    mysqltuner helped me out in the past.

    [edit]
    The mysqltuner suggestion was for your main post, not your second post here.

    _
    |
    --------------------------------------------------------------------------------------------------------
    ~ What was once an opinion, became a fact, to be later proven wrong ~

  4. #4
    Join Date
    Jun 2010
    Location
    Tanzania
    Beans
    46
    Distro
    Ubuntu 10.04 Lucid Lynx

    Re: MySQL on Ubuntu 10.04

    Quote Originally Posted by rensell View Post
    Now that I'm working on this tonight, I'm having further issue with not even connecting to the SQL server. When attempting to open my connection I get an "Unable to connect to connect to to any of specified MySQL Hosts" I'm connecting with a User that I know has access, the UN and Password are correct, I've tried multiple time. Sometimes a restart will fix the problem, sometimes it does not. Any ideas? I've attempted to uninstall MySQL and the system just "hangs" during the process, but I was able to reinstall all the MySQL packages (using snaptic), but did not fix it at all. I'm tempted for a complete reinstall - OS and everything. Think it'd help?

    -R
    Reinstall after removing all config stuffs.
    sudo apt-get purge package_name_goes_here

  5. #5
    Join Date
    Jun 2010
    Beans
    65
    Distro
    Kubuntu 10.04 Lucid Lynx

    Re: MySQL on Ubuntu 10.04

    I've tried
    Code:
    sudo apt-get purge mysql-server-5.1
    , but it seems to be "stuck" on "Removing mysql-server-5.1

    Code:
    User@Computer:~$ sudo apt-get purge mysql-server-5.1
    [sudo] password for User:
    Reading package lists... Done
    Building dependency tree
    Reading state information... Done
    The following packages were automatically installed and are no longer required:
      libcurses-perl libnet-daemon-perl libhtml-template-perl libdbi-perl
      mysql-client-core-5.1 libdbd-mysql-perl libvncserver0 mysql-client-5.1
      mysql-common tk libcurses-ui-perl libplrpc-perl mysql-server-core-5.1
      libmysqlclient16
    Use 'apt-get autoremove' to remove them.
    The following packages will be REMOVED:
      mysql-server-5.1*
    0 upgraded, 0 newly installed, 1 to remove and 0 not upgraded.
    After this operation, 15.0MB disk space will be freed.
    Do you want to continue [Y/n]? y
    (Reading database ... 115439 files and directories currently installed.)
    Removing mysql-server-5.1 ...
    been sitting there for about 45 minutes now. Is that normal? I know when I've installed stuff in the past, it was always displaying something whether it's information or percentage(s).

    -R

  6. #6
    Join Date
    Feb 2006
    Beans
    468

    Re: MySQL on Ubuntu 10.04

    HELLo!

    Seems like it has trouble with shutting down the server. You can either wait, and see if it manages to do this, or shut it down manually by using "kill -9 <pid>".

    Happy codin'!

  7. #7
    Join Date
    Jun 2010
    Beans
    65
    Distro
    Kubuntu 10.04 Lucid Lynx

    Re: MySQL on Ubuntu 10.04

    Thanks for all your help. I now got mysql completely reinstalled, and it seems to be working consistently. So, now I'm back to my original post, it is still painfully slow - I can't stress how slow the connection is. Workbench still pegs the memory at 14%. I've run mysqltuner and made the suggested changes, I added skip-innodb to the conf file and increased my query_cache - but have noticed NO difference. I just took my XP conf and edited the paths and still have to wait a long time for the connection(s).

    I am using the EXACT same setting on the EXACT same system - just using Ubuntu vs XP - same version of MySQL (with the exception of windos\linux)

    Any other ideas? I'd really like to continue replacing my windows servers with linux, but I can't with this speed.

    -R

  8. #8
    Join Date
    Jun 2010
    Beans
    65
    Distro
    Kubuntu 10.04 Lucid Lynx

    Re: MySQL on Ubuntu 10.04

    To quantify the speed difference, I timed my login script that uses the entered username and password to connect to MySQL and get a row of data from a database using the given U\N that includes First and Last Name, a color code, and 7 boolean variables and stores them in the program variables.

    From the time I click "Play" in visual basic 2010 to the time I'm logged in:

    Ubuntu: 12 seconds
    XP: 2 Seconds

    10 second difference just for login - with only about 5 usernames on each machine and no one else connected.

  9. #9
    Join Date
    Apr 2009
    Location
    Located
    Beans
    236
    Distro
    Ubuntu 10.04 Lucid Lynx

    Re: MySQL on Ubuntu 10.04

    Quote Originally Posted by rensell View Post
    From the time I click "Play" in visual basic 2010 to the time I'm logged in:

    Ubuntu: 12 seconds
    XP: 2 Seconds
    Im no SQL pro by any means, but maybe more is going on here.
    How are you running a VB app from inside Ubuntu ?
    I dont think wine or vbox would cause a 10 sec delay, but they are another obstacle/variable to consider.

    Maybe trying to narrow down the problem and test with only the bare-bones would be better.

    Can you run the tests, on both machines from the MySQL command line ?

    _
    |
    --------------------------------------------------------------------------------------------------------
    ~ What was once an opinion, became a fact, to be later proven wrong ~

  10. #10
    Join Date
    Nov 2009
    Beans
    1,081

    Re: MySQL on Ubuntu 10.04

    You should enable any slow-query logging first to determine where the time is actually being spent. Also, verify that you have ported not only the schema but all relevant indices.

Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •