Tagged Questions

-1
votes
0answers
18 views

Accessing a NAS using MySQL/Etc [closed]

Probably an easy question, but I want to make a webapp to sort of View/Sort/Etc... Movies/Music/Files on a NAS (It's a Synology Station on a Home Network). There shouldn't be any reason a database ran ...
0
votes
1answer
154 views

consequences of using “innodb_flush_method = O_DIRECT” without having a battery backed write cache? or on a KVM guest?

Mysql 5.5.29 Innodb- 128GB Ram - 32 cores - Raid 10 SSD. Our server which is a dedicated KVM guest on a 'baremetal' is hosting our heavy read-write DB server. Everything is file-per-table. ...
1
vote
1answer
630 views

Optimizing MySQL for Read-Only?

We have 14 GB worth of CSV's which total 138 million rows. I imported this into a MySQL table first with InnoDB, and then tried again with MyISAM. In both cases, a simple SELECT on primary key ...
4
votes
2answers
435 views

Should we need to use Barriers on a production database (MySQL/InnoDB)?

Even though we are using a journaling filesystem (EXT3) with barrier enabled, is this still safer and recommended? e.g mount -o barrier=1 /dev/sda /mntpnt Reference: ...
2
votes
2answers
105 views

Is this Dedicated Server good enough to Run MySQL on Linux Ubuntu?

I have a web application that runs simple logic. Most of the SQL procedures that I have only do simple selects, some simple join table and some simple inserts. I want to get a dedicated server for My ...