Reply to thread

Message

<blockquote data-quote="BSF" data-source="post: 1495008" data-attributes="member: 13098">Morrus,Are you using a basic install of MySQL and/or the underlying OS?&nbsp; There might be some performance optimizations that can be achieved by compiling MySQL and statically linking libraries on the server.&nbsp; There might also be some server parameters that can be tweaked to utilize memory, etc.On the OS side, especially if you are using a linux flavor, there might be some kernel tuning that you can implement.&nbsp; Modules that are unnecessary, services that can be shutdown, tweaks geared toward server performance as opposed to desktop performance, etc.&nbsp; Hmm, what about any tweaks with the web server software, or with PHP?&nbsp; You indicate that bandwidth isn't really the problem, which isn't a surprise since you have done a lot the past year or so to reduce bandwidth consumption.&nbsp; Have you been able to ascertain that the problem is with database performance as opposed to server performance? And Morrus is correct, all the changes I have suggested are non-trivial.&nbsp; Many of the suggested changes are not, necessarily, straightforward to implement.&nbsp; Any changes should be carefully evaluated because they do bring forward an element of risk.&nbsp; With some of these ideas, it might be better to analyse the condition on the current server and look for optimizations that can be implemented when the server is upgraded or replaced.&nbsp; Yes, I know that sounds a little harsh, especially when there are features right now that people are missing.&nbsp; But, I am just thinking from the standpoint of how difficult some of these are to implement on a production system where you do not have a regular maintenance window to test things.&nbsp; I'm sure none of us wants Morrus to schedule regular downtime.&nbsp; As for Petz, I trust that Morrus has looked at it and is reasonably sure there won't be a huge impact on the site.&nbsp; I would check it out myself, except I spend enough time on EN World goofing off.&nbsp; <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile&nbsp; &nbsp; :)"&nbsp; data-smilie="1"data-shortname=":)" />&nbsp; (In other words, maybe later)Morrus, server tuning for databases is not my strongest point.&nbsp; But, I have done server tuning on a couple of OS's.&nbsp; If there is anything that you think I can help you with, please feel free to email me.</blockquote>

[QUOTE="BSF, post: 1495008, member: 13098"] Morrus, Are you using a basic install of MySQL and/or the underlying OS? There might be some performance optimizations that can be achieved by compiling MySQL and statically linking libraries on the server. There might also be some server parameters that can be tweaked to utilize memory, etc. On the OS side, especially if you are using a linux flavor, there might be some kernel tuning that you can implement. Modules that are unnecessary, services that can be shutdown, tweaks geared toward server performance as opposed to desktop performance, etc. Hmm, what about any tweaks with the web server software, or with PHP? You indicate that bandwidth isn't really the problem, which isn't a surprise since you have done a lot the past year or so to reduce bandwidth consumption. Have you been able to ascertain that the problem is with database performance as opposed to server performance? And Morrus is correct, all the changes I have suggested are non-trivial. Many of the suggested changes are not, necessarily, straightforward to implement. Any changes should be carefully evaluated because they do bring forward an element of risk. With some of these ideas, it might be better to analyse the condition on the current server and look for optimizations that can be implemented when the server is upgraded or replaced. Yes, I know that sounds a little harsh, especially when there are features right now that people are missing. But, I am just thinking from the standpoint of how difficult some of these are to implement on a production system where you do not have a regular maintenance window to test things. I'm sure none of us wants Morrus to schedule regular downtime. As for Petz, I trust that Morrus has looked at it and is reasonably sure there won't be a huge impact on the site. I would check it out myself, except I spend enough time on EN World goofing off. :) (In other words, maybe later) Morrus, server tuning for databases is not my strongest point. But, I have done server tuning on a couple of OS's. If there is anything that you think I can help you with, please feel free to email me. [/QUOTE]

Verification