[ABANDONED] LAMP addon - Linux, Apache, MySQL PHP bundle


  • Can you compile this for odroid C2


    Uploaded service.web.lamp-8.0.20-Odroid_C2-aarch64.zip - I assume Odroid builds are only from master (v8.0)?


    Untested because don't own this hw.

    Gone...

    Edited once, last by vpeter ().


  • Uploaded service.web.lamp-8.0.20-Odroid_C2-aarch64.zip - I assume Odroid builds are only from master (v8.0)?


    Untested because don't own this hw.


    Thanks there is a build in odroid forum with LE 7.0


  • there is a build in odroid forum with LE 7.0


    I uploaded service.web.lamp-7.0.20-Odroid_C2-aarch64.zip for 7.0 version too.


    Still untested because still don't own this piece of hw

    Gone...

    Edited once, last by vpeter ().


  • Is this available for x86?


    service.web.lamp-7.0.20-Generic-x86_64.zip


    If needs for master let me know. But will build them anyway soon computer will be idle.

    Gone...

    Edited once, last by vpeter ().


  • Any tips on settings to tweak to optimise SQL?


    Did you mean for Kodi? If yes, I using

    Code
    1. query_cache_type        = 1
    2. query_cache_size        = 5M
    3. skip-name-resolve
    4. default-storage-engine  = innodb


    And it works pretty well for me (not big Library, two Pi's clients). Make sure that your Videos DB are innodb also (you can create it with default-storage-engine, or you can alter existing one).


    I modified also a few of other parameters (not sure which one, some of them are setuped already from vpeters template), not sure if it havinf much influence, but innodb and query cache are confirmed along Kodi forums..

    2x VIM3L, 3x X96 Air P3, 6x C2; 6x RPi2; 3x Win7 Kodi + vPeter's mariaDB plugin as Library DB

    Edited once, last by JimmySmith ().

  • Thanks JimmySmith


    Have actually made a few changes similar to suggested except the InnoDB change.
    Will try converting DB

  • Update:
    Changed to InnoDB, seems to have solved the lagging problem ive had.
    Dare I say its been working floorlesly for the past 3 days!
    Thanks again, hope they add this addon to LibreElec AddOn library.


  • hope they add this addon to LibreElec AddOn library


    If with they means me then don't expect that. It is old discussion and things like this were not acceptable to include in any way. That's why this addon is somewhere lost in space without people knowing it exist


    I'm almost sure there will be mysql docker version available one day. You could use that then.

    Gone...

    Edited once, last by vpeter ().

  • As an official addon.
    Hopefully like you say a Docker version will be available soon. But until then thanks for the work you put into this!

  • Hi,


    how update works? Is it enough to just install latest version, and then

    Code
    1. systemctl stop httpd.service
    2. systemctl disable httpd.service


    for enabling only mysql?


    Or should I uninstall previous version first?

    2x VIM3L, 3x X96 Air P3, 6x C2; 6x RPi2; 3x Win7 Kodi + vPeter's mariaDB plugin as Library DB