1
vote
2answers
451 views

MySQL Table not repairing

Table info: Database name: user_motiva Table name: wp_options.frm wp_options.MYD wp_options.MYI wp_options.TMD when I do a mysqlcheck -r --all-databases it gets hung on that table even if you ...
1
vote
1answer
227 views

What conditions trigger a table level lock

Working on some vBulletin performance issues, I ran into this situation, where everything is stuck waiting on a table-level lock: Id Command Time State Info 83 Query 47 ...
2
votes
4answers
730 views

Linux filesystem suggestion for MySQL with a 100% SELECT workload

I have a MySQL database that contains millions of rows per table and there are 9 tables in total. The database is fully populated, and all I am doing is reads i.e., there are no INSERTs or UPDATEs. ...
1
vote
4answers
1k views

Which operating systems are used by large social networking companies?

I often see that Apache is used as a web server and also ruby on rails, php and so on is used. So all in all the most large social network companies using unix operating systems. Because I want to ...