[Halld-online] MySQL out of control on gluon01

[Elliott Wolin]

Dear Hovanes and DAve,

As I wrote in my previous email, the database hung when the partition 
filled up last week.  I copied the db to a larger partition and 
recovered everything late on Fri.  The files on the small partition will 
become redundant once Dave Butler confirms that the archiving is working 
properly again.  I saw him this morning and asked him to verify.  Once 
he does I'll delete the old files.

Dave...as you can see, verifying the all archive databases are working 
is somewhat high priority...please check this out as soon as you can.

Thanks,



On 05/28/2013 01:11 PM, Hovanes Egiyan wrote:
> Hi,
>
> there might be a problem with the way MySQL is setup on gluon01.
> It uses almost all of the hard drive that was allocated for the system.
>
> gluon01:pxiApp>  sudo du -h /var/lib/mysql-old_22-may-2013
> [sudo] password for hovanes:
> 984K    /var/lib/mysql-old_22-may-2013/mysql
> 364G    /var/lib/mysql-old_22-may-2013/Solenoid_100ms
> 85G     /var/lib/mysql-old_22-may-2013/Solenoid_OnChange
> 41G     /var/lib/mysql-old_22-may-2013/Solenoid_1s
> 489G    /var/lib/mysql-old_22-may-2013
>
> Currently  there is no room left on the gluon01 system partition and this
> machine is used for solenoid controls. Please move these files from the
> system disks to some other location by 2pm. Otherwise, I will have to
> remove
> these files.
>
> Thanks,
>       Hovanes.
> _______________________________________________
> Halld-online mailing list
> Halld-online at jlab.org
> https://mailman.jlab.org/mailman/listinfo/halld-online

-- 

				Sincerely,
					Elliott


================================================================================


  Those raised in a morally relative or neutral environment will hold
		    no truths to be self-evident.
				

Elliott Wolin
Staff Physicist, Jefferson Lab
12000 Jefferson Ave
Suite 8 MS 12A1
Newport News, VA 23606
757-269-7365

================================================================================