Any recommendations when using MySQL ? It is extremely slow out of the box

kaymankayman Member Posts: 662 Unicorn
edited November 2018 in Help

I installed a clean Ubuntu, running only MySQL, Rapidminer desktop and RapidMiner Server on a development laptop with 8GB of memory and a i7-4500U CPU. Not a real beast but still ok for development purposes. All of the software has been installed using default settings. 

 

The server just reacts horrible, adding limited fresh content to server is pretty ok, but deleting content or copying content from the desktop is close to impossible. It just takes ages to copy data, while the data itself is far from huge. The dataset I am playing with is contained in approx 50 directories, each of them contains maximum 300 repositories, and the examplesets by repository vary between 2 to 2000. So all in all nothing that should be a big deal I assume?

 

Deleting them in small groups (like 10 at a time) takes me around 1 to 2 minutes per batch, so in order to delete them all I expect to need a few days. This does not seem right to me. Doing the same in the desktop mirror takes just the blink of an eye so the difference is huge.


Are there any shortcomings when using MySQL, do I need to modify some basic settings to get some acceptabel behaviour ?

 

(Disclaimer : I'm fairly new to Ubuntu and MySQL, a test setup using Windows and SQL Server works as expected)

Tagged:

Answers

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn

    After the terms changed for using MySQL drivers, I switched to using PostgreSQL. I like that one one better.  Maybe someone else can chime in here. 

  • SGolbertSGolbert RapidMiner Certified Analyst, Member Posts: 344 Unicorn

    You can also use the MariaDB connector that comes with RapidMiner Studio. It works just fine with MySQL and it may perform better.

  • JEdwardJEdward RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 578 Unicorn

    I found this blog that gives some guidance for tuning MySQL.  https://www.percona.com/blog/2016/10/12/mysql-5-7-performance-tuning-immediately-after-installation/

     

    I also use PostgreSQL mostly, but on a new install it also needs performance tuning to get it running optimally. 

     

     

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,497 RM Data Scientist

    John,

     

    any best pratices for Postgres you would like to share?

     

    ~Martin

    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.