Linked Questions
23 questions linked to/from Is innodb_file_per_table advisable?
1
vote
1
answer
2k
views
Removing/overwriting sensitive data located in already deleted records in ibdata files
As far as I know, using InnoDB tables with innodb_file_per_table = off does not prevent deleted data from being visible in the ibdata1 file.
I know this is by-design, and that I could switch the ...
- 111
1
vote
1
answer
1k
views
replicate master/slave without disturbing master for dump
Is there a way to replicate master/slave without disturbing master for dump like mysqldump or cold copy of data files? I'm ok to bring down the instance only once for master to enable log-bin. But ...
- 1,479
2
votes
1
answer
452
views
Why was default of innodb_file_per_table changed?
Is there a disadvantage in using file per table storage? I wonder why the default of the value innodb_file_per_table was changed with MySQL 5.7.
Documentation shows that the default value changed (...
- 123
2
votes
1
answer
624
views
Drupal 7 Uses InnoDB, so do I need other configs?
If I'm optimizing a database that will be delivering multiple Drupal 7 websites, all using InnoDB, do I need to worry about [myisamchk] & [isamchk] sections, or can I just worry about the stuff ...
- 131
1
vote
1
answer
392
views
Server load discrepency in Slave with Master load being low and constant
We have MySQL Replication
Master/Slave Setup
db01 Master
db02 Slave (ReadOnly)
We are getting load discrepency on the Slave (db02), but the Master's (db01) server load is low. MySQL is the only ...
- 697
1
vote
1
answer
126
views
extra steps after changing storage engine and adding index
Someone told me to look into his website for quick optimization; I'm a programmer and i don't have much experience optimizing databases.
I have a php/MySQL site uses the MyISAM storage engine. It ...
- 145
1
vote
2
answers
161
views
What settings should I use in my.cnf
We have about 5-6 different internal webapps (staff use only) that we will be transferring across to a new virtual server, however I need to setup our my.cnf settings first and I am lost (I am web ...
- 13
2
votes
1
answer
74
views
Handling Recovery of Disk Space in MySQL and MongoDB
So I have worked with MySQL all my life (not as a DBAdmin, but a programmer), and I have some limited knowledge about maintaining MySQL databases.
Recently a portion of our database has been moved to ...
