Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: drywalldude on March 19, 2005, 12:38:46 PM

Title: Need some help with template ??
Post by: drywalldude on March 19, 2005, 12:38:46 PM

I would like to modify the my.cnf to include the "buffer" and "cache" statements. Here are the specifics
http://forums.cacti.net/about4826.html
This will probably answer some templating questions and get a few more graphs working on my sme box
http://ericswww.com/cacti/graph_view.php?action=preview?action=tree&tree_id=1&leaf_id=7&select_first=true
The mysql query cache graph on this page does not work and I think it has to do with this, Thanks  8-)

Title: Need some help with template ??
Post by: Normando on March 19, 2005, 02:44:45 PM

Hello.
I use the following statments in files at /etc/e-smith/custom-templates/etc/my.cnf
File named 005mysqld:

Code: [Select]


[mysqld]
set-variable = thread_stack=256k
set-variable = query_cache_limit=50M
set-variable = query_cache_size=50M
set-variable = query_cache_type=1
set-variable = key_buffer= 128M

File named 009innodb

Code: [Select]


#skip-innodb

and file named 010oldpasswords

Code: [Select]


old-passwords

Ofcourse, first you need to copy the above files from directory /etc/e-smith/templates/etc/my.cnf to the NEW above location
Then,
/sbin/e-smith/expand-template /etc/my.cnf
Then
service mysqld restart

Title: Tahnks for the speedy reply!!
Post by: drywalldude on March 19, 2005, 04:23:21 PM

I forgot to mention and I am assuming that this is good for ver4 and above :hammer:

Title: Need some help with template ??
Post by: Normando on March 19, 2005, 06:12:42 PM

yes, ofcourse, because only ver. 4.x and above support querycache.

Title: Tryed this but didn't seem to work??
Post by: drywalldude on March 20, 2005, 02:27:20 PM

This is the valuable lesson on templating sme thats a good thing.

I made a my.cnf in /etc/e-smith/custom-templates/ then copied the files and edited w/pico. But the changes are not reflected in the /etc/my.cnf files after I "/sbin/e-smith/expand-template /etc/my.cnf" and then
"service mysqld restart" hmmm
should the dir have been created here???
/etc/e-smith/custom-templates/etc/my.cnf ???

forgive me if the answer to this question is obvious

and what is the 010oldpasswords about it is not one of the original templates???
Tkanks  :lol:

Title: Need some help with template ??
Post by: Normando on March 20, 2005, 05:22:56 PM

Yes, you are right, sorry for the mistake. I fixed now.
New template directory is /etc/e-smith/custom-template/etc/my.cnf
About 010oldpassword is only used if you have MySQL ver. 4.1.x and above. Not for ver. 4.0.x
If you have 4.0.x not use the file 010.
Remember. All your modifications put into custom-templates. If you need to modified some files into /templates/ directory, first copy them to the same leve under /custom-templates/ for varius reasons described here:
http://no.longer.valid/phpwiki/index.php/Customizing
PicsOne

Title: mysql query cache not enabled by default
Post by: drywalldude on March 21, 2005, 01:10:16 PM

Thanks PicsOne, my query cache is now set to 64m and it   appears operational here: http://ericswww.com/cacti/graph.php?rra_id=all&local_graph_id=13
Great Stuff!!!! :-D

The query cache is not being used a lot on my low traffic site, but I would think this would enhance preformance on larger servers that run CMS pages that are data-base driven. I wonder how many users upgrading from ver 3x to 4x even know about this new feature?? Does this need to be added as a howto??