Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Question About Database mysql (Table MyIsam)

10 years 4 months ago
  • davood's Avatar
    Topic Author
  • davood
  • Offline
  • Fresh Boarder
  • Posts: 14
  • Thank you received: 2
Licenses:
JomSocial Active

hi
please Developer Database Jomsocial answer me

i read article in Thread database

i saw jomsocial using Table MyIsam Table
i read and resualt :
InnoDB , for big data (database) , very good, because no need to repair Database, for example crash database , and repair database myisam, for 60 Million, need over 3 day , is very very long
while , in innodb no need for repair
myisam just Optimize and good speed
but
innodb is Appropriate for big data (database), for very high recored, and in InnoDb no crash Databse
1-why jomsocial using MyIsam? joomla using Innodb
2- can i change all table jomsocial to MyIsam Engine? no problem after change?
3-jomsocial support big data (database)? for example Database over 2 terabyte, if my server is very Strong

please read article :
support.rackspace.com/how-to/mysql-engines-myisam-vs-innodb/

10 years 4 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

Hi Davood,

#1 Some of old tables indeed using myIsam, seems that is coming from our old database, on newest table already used innoDB
#2. Yes you can, I think it would be safe :)
#3 Yes is possible, actaully this is really depend with your server configuration, how good you tweak your server actaully, make sure you manage the cache system very well :)

thank you!

10 years 4 months ago
  • davood's Avatar
    Topic Author
  • davood
  • Offline
  • Fresh Boarder
  • Posts: 14
  • Thank you received: 2
Licenses:
JomSocial Active

Thank you
1-In the future , all table jomsocial, convert from MyIsam to InnoDB?
2-if database size= 2 treabyte, which one is better ? InnoDB or MyIsam?
3-jomsocial support Parallel processing?
I do not know about Database, please your team jomsocial Check out , that which one is better, for big data , safe and security and Prevent crashes Database.
Thank you.

10 years 4 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

Hi Davood

1. Yes it will
2. use the latest technology, innoDB is better than MyIsam :)
3. what do you mean with Parallel processing? seems this is server part, right? we dont have special code for this.

thank you!

10 years 4 months ago
  • davood's Avatar
    Topic Author
  • davood
  • Offline
  • Fresh Boarder
  • Posts: 14
  • Thank you received: 2
Licenses:
JomSocial Active

Thank you very much Dimas

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW