Search found 171 matches

by Alien_Time
Fri Oct 17, 2014 11:50 am
Forum: [3.x] Discussion
Topic: MyISAM to InnoDB
Replies: 30
Views: 20998

Re: MyISAM to InnoDB

As far I know we use the default engine when installing, and dont provide a engine when creating the tables. That's what I thought too since when I installed 3.1 it was showing Innodb for all phpbb tables. If no storage engine is specified then the default engine will be chosen which is based on th...
by Alien_Time
Fri Oct 17, 2014 9:59 am
Forum: [3.x] Discussion
Topic: MyISAM to InnoDB
Replies: 30
Views: 20998

Re: MyISAM to InnoDB

But if DBAL doesn't use anything specific features that is only available in MyIsam, shouldn't it technically support Innodb already? It might not be ready to use the additional power this storage engine provides but that would not necessary mean DBAL doesn't support it. There is a high chance that ...
by Alien_Time
Thu Oct 16, 2014 11:19 pm
Forum: Chit Chat
Topic: All PHP Frameworks Suck!!
Replies: 13
Views: 26752

Re: All PHP Frameworks Suck!!

I know. I also read some ridiculous argument over silly things between the php developers (rasmus and another guy) dated in 2002 on the idea of introducing array() into php. Rasmus was against it saying it made more sense to leave it as [1,2,3] than using a new system like array(1,2,3). 12 years lat...
by Alien_Time
Thu Oct 16, 2014 11:08 pm
Forum: [3.x] Discussion
Topic: MyISAM to InnoDB
Replies: 30
Views: 20998

Re: MyISAM to InnoDB

AFAIK, phpBB does not use FullText search nor spartial indexes so it is ready for InnoDB. It just does not use InnoDB to its fullest such as foreign keys which would be its greatest gain in performance. That is great to hear. Then with 3.1, would you guys consider adding phpbb default engine as Inn...
by Alien_Time
Thu Oct 16, 2014 7:42 pm
Forum: [3.x] Discussion
Topic: MyISAM to InnoDB
Replies: 30
Views: 20998

Re: MyISAM to InnoDB

If using latest version of WAMPSERVER, if I'm correct (have used it) think its configured to InnoDB as DB storage engine first. Unless phpBB 3.1 can use both types of storage engine and my online web server is setup to use MyISAM first. So could be that phpBB 3.1 does support both types then, but a...
by Alien_Time
Thu Oct 16, 2014 6:57 pm
Forum: [3.x] Discussion
Topic: MyISAM to InnoDB
Replies: 30
Views: 20998

Re: MyISAM to InnoDB

Out of curiosity why do you want to use InnoDB, I know the difference about tables not locking up with InnoDB, but from what I've read in past its geared more towards benefiting very large active forums. Do you have a very large forum, because if not MyISAM will run faster of the two for your board...
by Alien_Time
Thu Oct 16, 2014 4:31 pm
Forum: [3.x] Discussion
Topic: MyISAM to InnoDB
Replies: 30
Views: 20998

Re: MyISAM to InnoDB

On the same note, can I ask what could be an ideal setting for MyIsam when I have a server with 8GB Ram? Look I understand that it is hard to give suggestion without testing out the sql demand, current usage statistics, etc.. but this is for a new server and I want to be ready with an ideal setting ...
by Alien_Time
Thu Oct 16, 2014 4:22 pm
Forum: [3.x] Discussion
Topic: MyISAM to InnoDB
Replies: 30
Views: 20998

Re: MyISAM to InnoDB

News to me if 3.1 is using InnoDB, I'm running it and all tables are MyISAM. From what I can see 3.1 is still using MyISAM, not InnoDB as default for database storage engine. hmm.... thats interesting. I had a test set-up for phpbb 3.1 RC3 in my WAMP server that was installed a few months ago and w...
by Alien_Time
Thu Oct 16, 2014 11:09 am
Forum: [3.x] Discussion
Topic: MyISAM to InnoDB
Replies: 30
Views: 20998

MyISAM to InnoDB

Correct me if I am wrong. But from my memory, I think the older version of php (upto 3.0.12) is using MyISAM as the storage engine and the 3.1 uses InnoDB storage engine, is that right? (This is what I understood when I was looking at the sql tables). If this is the case, when I upgrade 3.0.12 board...
by Alien_Time
Wed Oct 15, 2014 1:31 pm
Forum: [3.1/Ascraeus] Merged RFCs
Topic: [RFC] Support for MariaDB
Replies: 29
Views: 45609

Re: [RFC] Support for MariaDB

Good enough for me... thanks.