Re: [ubuntu-uk] Ubuntu Minimal, Lighttpd, Perl CGI, PHP and MySQL with Tiny Memory
Just catching up on mails. What about SQLite instead? Ian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kris Douglas Sent: 06 March 2008 17:38 To: British Ubuntu Talk Subject: Re: [ubuntu-uk] Ubuntu Minimal, Lighttpd, Perl CGI,PHP and MySQL with Tiny Memory On Thu, Mar 6, 2008 at 5:14 PM, Andrew Oakley [EMAIL PROTECTED] wrote: I've written a guide to installing Ubuntu Server, Lighttpd (an alternative to the Apache web server), Perl CGI, PHP and MySQL on a machine (or virtual machine) with 64MB of memory or less. http://www.aoakley.com/articles/2008-03-06-ubuntu-minimal-memory.php Comments very much appreciated, in particular the MySQL config. Although Ubuntu does provide a LAMP default install in Ubuntu Server edition, this requires 256MB memory. In particular, Apache and especially the default MySQL install are real memory hogs, and are designed for reasonably heavy-use environments. I saw around 200MB RAM in use with no users connected! My config, in contrast, is designed for test/development environments or very low-use websites, typically serving no more than 6 concurrent users and only simple SQL requests. My tests under Ubuntu 6 LTS Server showed less than 34MB of memory in use. In particular, my config is suitable for very cheap VPS hosting accounts such as vpsville.ca , tektonic.net , cheapvps.co.uk and so forth - basically your own root-access Internet server for less than five quid a month! Sounds cool, but I bet there are much better replacements for MySQL, like Postgres, which runs in quite a low mem footprint. -- Kris Douglas Softdel Limited Hosting Services Web: www.softdel.net Mail: [EMAIL PROTECTED] -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/ -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/
Re: [ubuntu-uk] Ubuntu Minimal, Lighttpd, Perl CGI, PHP and MySQL with Tiny Memory
Ah ignore previous posting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew Oakley Sent: 06 March 2008 21:27 To: British Ubuntu Talk Subject: Re: [ubuntu-uk] Ubuntu Minimal, Lighttpd, Perl CGI, PHP and MySQL with Tiny Memory Kris Douglas wrote: Sounds cool, but I bet there are much better replacements for MySQL, like Postgres, which runs in quite a low mem footprint. Indeed - and I'd start with SQLite which requires no server and is built-in to PHP. My aim was to maintain compatibility with the vast number of ready-made PHP applications that use MySQL, though. -- Andrew Oakley -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/ -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/
Re: [ubuntu-uk] Ubuntu Minimal, Lighttpd, Perl CGI, PHP and MySQL with Tiny Memory
On Thu, Mar 6, 2008 at 9:27 PM, Andrew Oakley [EMAIL PROTECTED] wrote: Kris Douglas wrote: Sounds cool, but I bet there are much better replacements for MySQL, like Postgres, which runs in quite a low mem footprint. Indeed - and I'd start with SQLite which requires no server and is built-in to PHP. My aim was to maintain compatibility with the vast number of ready-made PHP applications that use MySQL, though. -- Andrew Oakley -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/ Ahhh, understood. -- Kris Douglas Softdel Limited Hosting Services Web: www.softdel.net Mail: [EMAIL PROTECTED] -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/
Re: [ubuntu-uk] Ubuntu Minimal, Lighttpd, Perl CGI, PHP and MySQL with Tiny Memory
On Thu, Mar 6, 2008 at 5:14 PM, Andrew Oakley [EMAIL PROTECTED] wrote: I've written a guide to installing Ubuntu Server, Lighttpd (an alternative to the Apache web server), Perl CGI, PHP and MySQL on a machine (or virtual machine) with 64MB of memory or less. http://www.aoakley.com/articles/2008-03-06-ubuntu-minimal-memory.php Comments very much appreciated, in particular the MySQL config. Although Ubuntu does provide a LAMP default install in Ubuntu Server edition, this requires 256MB memory. In particular, Apache and especially the default MySQL install are real memory hogs, and are designed for reasonably heavy-use environments. I saw around 200MB RAM in use with no users connected! My config, in contrast, is designed for test/development environments or very low-use websites, typically serving no more than 6 concurrent users and only simple SQL requests. My tests under Ubuntu 6 LTS Server showed less than 34MB of memory in use. In particular, my config is suitable for very cheap VPS hosting accounts such as vpsville.ca , tektonic.net , cheapvps.co.uk and so forth - basically your own root-access Internet server for less than five quid a month! Sounds cool, but I bet there are much better replacements for MySQL, like Postgres, which runs in quite a low mem footprint. -- Kris Douglas Softdel Limited Hosting Services Web: www.softdel.net Mail: [EMAIL PROTECTED] -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/
[ubuntu-uk] Ubuntu Minimal, Lighttpd, Perl CGI, PHP and MySQL with Tiny Memory
I've written a guide to installing Ubuntu Server, Lighttpd (an alternative to the Apache web server), Perl CGI, PHP and MySQL on a machine (or virtual machine) with 64MB of memory or less. http://www.aoakley.com/articles/2008-03-06-ubuntu-minimal-memory.php Comments very much appreciated, in particular the MySQL config. Although Ubuntu does provide a LAMP default install in Ubuntu Server edition, this requires 256MB memory. In particular, Apache and especially the default MySQL install are real memory hogs, and are designed for reasonably heavy-use environments. I saw around 200MB RAM in use with no users connected! My config, in contrast, is designed for test/development environments or very low-use websites, typically serving no more than 6 concurrent users and only simple SQL requests. My tests under Ubuntu 6 LTS Server showed less than 34MB of memory in use. In particular, my config is suitable for very cheap VPS hosting accounts such as vpsville.ca , tektonic.net , cheapvps.co.uk and so forth - basically your own root-access Internet server for less than five quid a month! -- Andrew Oakley -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/
Re: [ubuntu-uk] Ubuntu Minimal, Lighttpd, Perl CGI, PHP and MySQL with Tiny Memory
Kris Douglas wrote: Sounds cool, but I bet there are much better replacements for MySQL, like Postgres, which runs in quite a low mem footprint. Indeed - and I'd start with SQLite which requires no server and is built-in to PHP. My aim was to maintain compatibility with the vast number of ready-made PHP applications that use MySQL, though. -- Andrew Oakley -- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.kubuntu.org/UKTeam/