MySQL and HIPAA Compliance?

[ghuntress]

Hi,

I'm taking a database class and we are given open ended discussion questions 
each week.  The question this week is:

Will MySQL take away market share from popular DBMSs? Will your comments 
change if you are told that MySQL is not HIPPAA compliant?

I have been using MySQL for well over 3 years, and other databases for well 
over 10 years (professionally, as a coderbout time I took a class eh?) and 
I do think I have an informed opinion for the first part.

I'm weak in the area of HIPAA compliance though.  I know it basically centers 
around privacy.  I know it covers things like adequate logging, encrypted 
connections, etc, but it also seems to include a lot of EDI interoperability.  
Now that seems to be something that should be handled at an application level 
and MySQL shouldn't be penalized because of this.   From the searching I have 
done, it appears that MSSQL for example offers this mandatory feature via their 
Biztalk server (to handle all the EDI)

There are all manner of sites that will discuss HIPAA compliance for a fee.  Is 
anyone here familiar with this that could provide a reference or a simple 
summary.  It seems an interesting and important topic that I thought the list 
might be interested.

Regards,

Gary Huntress

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Troubleshooting - Can't connect and won't shut down

[ghuntress]

I have been running a server for almost 2 years 
completely without incident.  I have made no significant 
changes recently, but for the past month or so I have 
been having connection problems.  Users cannot connect, 
but existing connections seem to be maintained. 

Here are some symptoms:

I cannot stop the server using mysqladmin.  It hangs 
(I've let it run for an hour) and cannot be interrupted 
with ctrl-c.

The error log shows too many open files

ps aux | grep mysql  shows a constantly increasing 
number of mysql processes:

mysqluser 11894  0.0  7.5 34692 9692 pts/1S
11:21   0:00 
/usr/local/mysql/

There are 600 of them right now :(

I'm at a loss as to how to effectively troubleshoot 
this.  Does anyone have any suggestions?
The version is 3.23.37 running on RedHat



Regards,

Gary H.


-
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