Re: FreeBSD MySQL still WAY slower than Linux

From: Mark Kirkwood (markir_at_paradise.net.nz)
Date: 06/21/05

  • Next message: Khanh Cao Van: "howto update freebsd 4.7 release to 4.7 stable" 
    Date: Tue, 21 Jun 2005 11:15:05 +1200
To: Michael Schuh <michael.schuh@gmail.com>

    Michael Schuh wrote:
    > Hello,
    >
    > yes random IO is more targetted to Databases.
    > noop, i have the installation always made in the same way, and i have respected
    > the different diskperformace in different disk-parts.....
    > this was the reason for
    >
    > #cd /;
    >
    > at the beginning of my tests.
    > In the first test i have me shooting self in my foot and i bites me in
    > my ass :-)))
    >

    I was referring to the partitions and slices on the physical disk - each
    operating system is installed in a different one of these, and so is in
    a different physical part of the disk - hence you cannot reliably
    compare IO rates between them (This very issue has been discussed before
    I recall - try a Google search, as it is quite interesting).

    > my suggestion going more in the direction...first solve all disk(ata) related
    > performace issues, then test the mysql-performaces issues again to secure
    > that you are not lying on an mixing of many problems.... :-)
    >

    While noone would complain about faster sequential IO, it is almost
    certainly not the issue effecting database performance - for instance I
    find Postgresql consistently faster on RELENG_5 (5.3 onwards) than on
    RELENG_4 (using the pgbench program).

    cheers

    Mark

    _______________________________________________
    freebsd-stable@freebsd.org mailing list
    http://lists.freebsd.org/mailman/listinfo/freebsd-stable
    To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org"

  • Next message: Khanh Cao Van: "howto update freebsd 4.7 release to 4.7 stable"

    Relevant Pages

    • Re: Access 2: Cant Perform Join- Combined Fields Too Long
      ... I am still maintaining Access 2.0 databases, ... installation procedure on each PC'. ... machines, figuring I suppose that anyone who wanted to use Access ... point to the former Office installation which was on Drive C (which on ...
      (comp.databases.ms-access)
    • Restore databases into a new installation of SQL Server
      ... I want to restore my databases from the old SQL Server installation ... Can anyone tell me how to restore my databases from the old SQL Server ...
      (microsoft.public.sqlserver.server)
    • MS Visual Basic Help window doesnt display help on some topics
      ... The first five topics listed are "CreateDatabase Method", "Databases ... When I type "recordset" in the lookup box, of the twenty topics to display ... copy of Office on the computer--just a bare-bones installation. ... a tip from a friend, and custom installed just about everything except clip ...
      (microsoft.public.access.setupconfig)
    • Re: MSDE and VS.NET Quickstart Tutorials
      ... databases (master, model, msdb, and tempdb). ... the 80\Tools\Binn directory of your installation. ... > SQL Server does not exist or access denied. ...
      (microsoft.public.sqlserver.msde)