MySQL Forums
Forum List  »  General

poor data upload speed in MySQL 5.6
Posted by: Sam Mathews
Date: June 05, 2017 03:10AM

We are using MySQL community edition currently and Innodb engine is being used for the database. we have above 100 GBs of data that we upload as '.sql script' in our MySQL database on daily basis,
but the speed is too slow to upload all data: we suffer from regular data loss. and since we already have huge data, moving to other database is not a prefered option for us until we find something to overcome for sure.

1> should we consider using Enterprise edition instead, to overcome the situation. if yes, what speed can we expect to upload 100 GB of data using .sql script.

2> or, should we consider other input format instead of .sql.

3> Do we have to change something at database level like choosing other storage engine or any specific changes in configuration file.

server configuration
CPU xeon e5 2697A dual socket
RAM 1.5 TB total 64 GB x24 DDR4 2133Mhz
HDD 8 HDD 8TB each 12 Gbps NLSas 7.2 RPM
OS Centos 7 64 bit

Options: ReplyQuote

Written By
poor data upload speed in MySQL 5.6
June 05, 2017 03:10AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.