Professional Web Applications Themes

Best Linux OS for MySql - MySQL

Hello, I had a mysql database running on windows 2K and want to migrate it to a Linux. In performance terms, what Linux kernel (in x86 : Intel Pentium 4 Prescott at 3.2 GHz and SCSI U320 hard drive) provide the best general performances with Mysql ? Thank you for your answers !...

  1. #1

    Default Best Linux OS for MySql

    Hello,

    I had a mysql database running on windows 2K and want to migrate it to
    a Linux.
    In performance terms, what Linux kernel (in x86 : Intel Pentium 4
    Prescott at 3.2 GHz and SCSI U320 hard drive) provide the best general
    performances with Mysql ?

    Thank you for your answers !

    fxzzzzzzzz Guest

  2. #2

    Default Re: Best Linux OS for MySql

    "fxzzzzzzzz" <fxzzfree.fr> wrote in message
    news:44005aa2$0$30865$636a55cenews.free.fr...
    > In performance terms, what Linux kernel (in x86 : Intel Pentium 4 Prescott
    > at 3.2 GHz and SCSI U320 hard drive) provide the best general performances
    > with Mysql ?
    I would recommend just getting the latest Linux in a supported distro. I
    don't think it's worthwhile using an older kernel just to get another sliver
    of performance. It's likely that any gain you can get from different kernel
    versions is an insignificant fraction of the gain you get by other factors:
    - equip the server with enough RAM memory
    - increase MySQL key buffers
    - create the right indexes
    - design your schema and queries well

    Using the latest Linux software also helps in avoiding operating system
    security vulnerabilities.

    Fedora Core is very popular, it's _actually_ free (unlike Redhat), and
    release 5 is apparently coming in March 2006. I'm currently using SuSE, but
    if I were installing a new Linux system I'd wait for FC5.

    Regards,
    Bill K.


    Bill Karwin Guest

  3. #3

    Default Re: Best Linux OS for MySql

    > Even better, run it on Solaris. Less chance for hackers to f*ck with
    > you. (Not NO CHANCE, LESS CHANCE).
    >
    > It's as free as Linux.
    Or run with FreeBSD, OpenBSD for better performance of kernel and high level
    security





    Artur Bac Guest

  4. #4

    Default Re: Best Linux OS for MySql

    "Bill Karwin" <billkarwin.com> wrote in message
    news:dtqe3p01s8kenews2.newsguy.com...
    > "fxzzzzzzzz" <fxzzfree.fr> wrote in message
    > news:44005aa2$0$30865$636a55cenews.free.fr...
    > > In performance terms, what Linux kernel (in x86 : Intel Pentium 4
    Prescott
    > > at 3.2 GHz and SCSI U320 hard drive) provide the best general
    performances
    > > with Mysql ?
    >
    > I would recommend just getting the latest Linux in a supported distro. I
    > don't think it's worthwhile using an older kernel just to get another
    sliver
    > of performance. It's likely that any gain you can get from different
    kernel
    > versions is an insignificant fraction of the gain you get by other
    factors:
    > - equip the server with enough RAM memory
    > - increase MySQL key buffers
    > - create the right indexes
    > - design your schema and queries well
    >
    > Using the latest Linux software also helps in avoiding operating system
    > security vulnerabilities.
    >
    > Fedora Core is very popular, it's _actually_ free (unlike Redhat), and
    > release 5 is apparently coming in March 2006. I'm currently using SuSE,
    but
    > if I were installing a new Linux system I'd wait for FC5.
    >
    > Regards,
    > Bill K.
    >
    >
    Mandriva 2006. Very robust and slick package. Download it for free or order
    a DVD from linuxcentral.com for $9.99 (well worth it.)


    Bosconian Guest

Similar Threads

  1. backup mysql from Linux to Windows?
    By Ask Josephsen in forum MySQL
    Replies: 10
    Last Post: April 13th, 08:56 PM
  2. Replies: 1
    Last Post: February 15th, 07:38 PM
  3. MySQL 4.1.16 compile failure under Linux 2.6.12.2
    By George R. Kasica in forum MySQL
    Replies: 0
    Last Post: February 2nd, 09:30 PM
  4. Can't connect to MySQL [ColdFusion MX 7] on Linux
    By punjab4833 in forum Coldfusion Database Access
    Replies: 10
    Last Post: November 15th, 04:05 PM
  5. Installing Suse Linux 8.2 for hosting PHP/MySQL on a LAN
    By Jeff Breitner in forum Linux Setup, Configuration & Administration
    Replies: 0
    Last Post: September 6th, 03:05 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139