> First, what version are you using? 4.0.20? 4.0.18 as provided by Suse with 9.1 Professional. 64 bit
4.0.20 64bit crashes 'out of the box' (segfault as I start it). I just filed a bug report for that > By key-cache, are you referring to the variable "key_buffer_size"? If > so, keep in mind that the key-buffer is for MyISAM, and only caches the > indexes. From, http://dev.mysql.com/doc/mysql/en/MyISAM_key_cache.html yes. I am refering to key_buffer_size. My tables are rather large. The data is log data (one table for each day) and the MYI files are of the order of 2-4 GByte for each day. The intend of setting key_buffer_size to 8 GByte was to keep 2-3 days worth of indexes buffered (the last 2-3 days, which are the most 'popular' for queries). > Your database would have to be huge to have 4 gig worth of indexes. What > if you try to scale it back to 2 gig (or less) and let it run for a few > days? currently trying that out. Its a bit hard to nail this down, as I am still setting things up and the load is low (compared to the production copy). Takes about 5 hrs or so right now for the DB to crash. I did see a bug report related to 'load table from master' with may apply, as I am using this command to populate the database while testing. > Does it generate a core file? There is a setting to specify the size of > a core file; not sure if it turns the generation of a core file on or > off (http://dev.mysql.com/doc/mysql/en/mysqld_safe.html and search for > "|--core-file-size=size"). Once you had the core file, you might want to > talk to the people on the development list, and see if one of them is > willing to take a look at it (assuming they can - might need a 64-bit > system to do so). No core file so far. But i managed to get a (very brief) erorr message. All it tells me is that is caught a 'signal 11'. No backtrace :-( > I know I haven't really answered your question; just listed what I would > look at. Thanks for trying ;-) -- ---------------------------------------------------------------- Johannes Ullrich [EMAIL PROTECTED] pgp key: http://johannes.homepc.org/PGPKEYS contact: http://johannes.homepc.org/contact.htm ---------------------------------------------------------------- There are two kinds of system administrators: The first kind solves problems with little shell scripts. The second kind are the problem. ---------------------------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
