Database keep-alive/timeout problem
Posted by: ohm-ish (---.u.parknet.dk)
Date: July 21, 2018 02:37PM

Hi

I think this is a database setting problem:

I'm using MariaDB

If I don't browse my local website for some seconds/minutes, the next first pageload is always very slow.
After that, every load is normal fast, until next pause (I'm working on something in editor).

Is this some kind of database timeout/keep-alive I can adjust?

Thank you



Edited 2 time(s). Last edit at 07/21/2018 03:14PM by ohm-ish.

Options: ReplyQuote
Re: Database keep-alive/timeout problem
Posted by: RiggsFolly (Moderator)
Date: July 21, 2018 04:20PM

Hi,

This is more likely to be a mariaDB specific question. We do not support Apache/MySQL/mariaDB/PHP, so not really a question for us.

My guess, from the information you give us is:

mariaDB automatically caches results for a short time. It sounds like this is what you are noticing.
My gut feeling is that if you mess with this it will just cause you other issues somewhere else, but I would start looking at the mariaDB documentation to see if my guess is anywhere near the mark.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.3 32bit & 64bit)
<Apache 2.4.29/2.2.31> <PHP 7.2/7.1/7.0/5.6/5.5/5.4> <MySQL 5.7.19/5.6.39/5.5.28>
<MariaDB 10.2.14> <phpMyAdmin4.8.1> <MySQL Workbench 6.3.10>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Database keep-alive/timeout problem
Posted by: ohm-ish (---.u.parknet.dk)
Date: July 21, 2018 06:33PM

Ok thanks.

After a lot of search and testing, it seems to be because of Malwarebytes..

The problem is gone when I disable Malwarebytes completely.
Got to test it more and find out what excactly to exclude from scan/protection



Edited 4 time(s). Last edit at 07/21/2018 06:45PM by ohm-ish.

Options: ReplyQuote


Sorry, only registered users may post in this forum.