MYSQL Server running slowly

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

EirikCh
Posts: 2
Joined: Thu Jan 05, 2017 8:49 pm

MYSQL Server running slowly

Post by EirikCh » Thu Jan 05, 2017 9:43 pm

Hi!

I've managed to get PATSTAT 2016a up and running on a MYSQL Server using Ubuntu 16.04 LTS. The problem is that whenever I run a query, only 1 CPU core is utilized per process, which makes me have to take a 10 min coffee break.

1) Is there any way of utilizing all CPU cores when using MYSQL from terminal?
2) Does any other SQL Server provider like MS SQL, PostGRESQL, Oracle support multicore processing?

Best regards,
Eirik Christensen
Norwegian Industrial Property Office


Post Reply