|
Author
|
Message
|
|
Andreas Kaiser
|
Tuesday 10 June 2008 4:54:07 am
Hi, I'm not a mysql/database expert, but I've being searching about the differences of InnoDB and MyISAM. Basically I've found that innoDB is fast for inserting and MyISAM for select. This post is interesting about the database of wikipedia and recommends InnoDB: http://mysqldatabaseadministration.blogspot.com/2006/02/innodb-or-myisam-whats-your-preference.html#c113907181500392305 For large projects based in ezp4 what database configuration do you would recommend? What experience do you have? Would you use PostgreSQL or Mysql or Oracle (ezp 4.1)?
eZ Partner in Madrid (Spain)
Web: http://www.atela.net/
|
|
Piotrek Karaś
|
Tuesday 10 June 2008 9:27:32 am
Andreas, You need InnoDB in order to have transactions in MySQL, and that might be a must for large projects. Also, if you plan some dedicated tables using MyISAM, I would check on how those tables deal with data removal (I heard that there are problems) and also consider the use. I don't know much about other DBs, but seems to me like MySQL is getting more and more appreciated for its efficiency. BTW. Has anyone tried to run eZ Publish with MySQL isolation level set to SERIALIZABLE? ;)
--
Company: mediaSELF Sp. z o.o., http://www.mediaself.pl
eZ references: http://ez.no/partners/worldwide_partners/mediaself
eZ certified developer: http://ez.no/certification/verify/272585
eZ blog: http://ez.ryba.eu
|
|
Jianjun Hu
|
Sunday 12 April 2009 6:05:58 pm
It is the question I want to ask. I'm using InnoDB, and I think I'm right. Thanks! OnlyBlue
☆．．·°∴°．☆°°．☆°．
°∴ °☆ ．·enjoy star° ．·★°∴°
∴°．°★ ．·°
ミ☆°∴°．★☆° ∴·°
°．☆° ．·∴°
Is it a pleasure after all to practice in due time what one has learnt?
|
|
Paulik Andrei
|
Wednesday 22 April 2009 5:04:09 am
Hi, I have questions to this tema, my provider have not Mysql 5 becouse Mysql 5 is not Production stable. What can I do? Thanks Andrew
|
|
Björn Dieding@xrow.de
|
Wednesday 22 April 2009 6:26:14 am
mysql 5 is production stable 5.1 is latest stable at the moment your provider just has old software on thier server LOL http://dev.mysql.com/downloads/mysql/5.1.html
Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/
|
|
Paulik Andrei
|
Wednesday 22 April 2009 10:59:21 am
Thanks a lot , but I can not install EZ publisch becaue by the instaling , the install script need a user ,to mysql. My proveider give never super user right , I create a db but i can not write the user name wghat the install script give and become eror. By instaling I have not the posibility to define the dbase. I mus looking for other not so complicated script . 90% form provider give never superuser rights. but thanks a lot Andrew
|
|
Gaetano Giunta
|
Wednesday 22 April 2009 1:25:33 pm
You do not need a db user with root privileges on the myssql server to install eZP. You only need a db user with the rights on a single database - the one that will be used. Do not be fooled by the fact that in the page where the setup wizard asks for a db user and password there is no choice of the database to use - that choice is still present at a later page.
Principal Consultant International Business
Member of the Community Project Board
|
|
Paulik Andrei
|
Thursday 23 April 2009 12:53:46 am
the problem is , when i write a user (db) or make anythings become the eror Fatal error: eZ Publish did not finish its request The execution of eZ Publish was abruptly ended, the debug output is present below. Andrew
|
|
Andreas Kaiser
|
Wednesday 29 April 2009 8:11:26 am
Funny to see my old topic related with db live again :) Paulik about your error in installation, it could be memory related (installation is very memory consuming...): Check these topics for more help:
http://ez.no/developer/forum/install_configuration/fatal_error__11/re_fatal_error__4
http://ez.no/developer/forum/install_configuration/problem_with_installation__2
eZ Partner in Madrid (Spain)
Web: http://www.atela.net/
|