help with optimal configuration for blobs
Hello, I need some advice for setting up a mysql database (debian etch) to store many blobs (about 1 GB) . I run a HP DL 360 (?), 1 GB RAM, RAID 5, 10K disks, 30 GB and the standard installation of mysql coming with debian etch (5.0.32, readline 5.2) I need only one database (innodb) with 1 table and two fields. id integer db_data longblob Normally the standard my.cnf coming with etch is good for me - but now I think I need to tune my configuration. Could someone advice me? Thanx. -- Jochen Kaechelin gissmoh.de, figgfrosch.de, ror-ror.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Optimal configuration on slow/old machines
Hello! I run a picture-database (http://gissmoh.kicks-ass.net) on Ubuntu Breezy on an old machine: processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 7 model name : Pentium III (Katmai) stepping: 3 cpu MHz : 501.226 cache size : 512 KB fdiv_bug: no hlt_bug : no f00f_bug: no coma_bug: no fpu : yes fpu_exception : yes cpuid level : 2 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 sep mtrr pge mca cmov pat pse36 mmx fxsr sse bogomips: 993.28 mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i486) key_buffer = 16M max_allowed_packet = 16M thread_stack= 128K query_cache_limit = 1048576 query_cache_size= 16777216 query_cache_type= 1 # log-bin = /var/log/mysql/mysql-bin.log # max_binlog_size = 104857600 # binlog-do-db = include_database_name # binlog-ignore-db = include_database_name skip-bdb [mysqldump] quick quote-names max_allowed_packet = 16M [isamchk] key_buffer = 16M Is there a way to optimize MySQL Performance? There a not many clients connected at the same time. Thanx -- Jochen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimal configuration on slow/old machines
Am Dienstag, 15. November 2005 13:29 schrieb Jochen Kächelin: Ups!! Wrong link! The right one: http://gissmoh.kicks-ass.net:81 -- Jochen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimal configuration on slow/old machines
Jochen Kächelin [EMAIL PROTECTED] wrote on 11/15/2005 07:46:13 AM: Am Dienstag, 15. November 2005 13:29 schrieb Jochen Kächelin: Ups!! Wrong link! The right one: http://gissmoh.kicks-ass.net:81 -- Jochen Hardware recommendations: Add as much RAM as possible and if you can, swap out your hard drives with something faster. SQL performance recommendations: http://dev.mysql.com/doc/refman/4.1/en/optimization.html (read the whole chapter) That should get you started. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Optimal configuration
Hi. I have a server running mysql.From it reads data two web server wich has about 30.000 daily visits and 250.000 pages so the trafic to the mysql server is big. Can anybody tell me a optimal mysql configuration for this server?. Actually in the /etc/my.cnf i have: set-variable = max_connections=500 set-variable = wait_timeout=1000 set-variable = key_buffer=64M set-variable = table_cache=256 The server has 650M of ram and two HD of 17 GB. Thanks. PD:Excuse me for my poor english. ;) Jess Gmez Pastor [EMAIL PROTECTED] Equipo de Desarrollo Autocity Networks www.autocity.com wap.autocity.com
