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

Thanks, will try it out out on HTPC

Quote from vpeter

LAMP addon - Linux, Apache, MySQL PHP bundle: LAMP – Google Drive

Same thing as for openelec from here: OpenELEC Mediacenter - OpenELEC Forum - LAMP addon - Linux, Apache, MySQL PHP bundle (1/30)

Tested on imx6 and RPi2.

[hr]
Can you compile this for odroid C2?

Quote from 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

Any tips on settings to tweak to optimise SQL?

Quote from IceQB

Any tips on settings to tweak to optimise SQL?

Did you mean for Kodi? If yes, I using

query_cache_type        = 1
query_cache_size        = 5M
skip-name-resolve
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..

skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K


# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 10M
innodb_additional_mem_pool_size = 2M


# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 2M
innodb_log_buffer_size = 8M


#innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

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.

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

systemctl stop httpd.service
systemctl disable httpd.service

for enabling only mysql?

Or should I uninstall previous version first?

Any ideas on fixing these issues?