1
  • What should we go with for our database project: InnoDB or MyISAM?

    Our department is working on a project that has a ton of database writes (basically a ton of inserts and reads). This project will also be doing over a million database transactions per hour. But we're not sure what to go with here: InnoDB or MyISAM? Which was should we go here? Thanks!

    ITKE392,005 pointsBadges:
  • Changing storage engine in phpMyAdmin

    For my applications, I always use InnoDB. But sometimes, I forget to change it when I'm setting up a table so phpMyAdmin gives me MyISAM. Can I change the storage engine? Thanks.

    ITKE392,005 pointsBadges:
  • InnoDB: Shrink file without having to dump and re-import database

    I'm using InnoDB and it's storing all of my info in one big file. I went in and removed a big table but the file still keeps the same size. Is there a way I can shrink that file without dumping and re-importing my whole database. Thank you very much.

    ITKE392,005 pointsBadges:
  • InnoDB or MyISAM – What is faster?

    This might be a more generic question but I need to know which is faster: InnoDB or MyISAM? Also, does MyISAM need to do disk reads for my data? If so, does that make it slower. Thank you.

    ITKE392,005 pointsBadges:
  • MySQL: Reduce size of ibdata

    We have several production servers that have IBDATA files. These files are increasing daily. Actually, it's almost taken up 300 GB in space. The tables in the servers are InnoDB (most are read and write requests). Also, log file size is going up too. So basically, data continues to rise. Is there a...

    ITKE392,005 pointsBadges:
  • Foreign key constraints support in MyISAM

    Are foreign key constraints supported in MyISAM of MySQL? I have created a table using InnoDB, declaring the foreign key, and now I want to convert that table to MyISAM. Is it possible, and if so, how can I do it?

    Linux - Ask the Expert270 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following