There are almost more or less 277 mysql server system variables . In these variables some of the variables are dynamic and few are not.
I don't under stand what is the reason behind read only variables . why few of mysql system variables are read only. what will happen if they make those variable dynamic.
Is there any deep reason for the read only variables?
For now we can consider :
and there are many other variable we can find at http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html
Of course, I know we can't change variable like
version. But many other variables like
log-bin are not dynamic. For me, it does not make sense if
log_slow_queries are dynamic. Why is log-bin not dynamic? like wise there are many other variables.