Shulou(Shulou.com)06/01 Report--

This article is to share with you what you should pay attention to when using Linux mysql dump database. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

First, make sure that the directory where the Linux mysql dump is stored exists and that the process has write permission to the directory. The directory where the Linux mysql dump is stored is the current directory of the process, which is usually the directory where the process was started when the command was issued. However, if you start through a script, the script may modify the current directory, and the real current directory of the process will be different from the directory in which the script was executed. At this point, you can look at the target of the "/ proc//cwd" symbolic link to determine the real current directory address of the process. Processes started by system services can also be viewed in this way.

Second, if the program calls seteuid () / setegid () to change the valid users or groups of processes, the system will not generate coredump for these processes by default. Many services call seteuid (), such as mysql, and no matter what user you use to run mysqld_safe to start mysql,mysqld, the valid user is always the msyql user. If you run a program as user A, but the user of the program you see in ps is B, then these processes are calling seteuid. In order for these processes to generate coredump, you need to change the contents of the / proc/sys/fs/suid_dumpable file to 1 (the default is generally 0)

Third, this is generally known, is to set a large enough core file size limit. The size of the core file generated when the program crashes is the amount of memory consumed when the program is running. However, the behavior of a program when it crashes can not be estimated according to its normal behavior, such as buffer overflow and other errors may cause the stack to be destroyed, so it is common for the value of a variable to be modified into a mess. then the program uses this size to request memory, which may cause the program to take up more memory than usual. Therefore, no matter how little memory is used when the program is running normally, it is better to make sure that the core file is generated and the size limit is set to unlimited.

Thank you for reading! This is the end of this article on "what are the precautions for the use of Linux mysql dump database". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.