Hello Graham, Tuesday, October 15, 2002, 12:03:34 PM, you wrote:
>> 1. replace Red Hat's rpms with MySQL binary release, download it from >> http://www.mysql.com/ >> 2. run myisamchk on all files. >> 3. run MySQL and enjoy the reliability since then :-) GM> Why do Linux distributions ship broken MySQL packages? The newly GM> released SuSE 8.1 shows similar problems, connecting from the local GM> system works fine but the server crashes (and is restarted by GM> safe_mysqld) as soon as a remote user attempts to connect. As has GM> already been noted, after installing the "official" MySQL RPMs GM> everything works. This is a common problem with non-MySQL builds. Why? First, because compiling MySQL is a very careful job to do, you don't have to miss a single point in instructions. Say, compiling with wrong options will give you a binary that will not be able to resolve hostnames, load data more than 2gb, work with more than a couple of hundreds of connections and so on. Second, because the only stable GNU C compiler today is gcc 2.95. It's true that MySQL cannot be compiled correctly with gcc 2.96 and 3.xx. Third, because making a correct glibc binary is very, very hard goal to accomplish. Not to speak about other binaries, but, say, MySQL works with threads, and the thread stack in glibc should be around 256k for MySQL can handle hundreds of connections. In other case, MySQL will just crash after Nth connection. By default, the stack is 2mb in glibc. This is causing crashes, too. There are a lot of many other reasons. That's (in short) why MySQL official binaries are compiled statically and works well. -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php