MySQL
  • Paladin of the Pegasos
    Paladin of the Pegasos
    tokai
    Posts: 1289 from 2003/2/25
    From: binaryriot
    Heho,

    has someone successfully got MySQL running on MorphOS? I tried the 68k v4 version from aminet, but it just does not want to start at all. And I heard the MorphOS version has some serious problems.

    Any experience reports are appreciated. Thanks.

    regards,
    tokai
  • »20.07.04 - 09:15
    Profile Visit Website
  • buh
  • Butterfly
    Butterfly
    buh
    Posts: 68 from 2004/2/2
    I tried too, but nothing.

    It's a real problem because we have not a sql database on mos.
    I tried msql, but nothing too.

    So if I want to develop in php-apache-mysql I have to use another server for database.

    :-(
  • »20.07.04 - 09:35
    Profile
  • Priest of the Order of the Butterfly
    Priest of the Order of the Butterfly
    bbrv
    Posts: 750 from 2003/2/14
    From: Earth
    MySQL AB has had machines since January 2004. Gunne Steen would be the one to answer this as he sold the machines to them. Where is Mr. Genesi Scandanavia? :-)

    R&B
  • »20.07.04 - 10:17
    Profile Visit Website
  • Acolyte of the Butterfly
    Acolyte of the Butterfly
    BigGun
    Posts: 150 from 2004/6/18
    From: Nagold - Germany
    Hi,

    I've got MySQL 4.1 and Apache with PHP 5
    running on Pegasos on MOS.

    I use the ports done by SixK.


    MySQL and Apache work not bad under MOS but not as nice as under Linux.

    A few things to note:

    - Once started, stopping or restarting Apache and MySQL does not work.
    So playing with the Apache config is not so easy. ;-)
    - MyISAM tables always rely on the OS diskcache to cache database records.
    If you work with bigger MyISAM tables you need to set
    the SFS cache to reasanble high values.
    - PHP needs quite some stack to compile longer scripts.
    This is a PHP *feature*
    With ixstack you can set the PPC stacksize of MOS Apache.
    32kb stack is enough for script of around 1000 lines.
    If MOS PHP runs out of stack Apache will die = reboot needed to restart Apache ;)
    - MySQL problems:
    show databases - create databases does not work!
    As a MyISAM database is only a drawer you can use makedir as replacement :)


    I have succesfully tested MOS MySQL with my database of over 1 GB size.
    I have tested MOS Apache with PHP scripts of over 6,000 lines.
    I use 4 MB stack for Apache to run those scripts.

    The MySQL problems are mainly caused by bugs in posixthreads.
    If these bugs will be fixed - MySQL should work much nicer.

    MySQL might give problems with the ixemul.library bundled with MOS.
    I can send you the version which I use if needed.


    @BBRV
    Yes, MySQL AB ownes 2 Pegasos computers.
    The MySQL Linux PPC releases are compiled on them. :)

    BTW: I work for MySQL AB.
    I've got a Pegasos as well which I prefer to use under MOS.


    Cheers
    Gunnar




    [ Edited by BigGun on 2004/7/20 19:32 ]
  • »20.07.04 - 19:31
    Profile Visit Website
  • Yokemate of Keyboards
    Yokemate of Keyboards
    Andreas_Wolf
    Posts: 12132 from 2003/5/22
    From: Germany
    http://amiga.comscripts.com/phpBB/viewtopic.php?topic=81&forum=2
    http://amiga.comscripts.com/phpBB/viewtopic.php?topic=82&forum=2
  • »20.07.04 - 21:03
    Profile