Tagged Questions
0
votes
0answers
34 views
How much RAM for a large database on a dedicated MySQL InnoDB server?
Hereunder my hardware config:
CPU: 1x Intel Xeon X3470 Quad core @ 2.93GHz
RAM: 4x 8GB DDR3
Disks: 2 x SATA 320GB for the system & 4 x SAS 300GB for the DB
I've upgraded from 12Gb to 32Gb and ...
1
vote
1answer
214 views
MySQL Tables crashing randomly
This is one of the many random Tables that get corrupted. Any ideas why and what would be causing this?
How do I keep MySQL tables from crashing and MySQL from crashing?
Repairing USR_wp537
...
0
votes
0answers
155 views
Error connecting to DB
In regards to:
http://serverfault.com/questions/442218/remounting-mysql-under-a-new-mount-point
Everything is running. MySQL started but for websites they can not connect to the mysql database at ...
6
votes
4answers
3k views
Why using innodb_file_per_table?
There are many articles exaggerating (IMHO of course) the need for innodb_file_per_table. I understand that with innodb_file_per_table, there should be a better control over the individual tables; ...
