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 <stavros.pani...@gmail.com> 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
> stavros.pani...@gmail.com <mailto:stavros.pani...@gmail.com>
> 
> 
> 
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/samuel%40samkar.com
> 
> This email sent to sam...@samkar.com

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to arch...@mail-archive.com

Reply via email to