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!
Notices
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.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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.
When I look in /var/lib/mysql though, I only see 20some mysql-bin.###### files, and they're all at least 1MB, of which 9 are from this year. Should I even worry about it?
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.
Have you looked at the server logs? They seem to record when there has been a connection to the database, as well as replication logs, and it even appears to have statement logs of user activity.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.