Re: Server hanging once a week (Solaris 8)
%% 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 it happens I'll be sure to stow the list somewhere before restarting the server. However, IIRC there were a mix of queries: some were Wait, some were Sleep. -- --- Paul D. Smith <[EMAIL PROTECTED]> HASMAT--HA Software Mthds & Tools "Please remain calm...I may be mad, but I am a professional." --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server hanging once a week (Solaris 8)
%% 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 (I do backups every night to a remote server). Other operations and services on that server continue to work. Thanks for the response! -- --- Paul D. Smith <[EMAIL PROTECTED]> HASMAT--HA Software Mthds & Tools "Please remain calm...I may be mad, but I am a professional." --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server hanging once a week (Solaris 8)
%% 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 queries, because even new queries that I know are very fast fail. Heck, I can't even attach to the DB except through the admin interface (mysqladmin). Unless you're saying that the hung queries are using up the processes/threads in the DB so that new queries can't get through? Thanks for the response... -- --- Paul D. Smith <[EMAIL PROTECTED]> HASMAT--HA Software Mthds & Tools "Please remain calm...I may be mad, but I am a professional." --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Server hanging once a week (Solaris 8)
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 version because we developed the database with the 3.2.x release, years ago, and don't have the manpower to check to see if the newer version will work or fix issues we might run into--although we may have to find a way. This version worked without problems for over a year. But, for the last 4-6 weeks we've seen a problem once every 8-10 days where the server hangs and will not come back. Attempts to attach "normally" hang; current operations hang; etc. Using processlist shows some processes which have existed for a long time; that may or may not be correct, I'm not sure. Almost all our queries are coming in through the Perl DBI/DBD interface. When I try to use mysqladmin kill they don't die; they do go to a state of "killed" though. When I try to myqladmin flush-tables, that hangs. Flush-logs works but there is nothing interesting in the logs. When I try to run mysqld stop, the server process doesn't stop, although most of the hung requests When I run strace on the PID, I get this: lwp_sema_wait(0x1bfe50 then it hangs until I ^C. I have to kill -9 the server PID to bring it down. Then I check my tables but so far (cross fingers) they've all been fine except they are not shut properly, so I fix that with myisamchk. Since I have not changed anything I suspect that the IS folks have installed some new patch on the Solaris system which is causing this problem to appear, but I have no proof of that. Does anyone have any advice or information for me: places to look, things to do, etc. etc.? While so far we haven't lost any data this is a problem since it seems like it will continue to happen. -- --- Paul D. Smith <[EMAIL PROTECTED]> HASMAT--HA Software Mthds & Tools "Please remain calm...I may be mad, but I am a professional." --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Linux
%% 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 though dn> both the kernel and filesystem most likely do support larger dn> files. Just to point out this (needing extra compile flags to get large file support) is not unique to Linux. Most OSs require these kinds of flags; Solaris for example also requires special flags to get LFS. -- --- Paul D. Smith <[EMAIL PROTECTED]> HASMAT--HA Software Mthds & Tools "Please remain calm...I may be mad, but I am a professional." --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Licensing--web site is schizophrenic
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 this mean newer versions of MySQL client libraries are GPL'd? I'll be disappointed if this is true, because there are plenty of open source licenses which are incompatible with the GPL. This means that none of those other open source projects can use or include support for MySQL. Which is a shame. -- --- Paul D. Smith <[EMAIL PROTECTED]> HASMAT--HA Software Mthds & Tools "Please remain calm...I may be mad, but I am a professional." --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. - 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
Re: Debian and MySQL
%% 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 for whatever Debian distro you have installed). MySQL is free software, so it's eligible to be (and in fact is) included in Debian proper. You don't need any 3rd party .debs for it. HTH! -- --- Paul D. Smith <[EMAIL PROTECTED]> HASMAT--HA Software Mthds & Tools "Please remain calm...I may be mad, but I am a professional." --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. - 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
Re: New fork of MySQL
%% 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". -- --- Paul D. Smith <[EMAIL PROTECTED]> HASMAT--HA Software Mthds & Tools "Please remain calm...I may be mad, but I am a professional." --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. - 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
Re: New fork of MySQL
%% "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 calm...I may be mad, but I am a professional." --Mad Scientist --- These are my opinions---Nortel Networks takes no responsibility for them. - 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
