24unix wrote: ↑Mon 21. Oct 2024, 14:23 What do you mean by logs?

General logs ar under /var/log/mysql.
I you need more specific, like query logs, you must first enable them.

I have looked under /var/log/ and there is no MySQL anywhere. That is what I mean by logs.

I have a pro license (if it matters) how do I look at the mysql log?

Painfully, lol. It's like this on both big boxes. I did turn it off and got relief right away as you can see. https://dl.dropboxusercontent.com/scl/fi/ug3k9udtt8vw6u4w0f7kq/msedge_mCGiyBuOq0.png?rlkey=c27b6bg3wns7q4s48hgusvbjl&dl=0 How do we summon those nice graphs? I believe that comes with a pro ...

Is there an easy way just to turn rspam off? No there is not an "easy" way. You would have to modify configuration files. It's killing my boxes. How? Painfully, lol. It's like this on both big boxes. I did turn it off and got relief right away as you can see. https://dl.dropboxusercontent.com/scl ...

Is there an easy way just to turn rspam off? It's killing my boxes. Running Debian 12 BTW.

I will send you my invoice in a few days :D You can select IP's that you want to use in the config-screen, but you can not assign an ip to a domein, you have to do that in your DNS. But why do you want this? 1 IP can handle as many domains as you like, the server will know what is what. There is NO ...

You need the rootpassword of the database, should be stored in a file in the /root directory if I'm not mistaken. During install it was given to you, and stored in the file if you didn't delete it. Thanks, I have gotten though most of it and server response time are half of what they were, HUGE ...

Is there a way to upload a list of bulk clients and their domains and set the template for?

BasHeijermans wrote: ↑Sun 18. Aug 2024, 13:48 Or use a tool to help you configure:

https://github.com/major/MySQLTuner-perl

It will tell you what you need to do, after that it's just adjusting to what 'feels' good

NIce, thank you! I assume we are meeting the MySQL password somewhere we can read from?

Change the settings in for /etc/mysql/mariadb.conf.d/90-tuning.cnf Especially the key_buffer_size is important, when it's too small it won't buffer and read everything from the harddisk and thus slows down to a crawl. Typical these are set for small databases, not for big ones. Plenty websites to ...

Looks to me you need to increase the database buffers to keep up with the tasks. If the buffers are too little the database will give problems. Or the number of connections is too low. Then it's not down, it's just the database is busy and as such it takes too long to respond. You may want to tune ...

Thanks a ton!

Is there a way to change the client who owns a domain? I need to transfer three domains =, each with a separate owner, to one new user, or "client".

Thanks

Alexander wrote: ↑Mon 12. Aug 2024, 09:55 Hello,

this is not possible using the user interface. It is possible using the API.

What do you want to change? You may also be able to use the database directly - but this depends on what you want to change.

I need to change a number of the PHP settings

We made a template and have a number of users assigned to that template. Then we found we needed to make a change to the template. Is there a way to push those changes to all existing users? I thought I saw this, but I can't find it now.

Thanks