Topic: Mysql Table Cache Settings

[linuxhelp]

Hello @ ALL

does anyone found some useful mysql-settings for my.cnf to hold 5 small-mysql-databases
at 1GB Ram?
############
set-variable=max_connections=1000
key_buffer=128M
table_cache=256M
sort_buffer=15M
############
that's ok for a 2GB Engine? all databases are not more than 5MB
Thanks for Help
Tom

[cactus]

Hello @ ALL

does anyone found some useful mysql-settings for my.cnf to hold 5 small-mysql-databases
at 1GB Ram?
############
set-variable=max_connections=1000
key_buffer=128M
table_cache=256M
sort_buffer=15M
############
that's ok for a 2GB Engine? all databases are not more than 5MB
Thanks for Help
Tom

I am wondering what you need to tweak for five small databases, AFAIK SME Server can serve them without problems. For optimizing MySQL there is not a general recipe, and lots of bigger more demanding databases are served using MySQL.

The total content on the disk does not really reflect the size it will take up in memory as indexes etc. also take up space.

One of the main important things of optimizing databases is designing your tables right and setting the proper indexes with the proper size to speed up searching when querying the database. Also designing queries with some care to properly use the indexes would make a huge difference.

Did you already read the manual for MySQL? Are the databases your own design or are they part of a software package.

Your best bet is to get the required settings and information on a more specific mysql forum such as newsgroups, comp.databases.mysql is a good one. Once you have the required settings we can help you set them up the SME Server way in the configuration files as they are generated using templates and internal database settings.

Another question: Do you really need 1000 simultaneous connections? Perhaps you can elaborate a little bit more on the situations you will be using your database.

If you really need the 1000 connections you are way better of getting a dedicated MySQL server and someone who knows how to do this to optimize your MySQL database server instead of SME Server.

If you want to know all the configuration parameters your MySQL server is currently using you can use this command:

Code: [Select]

mysqladmin variables

[linuxhelp]

Hello Cactus,

sorry for my "little" crazy question.

The running Server is a "embedded" System with a Onboard Cyrix 585x-CPU and 2GB ddr2-RAM,Raid1 2.5",(23Watts/hours+Solarpowered daily)
Last time i was on a Business-Hewlett-Packard HP-UX Training and there was a discussion
about holding Databases at RAM. At this time i tried to find some informations at mysql forums
about settings for low-power entry Servers and if the can hold the databases inside RAM like a
Ramdrive (Gigabyte -I-Ram).
After this i posted the settings i found on net for a "small" Server with P3 500Mhz and 256MB RAM.
I hope you understand me right?
Iam not a MYSQL-Guru iam only a german called "sneaker-admin" who read and tries his best.
I lost my Job 12 years ago and IT-Hobby grows to my new job at these 12years.

To my used sites i use Wordpress..not perfect but it can be edit from every place..
Thanks and nice day to you..

[cactus]

The running Server is a "embedded" System with a Onboard Cyrix 585x-CPU and 2GB ddr2-RAM,Raid1 2.5",(23Watts/hours+Solarpowered daily)

And it is running SME Server? If not we should move this topic to General Discussions IMHO.

Last time i was on a Business-Hewlett-Packard HP-UX Training and there was a discussion
about holding Databases at RAM. At this time i tried to find some informations at mysql forums
about settings for low-power entry Servers and if the can hold the databases inside RAM like a
Ramdrive (Gigabyte -I-Ram).
After this i posted the settings i found on net for a "small" Server with P3 500Mhz and 256MB RAM.
I hope you understand me right?

I do, still there is not much performance gain for small databases like yours IMHO. I think you should read up on RAM stored databases in regards to their volume and rate of use.

Here is some discussion on it:
http://www.webmasterworld.com/databases_sql_mysql/3825740.htm
http://lists.mysql.com/mysql/147849

Iam not a MYSQL-Guru iam only a german called "sneaker-admin" who read and tries his best.
I lost my Job 12 years ago and IT-Hobby grows to my new job at these 12years.

Nor am I, I sparked interest in computers long ago and taught myself some...

To my used sites i use Wordpress..not perfect but it can be edit from every place..
Thanks and nice day to you..

Knowing a little on wordpress I do not even expect any gain from a memory stored database as there is a large overhead of the wordpress application itself. The gain of speed you win in the database most likely will not be noticeable I think.

[linuxhelp]

Hello Cactus,

yes its running stable since 2007/12


my target was to find a fanless, energysaving system. Later i added a 12V Motorbikebattery with a used Solarpanel as USV to hold up my Router and Server at live if we have a break at Housepower.

i must agree that wordpress is a little bit to fat for my use and there a some "cache-plugins" available to set wordpress as "custom-static-page"

if i found a used i-ram-pci board i will try to set it as hdd-drive for sme..