1
  • MySQL: How to create InnoDB database

    In MySQL, I recently tried to create a InnoDB database type. This is the query I tried but didn't work: CREATE DATABASE "mydd" ENGINE = InnoDB My configuration says InnoDB is enabled. What else can I do? Thank you.

    ITKE413,315 pointsBadges:
  • Do we have too many records in our MySQL InnoDB?

    We currently have a MySQL InnoDB that has millions of records. We're worried that it's too much for the database. Would you agree? Can the database handle this? Just because we noticed that several of our queries are much slower now. Thank you.

    ITKE413,315 pointsBadges:
  • Cleaning MySQL InnodB storage engine

    I have a friend who needs to clean his MySQL InnoDB storage engine because it's still storing data from deleted tables. Is it possible to do that? Does he have to create a new database every single time? Thank you.

    ITKE413,315 pointsBadges:
  • Is a MySQL primary key indexed automatically?

    Hello experts, Would anyone know if a primary key is automatically indexed in MySQL? Do I actually have to create the index? Also - would this be possible in InnoDB too? Thanks!

    ITKE413,315 pointsBadges:
  • 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!

    ITKE413,315 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.

    ITKE413,315 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.

    ITKE413,315 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.

    ITKE413,315 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...

    ITKE413,315 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.

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

Following