3
votes
2answers
182 views

What's the optimal server configuration for fastest inserting in a MySql database in this scenario? [closed]

I have a MyISAM table partitioned by range with 90 partitions representing the last 90 days. I expect this table to receive somewhere between 500 million to 1 billion records before i start rotating ...
0
votes
1answer
79 views

MySQL Partition / Very High Volume of Records

I'm looking for some advice on how to setup my MYSQL instance. I have a table that maintains log entries and I'm getting about 10-11 million entries per month. I feel like this is far too many ...
1
vote
2answers
259 views

Remounting MySQL under a new mount point

/var/lib/mysql is mounted on partition / which is now full. Is there a way to mount this under /home/mysql for more disk space?
2
votes
1answer
293 views

Partitioning and configuring a RAID array for a dedicated MySQL server

I'll be running ubuntu server on a 3 disks server (450 GB each) and 16 GBs of RAM. My target at the moment isn't configuting MySQL itself, but what could be the best RAID configuration for my case ...
0
votes
1answer
78 views

How to set backup / database in order to maintain heavy write loads

I have a write heavy application. Approx 5lac+ inserts per day in a MySQL table. I have master <> master -> slave. Performance is not an issue here. I need your inputs with regards to management ...
1
vote
1answer
262 views

How many partitions should we create if there are around 100 millions rows

I have a 16 core , 12 GB ram, a SSD 500 MB/s I have 1 millions rows in my "Pages" table The pages contains 1 unique key that are HostID ( int ) and Page( varchar ) I use partitioning by key and ...
0
votes
1answer
102 views

MyISAM Partition empty table load problem

> Create Table: CREATE TABLE `trb3` ( `id` int(11) default NULL, `name` varchar(50) default NULL, `purchased` date default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PARTITION BY RANGE ...
1
vote
2answers
5k views

How can I put mysql databases in different disk partitions (linux - Ubuntu)? [duplicate]

Possible Duplicate: multiple file systems for mysql hi, How can I put mysql databases in different partition (linux - Ubuntu)? Thanks, yosef
2
votes
1answer
585 views

How to move MySQL partitions from one machine to another?

I have a MySQL table: CREATE TABLE tweets ( tweet_id INT NOT NULL AUTO_INCREMENT, author_id INT NOT NULL, text CHAR(140) NOT NULL, PRIMARY KEY (tweet_id) ) ENGINE=InnoDB PARTITION BY HASH(tweet_id) ...
2
votes
1answer
387 views

How to scale out by elvolving from database partitions to sharding?

Say I have a MySQL table: CREATE TABLE tweets ( tweet_id INT NOT NULL AUTO_INCREMENT, author_id INT NOT NULL, text CHAR(140) NOT NULL, PRIMARY KEY (tweet_id) ) PARTITION BY HASH(tweet_id) PARTITIONS ...
0
votes
3answers
204 views

Splitting a MySQL DB in two may ease server from “Too many connetions”? I don't think so

I was requested to split a MySQL in two, it's kind of a horizontal partition, in which some rows correspond to one site, and some other correspond to another site. But they want to split it in two DBs ...