MySQL tmpdir Parameter Modification
Today, I suddenly received an alert message saying that/the disk space usage exceeds the threshold. It was found that there were many abnormal SQL statements that could not be executed, resulting in continuous processing, resulting in temporary use of/tmp disk space.
Because the/tmp space of the operating system is limited, You need to modify the parameter and modify the value path of
In this article, we will share with you how to modify the tmpdir parameter in MySQL in linux to solve the problem of tmpdir errors. if you have the same requirements, you can refer to the next alarm message that you suddenly receive today, yes/the disk space usage exceeds the threshold. It was found that there were many abnormal SQL statements that could not be executed, resulting in continuous processing,
Today suddenly received an alarm message saying yes/disk space used over the threshold. After viewing, found that there are a lot of abnormal SQL, can not be executed, resulting in processing, resulting in a temporary consumption of/TMP disk space.
Due to the limited/TMP space of the operating system, parameter modification is required to modify the Tmpdir value path.
Mysql> Show variables like ' tmpdir
[anyone]) permission to rwxr-xr-x, where r = read, w = write, x = execute.
Dir.mkdir( "mynewdir", 755 )
Delete directory
Dir. delete can be used to delete directories. Dir. unlink and Dir. rmdir perform the same functions, which provides us with convenience.
Dir.delete("testdir")
Create File temporary directory
Temporary files are information that is simply created during program execution but not permanently stored.
Dir. tmpdir provides the path to
. unlink and Dir. rmdir perform the same functions and provide convenience.
Dir. delete ("testdir ")
Create files and temporary directories:
Temporary files are temporary files that may be generated during program execution, but are not permanently stored.
Dir. tmpdir provides the path to the temporary directory of the current system, although this method is unavailable by default. 'Tmpdir' is required for
1. Why Ruby?
Why do many Java developers focus on Ruby? Ruby is a general-purpose scripting language created in Japan 10 years ago. It is a pure object-oriented language. Unlike Java, everything in ruby is an object. Ruby syntax mainly comes from smalltalk, Python and Ada.
Keywords: Ruby on Rails, instantrails, windows, getting started, tutorial
I always wanted to try Ruby on Rails, but I was not familiar with Apache and MySQL, and I was not confident in setting up the rails environment. So I never started. After learning about instantrails, finally, we set up the Ruby on Rails Development Environment on Windows and started learni
Demonstrate Ruby's six characteristics that are easy to be misunderstood with actual code. The Code demonstrates ruby misunderstanding.
Introduction: if you are a C ++ developer, you need to use Ruby to quickly execute some prototype designs. When you pick up a Ruby reference book (such as Pickaxe) or browse a Ruby web
Share with us today the basic Ruby Tutorial (http://www.maiziedu.com/course/ruby-px/), which focuses on Ruby Source and Ruby features, here's a look at Ruby 's introduction:Ruby is a purely object-oriented programming language. It was created in 1993 year by as of Japan (まつ
Use Ruby to process text tutorials, and use ruby to process text tutorials
Similar to Perl and Python, Ruby has excellent functions and is a powerful text processing language. This article briefly introduces Ruby's text data processing function and how to use Ruby to effectively process text data in different formats,
Example of an interactive program developed by ruby: ruby Development
Implement the interaction function in a terminal similar to pry, ronin, and msf. ripl gem is mainly used here:
1. Call defined methods, such as help2. Be able to execute system commands3. ruby parsing similar to irb/pry
Installation:
gem install riplgem install ripl-shell_commands
Example
Ripl,
How to learn Ruby? What do you need to know before you learn Ruby? This is a lot of people want to learn the voice of Ruby friends, I do not give a specific answer, the following to tell you about a predecessor learning Ruby (http://www.maiziedu.com/course/ruby/) learning pr
Gems use proxies in two ways:
Mode one:
>>set http_proxy=http://ip_or_host:port
>>gem Install The_package_name
Mode two:
>>gem list-p Http://user:passwd@ip_or_host:8080-r
Install Ruby-debug-base19There are 2 different ways:Method One:download the. gem file first, then install the. gem file directly, which requires compilation, so you need to take the With-ruby-in
Add fire to Ruby: Ruby will become popular again
Ruby, which is widely regarded as a web language, has always been very popular, but it will become more popular now. AltRubies pushed Ruby to a level we never imagined. Is Ruby the preferred choice for browsers, mobile apps,
temporary directory of the current system, although the method is not available by default. In order to make dir.tmpdir necessary to use the need for ' tmpdir '.
You can use Dir.tmpdir and file.join to create a platform-independent temporary file:
Require ' tmpdir '
tempfilename = File.join (Dir.tmpdir, "Tingtong")
tempfile = File.new (TempFileName, "w")
Tempfile.puts "This is a temporary fi
Annotations, variable declarations, Array Operations, and Ruby variables in the ruby tutorial
I read an article "PHP basic tutorial" on "blog Park" two days ago and introduced PHP. D guago also wrote a "Ruby getting started tutorial" when learning Ruby ". It should be noted that this article is suitable for beginners w
To install Ruby, go to the ruby official website to download the Windows Installation Package of ruby1.56. After installing Ruby, open the DOS window and enter ruby-V to display it.
Ruby 1.8.6 (patchlevel 0) [i386-mswin32] indicates that
Tutorial on system management by writing scripts in Ruby, and ruby System Management
Introduction
Ruby is an extremely rich, free, simple, scalable, portable, and object-oriented scripting language. Recently, it is widely used in the Web field. To a certain extent, this is attributed to the very powerful Web application development framework Rails, Which is exact
Concurrent concurrency and global lock details in ruby, and ruby parallel global explanation
Preface
This article mainly introduces you to ruby concurrency and global locks. We will share the content for your reference and learning. I will not talk much about it below. Let's take a look at the details.
Concurrency and Parallelism
During development, we often come
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.