diff options
Diffstat (limited to 'zarb-ml/mageia-webteam/2011-January/000154.html')
| -rw-r--r-- | zarb-ml/mageia-webteam/2011-January/000154.html | 100 |
1 files changed, 100 insertions, 0 deletions
diff --git a/zarb-ml/mageia-webteam/2011-January/000154.html b/zarb-ml/mageia-webteam/2011-January/000154.html new file mode 100644 index 000000000..815dd6f12 --- /dev/null +++ b/zarb-ml/mageia-webteam/2011-January/000154.html @@ -0,0 +1,100 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> +<HTML> + <HEAD> + <TITLE> [Mageia-webteam] [Mageia-sysadm] Forum VM needs + </TITLE> + <LINK REL="Index" HREF="index.html" > + <LINK REL="made" HREF="mailto:mageia-webteam%40mageia.org?Subject=Re%3A%20%5BMageia-webteam%5D%20%5BMageia-sysadm%5D%20%20%20Forum%20VM%20needs&In-Reply-To=%3C4D3031C1.1010008%40vilarem.net%3E"> + <META NAME="robots" CONTENT="index,nofollow"> + <META http-equiv="Content-Type" content="text/html; charset=us-ascii"> + <LINK REL="Previous" HREF="000152.html"> + <LINK REL="Next" HREF="000155.html"> + </HEAD> + <BODY BGCOLOR="#ffffff"> + <H1>[Mageia-webteam] [Mageia-sysadm] Forum VM needs</H1> + <B>Maât</B> + <A HREF="mailto:mageia-webteam%40mageia.org?Subject=Re%3A%20%5BMageia-webteam%5D%20%5BMageia-sysadm%5D%20%20%20Forum%20VM%20needs&In-Reply-To=%3C4D3031C1.1010008%40vilarem.net%3E" + TITLE="[Mageia-webteam] [Mageia-sysadm] Forum VM needs">maat-ml at vilarem.net + </A><BR> + <I>Fri Jan 14 12:21:37 CET 2011</I> + <P><UL> + <LI>Previous message: <A HREF="000152.html">[Mageia-webteam] [Mageia-sysadm] Forum VM needs +</A></li> + <LI>Next message: <A HREF="000155.html">[Mageia-webteam] [Mageia-sysadm] Forum VM needs +</A></li> + <LI> <B>Messages sorted by:</B> + <a href="date.html#154">[ date ]</a> + <a href="thread.html#154">[ thread ]</a> + <a href="subject.html#154">[ subject ]</a> + <a href="author.html#154">[ author ]</a> + </LI> + </UL> + <HR> +<!--beginarticle--> +<PRE>Le 13/01/2011 13:50, Olivier Thauvin a écrit : +><i> * Michael Scherer (<A HREF="https://www.mageia.org/mailman/listinfo/mageia-webteam">misc at zarb.org</A>) wrote: +</I>>><i> Le mercredi 12 janvier 2011 à 23:05 +0100, Maât a écrit : +</I>>>><i> Le 12/01/2011 22:37, nicolas vigier a écrit : +</I>>>>><i> On Wed, 12 Jan 2011, Maât wrote: +</I>>>>>><i> So phpBB needs a LAMP Stack : Apache + PHP5 + MysSQL5 (it prefers to have MySQLi extention) +</I>>>>><i> Do you know if it would be possible to use Postgresql instead of MySQL ? +</I>>>>><i> We already have a Postgresql server running on alamut that we could use. +</I>>>><i> phpBB3 is supposed to work with PostgreSQL 7.3+ though it's not as widely used as MySQL as a phpBB backend. +</I>>><i> Great, so more testing to do /o\ +</I>><i> In practice, if the SQL was properly written, the SQL must work on any +</I>><i> PGSQL version, especially since it have to work on other SQL server +</I>><i> (mysql). +</I>><i> +</I>><i> But who know with php apps. +</I>><i> +</I>Troll™ detected ^^ + +>>><i> The problem (for me) is that i just know the basic of PostgreSQL... so we'll need someone else skilled +</I>>>><i> enough to tune it (and i'd be truly happy to learn from him/her) +</I>>><i> Nanar will be able to do it, even if hosting a small database like this +</I>>><i> may not be very appealing to him. There is just 5g, when compared to +</I>>><i> sophie, I let him give the numbers. +</I>><i> Sophie: +</I>><i> - on disk size: ~ 200GB +</I>><i> - biggers tables, rows estimated to 150 millions, next table 16 millions +</I>><i> - 1208570 rpms in it currently +</I>><i> +</I>><i> I manage 5 posgresql servers at works. +</I>><i> +</I>><i> +</I>\o/ Master ! + +Teach me :) + +Nota : the difficult part with a forum is not really in the table size for tuning but in the complexity of requests with lots of joins mixed with the number of simultaneous read&write calls which can quickly make the server bite the dust :-/ + +=> clever indexing, good cache and memory tuning, good storage format (to avoid pessimistic table locking and to allow quick parsing with sometimes fulltext indexes) + +(and database backup while users are using the forum without making it unusable can also be a challenge) + +cheers, +Maât + +</PRE> + + +<!--endarticle--> + <HR> + <P><UL> + <!--threads--> + <LI>Previous message: <A HREF="000152.html">[Mageia-webteam] [Mageia-sysadm] Forum VM needs +</A></li> + <LI>Next message: <A HREF="000155.html">[Mageia-webteam] [Mageia-sysadm] Forum VM needs +</A></li> + <LI> <B>Messages sorted by:</B> + <a href="date.html#154">[ date ]</a> + <a href="thread.html#154">[ thread ]</a> + <a href="subject.html#154">[ subject ]</a> + <a href="author.html#154">[ author ]</a> + </LI> + </UL> + +<hr> +<a href="https://www.mageia.org/mailman/listinfo/mageia-webteam">More information about the Mageia-webteam +mailing list</a><br> +</body></html> |