Server hanging once a week (Solaris 8)

2004-12-08 Thread Paul Smith
Hi all; I have a Mysql 3.2.58 server running on Solaris 8 (the latest 3.2 version downloaded from Mysql.com). The system is a Ultra-250 server with multiple CPUs and 2G RAM. There are many databases but they're not large and the load on the system is not high at all. We're using this older

Re: Server hanging once a week (Solaris 8)

2004-12-08 Thread Paul Smith
%% Gleb Paharenko [EMAIL PROTECTED] writes: gp Very often similar symptoms causes various lock problems. Do you gp use InnoDB? Try log_slow_queries to find hung queries. I'm using MyISAM tables. When I wrote this application InnoDB wasn't even an option :-). I don't think it's hung

Re: Server hanging once a week (Solaris 8)

2004-12-08 Thread Paul Smith
%% Victor Pendleton [EMAIL PROTECTED] writes: vp When the database is in a `hung` state, is the file system where vp the MYI, MYD and frm files accessible? Definitely. I can log in, see the files, run the mysqladmin commands, etc. The databases live on the local disk, not a remote server

Re: Server hanging once a week (Solaris 8)

2004-12-08 Thread Paul Smith
%% Victor Pendleton [EMAIL PROTECTED] writes: vp What state are the queries in while they are hung? What command or vp SQL are they executing? Unfortunately I lost the output of the processlist command. Whenever the server hangs it's always a crazy race to get it back up again. Next time

Re: MySQL on Linux

2004-04-09 Thread Paul Smith
%% Dan Nelson [EMAIL PROTECTED] writes: dn That is because although Linux binaries can access files over 2gb, dn they do not do so by default. Apache was probably not compiled dn with the required defines (-D_LARGEFILE_SOURCE dn -D_FILE_OFFSET_BITS=64), so that's why it stops at 2gb even

Licensing--web site is schizophrenic

2002-07-07 Thread Paul Smith
At one place on the MySQL site I see: http://www.mysql.com/support/arrangements.html which says the client library is under the LGPL. At another place I see: http://www.mysql.com/doc/C/o/Copyright.html which says the entire codebase, including the client, is released under the GPL. Does

Re: Debian and MySQL

2002-01-08 Thread Paul Smith
%% John Cichy [EMAIL PROTECTED] writes: jc I'm doing some experimenting with debian, has anybody created any .deb jc packages for MySQL? Go to http://www.debian.org, on the left menu bar pick Debian Packages, then in the search box enter mysql (make sure the distribution is set correctly

Re: New fork of MySQL

2001-11-09 Thread Paul Smith
%% Shankar Unni [EMAIL PROTECTED] writes: su Who can answer these questions? Well, the obvious place to look is the MySQL web site, http://www.mysql.com Click Products, then click MySQL Licensing Policy. -- ---

Re: New fork of MySQL

2001-11-08 Thread Paul Smith
%% DownloadFAST.com [EMAIL PROTECTED] writes: dc I have not read the MySQL license in detail. MySQL is under the straight GPL. -- --- Paul D. Smith [EMAIL PROTECTED] HASMAT--HA Software Mthds Tools Please remain