Monitor MySQL database restore progress with pv Rumi, January 12, 2013 The pv command is one that I really enjoy using but it's also one that I often forget about. You can't get a much more concise definition of what pv does than this one: pv allows a user to see the progress of data through a pipeline, by giving information such as time elapsed, percentage completed (with progress bar), current throughput rate, total data transferred, and ETA. The usage certainly isn't complicated: To use it, insert it in a pipeline between two processes, with the appropriate options. Its standard input will be passed through to its standard output and progress will be shown on standard error. A great application of pv is when you're restoring large amounts of data into MySQL, especially if you're restoring data under duress due to an accidentally-dropped table or database. (Who hasn't been there before?) The standard way of restoring data is something we're all familiar with: # mysql my_database < database_backup.sql The downside of this method is that you have no idea how quickly your restore is working or when it might be done. You could always open another terminal to monitor the tables and databases as they're created, but that can be hard to follow. Toss in pv and that problem is solved: # pv database_backup.sql | mysql my_database 96.8MB 0:00:17 [5.51MB/s] [==> ] 11% ETA 0:02:10 When it comes to MySQL, your restore rate is going to be different based on some different factors, so the ETA might not be entirely accurate. Src: http://rackerhacker.com/2010/11/24/monitor-mysql-restore-progress-with-pv/ Related Administrations Configurations (Linux) MySQLPVTool
Set Up a Radius Server on pfSense November 2, 2022November 5, 2022 Installing the Package The pfSense 2.X package manager includes both FreeRadius and FreeRadius2 as installation options. For this example, I’m going to be using FreeRadius2 since it has some additional features not found in the previous version. Only one version of radius can be installed on pfSense at a time…. Read More
Use Putty as SOCKS proxy October 28, 2023 I’ll need 2 programs to achieve this, assuming you already have access to a Linux box and you can connect using putty client. Need S/w packages are- Putty and SeaMonkey Browser Follow the following steps- Run Putty Goto SSH > Tunnels and configure as required Turn Tick ON- Local port… Read More
mod_jk for RHEL6 April 20, 2012 If you have a RHEL6 box which ships both Apache and Tomcat6 you might want to connect the two together. You probably have looked around for mod_jk as a RHEL6 RPM or SRPM (src.rpm). You find that It isn't in EPEL, and it isn't in Red Hat Optional Server… Read More