Re: [Phpwiki-talk] Phpwiki and Mysql slowness

[John C. <joh...@ua...>]

Reini,
  If I wanted to convert my wiki from mysql to postgres, what would the
procedures be?

Thanks,

John

-----Original Message-----
From: php...@li...
[mailto:php...@li...] On Behalf Of Reini Urban
Sent: Saturday, January 13, 2007 11:31 AM
To: Discussion on PhpWiki features, bugs, development.
Subject: Re: [Phpwiki-talk] Phpwiki and Mysql slowness

2007/1/12, Manuel Vacelet <man...@gm...>:
> 2007/1/9, Reini Urban <ru...@x-...>:
> > 2007/1/8, Manuel Vacelet <man...@gm...>:
> > > I noticed than, sometimes, mysql based phpwikis become slow when there
> > > are several concurrent access.
> > >
> > > I guess it's due to table locking for update operation (phpwiki locks
> > > whole table).
> > >
> > > I'm wondering if it could be a good idea to use innodb table type when
> > > available and replace table locks by transactions as other ACID
> > > complient engines (pgsql, ...) do ?
> >
> > postgresql, oracle or innodb are much better than myisam on crowded
> > servers, yes.
>
> Ok, we will have look on this approach.
> Obviously, we will keep the list informed.

The fastest connect by far has berkeley ("dba - db3 or db4"), but time
sorting
(e.g. RecentChanges) and other advanced queries are very slow.
I recommend dba on small wikis < 500 pages, and then postgresql.
Both, ADODB and PearDB behave fine now. PDO is not that well tested.
dba has serious locking issues with sessions.
>From time to time you'll have to delete the session.db(3,4) file when
it is OS locked. But still better than with gdbm.

For the next release I will work for sql db's on extracting the standard
page and version data properties from serialized blobs into real
table columns.
This will require more sql schema updates, but I hope action=upgrade
will be good enough to do that automatically.

> > BTW: can I expect an updated french translation for the new 1.3.13
features?
>
> I think Sabri (who's working with me on the subject) already gave to
> you the small work he did on the subject.

Thanks.
I checked it in and will do the 1.3.13 release after the remaining
php-5.2.0 checks hopefully tommorrow.

The new 5.2 constructor strictness or the new __toString method can be
the culprit.

Next week I'll be offline in Koeln for some days.
-- 
Reini Urban
http://phpwiki.org/              http://murbreak.at/
http://spacemovie.mur.at/   http://helsinki.at/

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Phpwiki-talk mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phpwiki-talk

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.12/631 - Release Date: 1/16/2007
8:25 AM
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.16.12/631 - Release Date: 1/16/2007
8:25 AM
 
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.