Set slow query time per user and I'd 3 (adm)

[Biglebowski]

Thanks Bogdan

I think you're referring to the default system-wide slow timeout.
I'm interested in changing it for just one particular...

[Biglebowski]

Hi,

Is it possible to reduce the default slow query time from 30s to less for a particular user?
Presumably, if it is,...

[Biglebowski]

Thanks Bogdan, very useful.

Any thoughts on the other part of my question please?

eg if Ive got a server with 100GB ram and...

[Biglebowski]

Hi,

Is there an easy way if getting this other than lvectl list-user | awk etc ?

Apparently 20% - 30% of physical should be...

[Biglebowski]

Bogdan, is your test server a server or vm?

I'm using vms. The results are unreliable as presumably this kernel option is managed by the...

[Biglebowski]

Hi Bogdan, thanks, I'll check the link.

Could you or anyone recommend a method other than httpd restart to clear these events please?...

[Biglebowski]

OK, the reason this read test us ineffective is because the kernel is I/O caching reads. If I set vm_drop_caches=3 with sysctl then this reduces the read...

[Biglebowski]

I've got an account with IO limit set to 1024.

During write tests with dd, I get throughput of up to 1.3MB/s.
With read tests the figures...

[Biglebowski]

Hi,

I've got quite a few accounts with a few GB PMEM and unlimited process and IO.
These are Wordpress accounts.
I'm finding...