How to improve ?

28 views
Skip to first unread message

ccll ddd

unread,
Oct 12, 2023, 11:02:47 PM10/12/23
to MaxScale
I have a select SQL use 19s in mysql.
It spend 48s when use maxscale .
How to improve  this problem? or maxscale can set sql bypass?

Markus Mäkelä

unread,
Oct 13, 2023, 1:28:10 AM10/13/23
to maxs...@googlegroups.com

Hi,

If the query takes 19 seconds via the client while connecting directly to the database and 48 seconds when going through MaxScale, I'd first measure how much network lag there is and whether there's a network bandwidth bottleneck somewhere. I'd also monitor the CPU usage of MaxScale while this query is being processed by MaxScale.

You should also turn on info level logging by adding log_info=true under the [maxscale] section. This will cause a lot of log message to be logged and the info level logging should not be left on permanently as it'll end up filling the disk up pretty quickly. In the info log messages, you'll see the routing information that MaxScale sends. If you want higher precision timestamps in the log messages, you can add ms_timestamp=true under the [maxscale] section. This will include milliseconds in the log messages.

Markus

--
You received this message because you are subscribed to the Google Groups "MaxScale" group.
To unsubscribe from this group and stop receiving emails from it, send an email to maxscale+u...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/maxscale/33b6506f-87f8-4be6-91ca-8c369d885565n%40googlegroups.com.
-- 
Markus Mäkelä, Senior Software Engineer
MariaDB Corporation

ccll ddd

unread,
Nov 10, 2023, 3:57:11 AM11/10/23
to MaxScale
can I use regex filter to route this sql to master?
Reply all
Reply to author
Forward
0 new messages