Digital Marketing

Loading...

mylvmbackup - a utility for creating MySQL backups using LVM snapshots

-
mylvmbackup is a tool for quickly creating backups of MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations, while the actual file backup proceeds.

Popular posts from this blog

How to fix Google Apps Script: Script function not found: doGet

-
Every webapp in Google Apps Script must have a main function called doGet() which is the entry point of the app, the function that your app will start with when you type the webapp url. This is true for every application deployed as a standalone app and called by its url - with a user interface or not. If you read the documentation you'll see that all the standalone apps examples for HTMLService or UiApp have a doGet function. Only container embedded ui scripts or scripts that run on triggers are not concerned by this rule.
Read more

Creating sort index in MySQL

-
'Creating sort index' is the database figuring out the order of the returned values based on ‘order by’ clause. Main resources limit here would be available CPU and memory. The sort won't be done until the data is already all in memory if the result is small. Adding suitable index could make the query faster.
Read more

How to fix: df shows no file systems processed on Linux

-
If you run df command and get the following output: df: no file systems processed At the same time you have no problem with "du" or "ls" commands. One possible reason is that your disk run out of space. You need to delete some files to recover. You cannot fix it if it is caused by other reason. But this is the first thing you want to do when it happens. See also: Solution to Disk Full in production server Find and delete Files depends on modify days on Linux
Read more