Re: UBUNTU 16.04 MySQL performance
Re: UBUNTU 16.04 MySQL performance
- Subject: Re: UBUNTU 16.04 MySQL performance
- From: Samuel Pelletier <email@hidden>
- Date: Tue, 13 Mar 2018 09:24:58 -0400
Hi Stavros,
I would not expect MySQL to be slower on any Linux, usually, it is the reverse
situation.
Very long query like this one is probably very io intensive, even 3 second is
quite long for a query (except for large data set reporting). So I suggest you
look at these:
- The cpu and io during the fetch. If CPU is low, you are waiting for io. If
your mac is running a PCI Express SSD, it is probably way faster than the AWS
storage.
- Your MySQL server setting for memory caches may differ.
- Last and not least, check if your server process is not using more memory
than your physical (vm allocation). This would generate memory swapping, thus
using io...
Unless you are fetching a very large number of rows, I would optimize this
query.
EOF does not play well with long queries.
Regards,
Samuel
> Le 13 mars 2018 à 09:07, Stavros Panidis <email@hidden> a écrit :
>
> Hi all,
>
> Recently I tested an app in an AWS Lightsail instance UBUNTU 16.04 server
> running MySQL 5.7.
>
> I realised extremely slow performance running queries, comparing to the same
> exactly database running on a Mac OS X High Sierra. For example a query that
> is performed within 3 seconds on MAC takes around 3.5 minutes to complete in
> UBUNTU.
>
> Database is SNOMED CT (a large medical terms database downloaded from UMLS).
> MySQL version, database structure and indexes are identical in both servers.
>
> I understand that has nothing to do with WebObjects but does anyone had a
> similar experience with MySQL in ubuntu?
>
> Many thanks in advance
>
> Stavros Panidis
> email@hidden <mailto:email@hidden>
>
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden