LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 02-07-2019, 09:41 PM   #1
dunrix
LQ Newbie
 
Registered: Feb 2019
Posts: 1

Rep: Reputation: Disabled
Mariadb/MySQL - extremely slow performance in Slackware64-current


Hi,

just curious if anybody else finds mariadb 10.3.12 in Slackware64-current performing very poorly ?

Some time ago I've upgraded from Slackware64 14.1 to Current and found out at one untouched Django project, its database initialisation (~200 tables creation etc) feels much slower then before - like from 10 seconds to 4 minutes. Very intensive disk access during that operation, but caching is enabled and only besides default server settings is use of utf8 encoding (collation-server = utf8mb4_unicode_ci, init-connect='SET NAMES utf8mb4' and character-set-server = utf8mb4).

I did also tested database initialisation for quite other application (Rails, diffrent db driver) and it also performed very poorly.

Is that some known issue or experience of some another Slackware user ?

Last edited by dunrix; 02-08-2019 at 01:54 AM.
 
Old 02-08-2019, 04:42 AM   #2
Labinnah
Member
 
Registered: May 2014
Location: Łódź, Poland
Distribution: Slackware-current
Posts: 36

Rep: Reputation: 7
Between 14.1 and current are quite big change in mariadb versions. If you use your custom my.cnf, there is probability that is is no longer optimal for newer one. If you use default config, the default options may be totally different, and in effect also performance.

So make sure your configuration is proper for newer mariadb.
 
Old 02-09-2019, 05:36 AM   #3
rogan
Member
 
Registered: Aug 2004
Distribution: Slackware
Posts: 121

Rep: Reputation: 35
dunrix: this might be related: https://bugzilla.kernel.org/show_bug.cgi?id=202441
It looks like the commits causing that issue are going to be reverted: https://lkml.org/lkml/2019/2/8/1017
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: How To Use Mytop To Monitor MySQL/MariaDB Performance In Linux LXer Syndicated Linux News 0 07-31-2017 01:33 PM
Format Ext HD into Ext3 format only (not Ext 3/4) John Glasgow Fedora 8 01-02-2012 09:56 AM
upgrading slackware64 13.1 multilib to slackware64 -current multilib Cultist Slackware 4 03-12-2011 10:04 AM
Updating from Slackware64-current to Slackware64 13. glore2002 Slackware 4 08-28-2009 07:50 PM
Filesystems: ext 2, ext 3, reiserfs. Which one? r3dhatter Linux - Newbie 12 07-15-2004 01:53 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 02:52 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration