Dear community,
my sql and apache server (with CMW installed) hangs due to /tmp full:
This happens because I have a very large database and CMS create a TMP sql files like:
This is absolutely normal and the tmp tables will speedup the sql queries.
The problem is when the /tmp becomes full, the mysql server hangs because it can't write file anymore. Now, is there a way to avoid /tmp to becomes full?
Or at least make mysql server to write tmp file to other place?
good morning
The /tmp filesystem is full at 99 %
I have do a "rm" but the size is the same.
so i think that a process is always alive, but how can i do to know it ? (because I have deleted some file in /tmp)
thank you (9 Replies)
Can you help. My server sunning solaris 9 on x86 platform pretty much hung for a few hours... I could not use telnet or ssh to the box - it kept refusing connection. A few hours later - I was able to log in again.
The server has not rebooted but here are the first errors in the messages log... (5 Replies)
The /tmp is 100% full, I found there are the following big files/directory:
1301500 syslog.out.58
166692 vac
158552 install.dir.2928686
158552 install.dir.2236636
110980 install.dir.2887698
/tmp/vac have some files like :
.toc ... (3 Replies)
Hi,
I would like to know if /tmp file system is full, wheather it will affect the peformance of application installed on AIX. if Memory and CPU are not heavily utilized.
Regards,
Manoj. (1 Reply)
Dear All,
We are on AIX OS, /tmp directory is filled up to 99% percent,
Please suggest, How to get free space for "/tmp"?
which files can be deleted from /tmp? and How to delete it? is there any commands.....
Thanks in advance,
Its very urgent, Helpful answers will be appreciated,
Please... (7 Replies)
Hello all,
The issue is
# df -h /tmp
Filesystem size used avail capacity Mounted on
swap 4.0G 4.0G 8.7M 100% /tmp
# du -sh /tmp/
87M /tmp
By now you probably will say that this is open file destriptor issue.
Well no, nothing... (2 Replies)
I have a Sun-Fire-V210, the Server hangs for sometime and evn console wont be abled to access and after sometime the server comes back active. the messages file shows this , whats causing this ?
# tail -500 messages
Jan 25 07:02:16 xxxxxxxxxxxxx Corrupt label; wrong magic number
Jan 25... (2 Replies)
Hello,
AIX 6.1 TL7 SP6
POwerHA 6.1 SP10
I was experimenting with new hacmp build. It's 3-node cluster build on AIX 6.1 lpars. It contains Ethernet and diskhb networks. Shared vg disk is SAN disk. Two nodes see disk using vscsi, third node sees disk using npiv. Application is db2 server.
... (4 Replies)
Hi everybody,
few days ago we had a big issue with one of our solaris10 server.
Suddenly while my colleague was working on it for some troubleshooting he realized that the performance started to degrade.
At the end it reached the point that was not even possible to login usng the local console... (7 Replies)
Discussion started by: bdegiovanni
7 Replies
LEARN ABOUT LINUX
mysql_config
MYSQL_CONFIG(1) MySQL Database System MYSQL_CONFIG(1)NAME
mysql_config - display options for compiling clients
SYNOPSIS
mysql_config options
DESCRIPTION
mysql_config provides you with useful information for compiling your MySQL client and connecting it to MySQL. It is a shell script, so it
is available only on Unix and Unix-like systems.
mysql_config supports the following options.
o --cflags
Compiler flags to find include files and critical compiler flags and defines used when compiling the libmysqlclient library. The
options returned are tied to the specific compiler that was used when the library was created and might clash with the settings for
your own compiler. Use --include for more portable options that contain only include paths.
o --include
Compiler options to find MySQL include files.
o --libmysqld-libs, --embedded
Libraries and options required to link with the MySQL embedded server.
o --libs
Libraries and options required to link with the MySQL client library.
o --libs_r
Libraries and options required to link with the thread-safe MySQL client library. In MySQL 5.5, all client libraries are thread-safe,
so this option need not be used. The --libs option can be used in all cases.
o --plugindir
The default plugin directory path name, defined when configuring MySQL.
o --port
The default TCP/IP port number, defined when configuring MySQL.
o --socket
The default Unix socket file, defined when configuring MySQL.
o --version
Version number for the MySQL distribution.
If you invoke mysql_config with no options, it displays a list of all options that it supports, and their values:
shell> mysql_config
Usage: /usr/local/mysql/bin/mysql_config [options]
Options:
--cflags [-I/usr/local/mysql/include/mysql -mcpu=pentiumpro]
--include [-I/usr/local/mysql/include/mysql]
--libs [-L/usr/local/mysql/lib/mysql -lmysqlclient
-lpthread -lm -lrt -lssl -lcrypto -ldl]
--libs_r [-L/usr/local/mysql/lib/mysql -lmysqlclient_r
-lpthread -lm -lrt -lssl -lcrypto -ldl]
--socket [/tmp/mysql.sock]
--port [3306]
--version [5.5.31]
--libmysqld-libs [-L/usr/local/mysql/lib/mysql -lmysqld
-lpthread -lm -lrt -lssl -lcrypto -ldl -lcrypt]
You can use mysql_config within a command line using backticks to include the output that it produces for a particular option. For example,
to compile and link a MySQL client program, use mysql_config as follows:
shell> gcc -c `mysql_config --cflags` progname.c
shell> gcc -o progname progname.o `mysql_config --libs`
COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 MYSQL_CONFIG(1)