← Back to team overview

maria-discuss team mailing list archive

Re: Poor performance compared to MySQL

 

The 3 files should be enough. Let's include all 3.

You can upload them on the FTP server here if you don't want to share them publicly otherwise.

https://mariadb.com/kb/en/meta/mariadb-ftp-server/ <https://mariadb.com/kb/en/meta/mariadb-ftp-server/#mariadb-foundationdeveloper-ftp-server>

I'll have a look and see if I can reproduce it. Best if you provide the relevant config files too.

Vicențiu


On 02.06.2020 18:30, Ling, Andy wrote:

Additionally, if you can share the data in any way so I can try to reproduce the problem that may help speed things up.

I would have thought the data in just the two tables involved could be shared if that would be helpful. I need to check with others, but would the FRM, MYD & MYI files be enough? It amounts to about 2GB for the 6 files uncompressed. If I miss out the MYI files and let you regenerate the indexes it drops to 1.22 GB.

Regards

Andy Ling

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DISCLAIMER:
Privileged and/or Confidential information may be contained in this message. If you are not the addressee of this message, you may not copy, use or deliver this message to anyone. In such event, you should destroy the message and kindly notify the sender by reply e-mail. It is understood that opinions or conclusions that do not relate to the official business of the company are neither given nor endorsed by the company. Thank You.

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Follow ups

References