Login or create new account.

By registering on joomprod.com, you will have immediate access to all our free products and to the public side of our support forum.

Enjoy our subscriptions.

Each of our subscriptions allow you to enjoy the private side of the support forum and all the update of our products for a period ranging from 3 months to 1 year.

Payment And immediate download.

After subscribing to one of our subscription, the products are immediately downloadable.

Accueil / forum / Public Forum / Main Forum / myISAM vs innoDB table engine

Support Availability Because we must sleep sometimes

Working days: Monday to Friday.
Reply time: Depending on the complexity of your support issue it's usually between a few hours to 48 hours.

Support is only guaranteed to paid subscribers

AdsManager - End of life

It is with great regrets that we have chosen to end the developpement of Adsmanager and its other associated components.

AdsManager is born 10 years ago and, as of today, the number of new subscriptions and downloads have fallen and we cannot maintain the component anymore.

All active subscribers will be able to continue enjoying support until the end of their subscription.

The components will be free and no support will be provided anymore for the other users.

Notice

The forum is in read only mode.

× OLD Forum post could be checked here : forum.joomprod.com

myISAM vs innoDB table engine

Start
Prev
1
Next
End

Senga
Topic Author
Offline
Gold

11 years 6 months ago #11418 by Senga

myISAM vs innoDB table engine was created by Senga

I need to convert from MyISAM to INNODB default storage engine. I recently downloaded Gold Packnew Version 3_0_4 and installed it on my site. I am using Community Builder for users login and user management, all Joomla tables and cb tables (comprofiler and cbsubs) need to be fixed to InnoDB default engine. CB uses the engine of the _users table specifically. The script strictly dictates it.

Ideally, I would like to change whole database at once, by running a SQL query in phpMyAdmin. Preparing for the process, when I was looking at the site database, I noticed that adsmanager tables are using MyIsam storage engine, while other adsmanager component tables are already using InnoD.

From now onward, I will have InnoDB as the default storage engine for all tables including Joomla tables and MyIsam will only be used if that application specifically mentions MyIsam during installation, my questions are:
- Does adsmanger mentions MyIsam in table DDL?
- Why is MyIsam storage engine used for adsmanager after installation instead of InnoDB?
- If the SE Storage engine is not mentioned in the installation script, it should automatically defaults to users server set-up, correct?
- If the SE Storage engine is mentioned in the installation script, can I manually change MyIsam to InnoDB of the new installation? I am concerned that this could still cause problems in the future during upgrades when new tables are created and table definition explicitly specifies MyIsam.

The following user(s) said Thank You: adarr

loic
Offline
Gold

11 years 6 months ago - 11 years 6 months ago #11439 by loic

Replied by loic on topic myISAM vs innoDB table engine

Hello,

The SQL file is in 'backend/install.sql'.

You can update the sql code if you wish.

However the innoDB doesn't manage the fulltext search.

Best regards.

Last edit: 11 years 6 months ago by loic.

The following user(s) said Thank You: Senga, adarr

Senga
Topic Author
Offline
Gold

11 years 5 months ago #11591 by Senga

Replied by Senga on topic myISAM vs innoDB table engine

Hi Loic,
Good to know and thank you. I will keep myISAM for your tables. Do you see any possible conflict with future updates if I use innoDB as the default?
Best,

The following user(s) said Thank You: adarr

loic
Offline
Gold

11 years 5 months ago #11609 by loic

Replied by loic on topic myISAM vs innoDB table engine

Hello,

The table format are directly written in the SQL code so there will be no problem.

The default table format will be used when no format are specified in the SQL code.

Best regards.

The following user(s) said Thank You: adarr

Start
Prev
1
Next
End

Moderators: perry

Time to create page: 0.045 seconds