Mysql configuration (MyISAM or InnoDB)

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/

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.