1
vote
0answers
64 views

mysql - measure amount of write

System : Centos 6.4, PerconaDb/MySQL 5.5.31 Im running relatively small mysql database with some 30 databases, total amount of 12Gb, but heavy on reads, updates and writes (texts, posts, user data ...
2
votes
1answer
572 views

Database (MySQL) and SSD lifetime - “lot” of writes to DB

In company where I work we started using SSD for our internal 3 GB MySQL database Difference in perfomance is HUGE, which is great. What I am worried about is lifetime of SSD Writes to DB are ...
-1
votes
1answer
53 views

Mounting ssd. Expectations vs reality about server load

I'v installed SSD on my server and moved tmp folder, mysql data folder and 2 most loaded websites(php) on it. I'v expected that server load will fall a little bit, but it seems that it is on the same ...
-1
votes
2answers
185 views

InnoDB on server with 2 SSDs [closed]

I have a server with 2 SSDs. I'm running a LAMP install and have an innoDB database on it. my questions are : 1) would innoDB automatically use both SSDs or would it only use one ? 2) would I incur ...
1
vote
2answers
156 views

SSD for database or webpage files? [closed]

I can have SSD for the mysql data files and system or the website files (.php files, images, video). I can not have both because of the SSD capacity I have. What would be best, to make Windows 2012 ...
0
votes
2answers
572 views

Why load increase ,ssd iops increase but cpu iowait decrease?

There is a strange thing on my server which has a mysql running on it. The QPS is more than 4000 but TPS is less than 20. The server load is more than 80 and cpu usr is more than 86% but iowait is ...
1
vote
0answers
113 views

Considering MySQL on SSD with NTFS and Windows 2008

My company is considering migrating our MySQL data from an HDD array to an SSD, possibly the Intel SSD 520 series. We have a fairly large set of databases, some with upwards of 100 million rows, so we ...
1
vote
2answers
1k views

MySQL moving ibdata & ib_logfile

I'm trying to move ibdata & ib_logfile on ssd drive. I tried this way, but it don't work: service mysql stop cd /var/lib/ cp -ra mysql mysql_backup cp -a mysql/ibdata1 mysql/ib_logfile* ...
1
vote
1answer
514 views

MySQL Cluster on SSD

We are planning to implement a four node MySQL Cluster and are considering using SSDs as the storage. We would like to get a high level of performance and very low latency on disk IO from the small ...
0
votes
2answers
277 views

Recommended filesystem, mysqltmp and filesystem related settings for a mysqld box running ssd + BIG ram + linux?

What is the recommended filesystem + mysqltmp location when dealing with a ssd based system that has some ram to spare? Currently we run our mysqltmp folder on a 4gb tmpfs partition. Works great. But ...
0
votes
3answers
771 views

SSD Performance for PHP?

My programmer just built an application with PHP using Doctrine ORM (will be a high traffic social networking website), and it's very heavy in PHP/Apache and CPU. The queries are wonderfully fast, and ...
3
votes
1answer
572 views

2x SSD's in RAID1 for MySQL server

I'm in need to upgrade my MySQL machine, as currently I am running 2x SATA 7200rpm drives in RAID0. This of course is quite dangerous incase one of the drives fails. As I do not need too much storage ...
4
votes
2answers
644 views

Does it makes sense to run “optimize table” when the mysql database is stored on SSD?

The manual says about "optimize table": "Deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. You can use OPTIMIZE TABLE to reclaim the ...
2
votes
1answer
829 views

Install MySQL on SSD, best mount options?

I want to install the mysql-server on my SSD, what are the best mount options for this? (/etc/fstab) What else I can do to increase the SSD Speed? My current configuration: /dev/sdc /ssd ext4 ...
5
votes
4answers
4k views

MySQL, disk I/O and SSD drives

We have a LAMP box with 2x mirrored 1 TB WD Black Caviar disks running the whole OS and MySQL. 8 GB / RAM, 2x quad core CPUs. We're really taxed on disk I/O, and I've been thinking of ...
2
votes
1answer
506 views

RAID of SATA SSDs or PCIe Flash?

As a reference: Crucial RealSSD C300 256GB drives. MySQL 5.1.5x running InnoDB tables. Linux (CentOS 5.5 etx3 journaled). Questions: Is it better to use a RAID of these so that drives can be ...
1
vote
1answer
193 views

MySQL installation question

I am far from a DBA and have a question. Recently I installed MySQL. On my machine C:\ is a 50GB partition of two mirrored 10k SAS drives. The remaining space on those drives is allocated to D:. I ...