How to tell when mysql databases were last used or updated
Linux - NewbieThis Linux forum is for members that are new to Linux.
Just starting out and have a question?
If it is not in the man pages or the how-to's this is the place!
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Introduction to Linux - A Hands on Guide
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter.
For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
Click Here to receive this Complete Guide absolutely free.
I think I'm going to try turning off this server, see if anything breaks. I have one final question though. You said "the master will continue to log replication regardless". But what happens if none of the slaves are running to read that logged info, will those files just build up on the master, or is there some sort of auto purge setup (or that you can setup) on those files that I should check to avoid my server running out of space?
You said "the master will continue to log replication regardless". But what happens if none of the slaves are running to read that logged info, will those files just build up on the master, or is there some sort of auto purge setup (or that you can setup) on those files that I should check to avoid my server running out of space?
The server will indeed keep building those files up, they aren't flushed when the slaves read them either, they keep building up and building up.
Yeah, this server does host a database we do use, but only like once a month really, so maybe that explains the small number of those files. and since they're so small, maybe i'm worrying over nothing.
I have the server from my original post turned off since it doesn't seem like much was going on there anyway, and this "real" server doesn't seem like it'll fill up with those replication files anytime soon, so unless someone screams that something isn't working, I think I'm in good shape. would you agree?
Oh yeah, gotta love that old trick haha I hope it works out too :-)
I just shutdown -h the slave/server I hope we don't need anymore. Luckily I know it starts up fine, so I'm just going to let it sit there for a long time before we actually get rid of it. call me paranoid.
I never used clonezilla before. Would that let me image it and load it up on my laptop in VirtualBox or something like that?
clonezilla will create a set of files that are exact images of the disk partitions. In the past I've created a Citrix XenServer virtual machine from clonezilla images, I'm sure using VirtualBox is an option too.
ok, I might have to check that out. it'd be pretty cool if I could run the server from my machine if I needed to. I did make a tgz of the /var/lib/MySQL directory before I turned it off. not sure why, but sounded like a good idea.