Re: Choosing a "non-standard" database name?

That looks like a failed DNS lookup and/or failed IPv6 attempt?

Can you run the mysqladmin under strace on F32 to see what it's doing for
those 5 seconds?

-derek

On Wed, May 6, 2020 3:38 pm, jjs - mainphrame wrote:
> As a preliminary check, the fedora instance here is able to use a database
> called "maia1" (and by induction, any arbitrary name), with changes to the
> 3 config files - maia.conf, maiad.conf and config.php.
>
> One thing that I can't figure out, and maybe a fedora guru can shed
> some light, is that fedora is taking an extra 5 seconds to interact with
> the remote database server, and I'm not sure what system setting could be
> causing that.
>
> From Centos 8:
> $ time mysqladmin status -h dbserv -u test -ptest
> Uptime: 2257483  Threads: 7  Questions: 252508  Slow queries: 0  Opens: 99
>  Flush tables: 1  Open tables: 93  Queries per second avg: 1.11
>
> real 0m0.009s
> user 0m0.001s
> sys  0m0.006s
>
> From Fedora 32:
> $ time mysqladmin status -h dbserv -u test -ptest
> Uptime: 2257557  Threads: 7  Questions: 252511  Slow queries: 0  Opens: 99
>  Flush tables: 1  Open tables: 93  Queries per second avg: 1.11
>
> real 0m5.009s
> user 0m0.002s
> sys  0m0.003s
>
> Jake
>
> On Mon, May 4, 2020 at 6:45 PM jjs - mainphrame <[email protected]>
> wrote:
>
>> If you do dive in, be sure and start with the latest version of the
>> repo.
>> It's getting updates pretty much every day.
>>
>> Jake
>>
>> On Mon, May 4, 2020 at 8:38 AM Derek Atkins <[email protected]> wrote:
>>
>>> Indeed.  I'll see if I have time to look at it myself.
>>> I think there are a few more than 3 places, but hopefully less than 6.
>>> Certainly the get-info.sh needs to be updated, but so do the SQL
>>> scripts
>>> and scripts that generate the config files.
>>> Hopefully I can find the time.  WAY too much going on.
>>>
>>> -derek
>>>
>>> On Mon, May 4, 2020 11:32 am, jjs - mainphrame wrote:
>>> > Lots going on this week, so we'll see
>>> >
>>> > I'm hoping it's mostly in 3 config files, but a search will tell.
>>> >
>>> > Jake
>>> >
>>> >
>>> >
>>> > On Mon, May 4, 2020 at 7:53 AM Derek Atkins <[email protected]> wrote:
>>> >
>>> >> Of course, there are 2772 instances of the 4-tuple "maia" that I
>>> will
>>> >> need
>>> >> to check through to ensure I get all places!
>>> >>
>>> >> Fun.  (unless you volunteer to do this for me ;)
>>> >>
>>> >> -derek
>>> >>
>>> >> On Mon, May 4, 2020 10:45 am, jjs - mainphrame wrote:
>>> >> > That doesn't seem unreasonable.
>>> >> >
>>> >> > Jake
>>> >> >
>>> >> > On Mon, May 4, 2020 at 7:27 AM Derek Atkins <[email protected]>
>>> wrote:
>>> >> >
>>> >> >> Hi,
>>> >> >>
>>> >> >> jjs - mainphrame <[email protected]> writes:
>>> >> >>
>>> >> >> > You can send them by email here, or add it to the issue on the
>>> >> repo.
>>> >> >> >
>>> >> >> > Jake
>>> >> >>
>>> >> >> One thing I noticed is that there is a hard-coded dependency on
>>> the
>>> >> >> database *name* of "maia".  I was planning to install this
>>> along-side
>>> >> my
>>> >> >> older (1.0.2a) maia installation (same DB server, although
>>> different
>>> >> >> mail hosts).  I would rather be able to name the *new* database
>>> >> >> something other that "maia", rather than trying to rename the
>>> >> existing,
>>> >> >> live database.
>>> >> >>
>>> >> >> I suppose I could do the manual install, following the fedora
>>> model,
>>> >> but
>>> >> >> would you accept a PR that lets one choose the database name?  In
>>> my
>>> >> >> case, I want to set it to "maia1".
>>> >> >>
>>> >> >> -derek
>>> >> >>
>>> >> >> --
>>> >> >>        Derek Atkins                 617-623-3745
>>> >> >>        [email protected]             www.ihtfp.com
>>> >> >>        Computer and Internet Security Consultant
>>> >> >>
>>> >> >
>>> >>
>>> >>
>>> >> --
>>> >>        Derek Atkins                 617-623-3745
>>> >>        [email protected]             www.ihtfp.com
>>> >>        Computer and Internet Security Consultant
>>> >>
>>> >>
>>> >
>>>
>>>
>>> --
>>>        Derek Atkins                 617-623-3745
>>>        [email protected]             www.ihtfp.com
>>>        Computer and Internet Security Consultant
>>>
>>>
>


-- 
       Derek Atkins                 617-623-3745
       [email protected]             www.ihtfp.com
       Computer and Internet Security Consultant

_______________________________________________
Maia-users mailing list
[email protected]
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users