Tagged Questions
MySQL : Open-Source, Relational Database Management System
39
votes
5answers
811 views
How can a group track database schema changes?
What version control methodologies help teams of people track database schema changes?
30
votes
7answers
3k views
What are the main differences between InnoDB and MyISAM?
What are the main differences between InnoDB and MyISAM?
28
votes
4answers
736 views
Storing vs calculating aggregate values
Are there any guidelines or rules of thumb to determine when to store aggregate values and when to calculate them on the fly?
For example, suppose I have widgets which users can rate (see schema ...
25
votes
7answers
4k views
How can I optimize a mysqldump of a large database?
I have a symfony application with an InnoDB database that is ~2GB with 57 tables. The majority of the size of the database resides in a single table (~1.2GB). I am currently using mysqldump to ...
19
votes
7answers
62 views
Is there a tool like Microsoft's “SQL Server Profiler” for MySQL?
While developing on MySQL I really miss being able to fire up a profiler. I find SQLyog is a good enough replacement for Query Analyzer but have not found a tool that works like SQL profiler.
For ...
18
votes
5answers
511 views
When is the right time to use MariaDB instead of MySQL, and Why?
What we earn and what we lost with this migration?
What should I expect as drawbacks after the migration?
Is it really unnecessary to change the applications in any situation?
17
votes
2answers
497 views
NULL or NOT NULL by default?
In MySQL, is it better to always allow nulls unless you know a field is required, or always use Not Null unless you know a field will contain nulls? Or doesn't it matter?
I know in some DBMSs they ...
15
votes
2answers
695 views
Character vs Integer primary keys
I'm designing a database with multiple lookup tables containing possible attributes of the main entities. I'm thinking of using a 4 or 5-character key to identify these lookup values rather than an ...
14
votes
8answers
131 views
Why should I create an ID column when I can use others as key fields? [closed]
Possible Duplicate:
Why use an int as a lookup table's primary key?
So far, I'm accustomed to creating an ID column for every table and it is practical in a way that it makes me not ...
14
votes
4answers
348 views
How do convert a 66,862,521 row table from MyISAM to InnoDB without going offline for several hours?
is it possible (and how) to convert a huge MyISAM table into InnoDB without taking the application offline. It requires to insert a couple of rows into that table every second but it is possible to ...
14
votes
9answers
2k views
How can I move a database from one server to another?
How can I move MySQL tables from one physical server to another?
Such as this exact scenario:
I have a MySQL server that uses innodb table and is about 20GB size.
I want to move it to a new server, ...
13
votes
1answer
170 views
Does anyone have a good recommendation for a book which teaches sharding?
Does anyone have a good recommendation for a book which teaches db sharding (from scratch at best)
I have read like 40 different websites talking about sharding.
I'm not saying online sites/blogs ...
13
votes
4answers
252 views
Is "CREATE INDEX` in MySQL a Linear Operation?
What I mean is the following:
If creating an index on a table with n rows takes t time. Will creating an index on the same table with 1000*ntake approximately 1000*t time.
What I'm trying to achieve ...
13
votes
5answers
616 views
Tool to generate large datasets of test data
Many times when trying to come up with an efficient database design the best course of action is to build two sample databases, fill them with data, and run some queries against them to see which one ...
13
votes
5answers
1k views
How do you tune MySQL for a heavy InnoDB workload?
Assuming a production OLTP system with predominantly InnoDB tables
What are the common symptoms of a mistuned/misconfigured system?
What configuration parameters do you most commonly change from ...
