12-04-2013
Honestly I don't know how much space MySQL need for temp tables. It may depends on how many users are connected to the blog.
BTW, now I put offline the site, so users can't connect, and now it works. So, the tmp issue is resolved, but seems I have other issues because if I open the blog and the users connect to it, MySQL hangs again.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I am running AIX 3 4.
When I do a df I get:
Filesystem 512-blocks Free %Used Iused %Iused Mounted on
/dev/hd4 32768 10232 69% 1309 16% /
/dev/hd2 917504 86360 91% 19744 18% /usr
/dev/hd9var 131072 67712 49% 617 ... (11 Replies)
Discussion started by: szodiac
11 Replies
2. AIX
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)
Discussion started by: pascalbout
9 Replies
3. Solaris
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)
Discussion started by: frustrated1
5 Replies
4. AIX
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)
Discussion started by: rainbow_bean
3 Replies
5. AIX
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)
Discussion started by: manoj.solaris
1 Replies
6. AIX
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)
Discussion started by: kak
7 Replies
7. Solaris
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)
Discussion started by: click
2 Replies
8. Solaris
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)
Discussion started by: Sojourner
2 Replies
9. AIX
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)
Discussion started by: vilius
4 Replies
10. Solaris
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 MOJAVE
dbix::class::storage::dbi::mysql5.18
DBIx::Class::Storage::DBI::mysql(3) User Contributed Perl Documentation DBIx::Class::Storage::DBI::mysql(3)
NAME
DBIx::Class::Storage::DBI::mysql - Storage::DBI class implementing MySQL specifics
SYNOPSIS
Storage::DBI autodetects the underlying MySQL database, and re-blesses the $storage object into this class.
my $schema = MyApp::Schema->connect( $dsn, $user, $pass, { on_connect_call => 'set_strict_mode' } );
DESCRIPTION
This class implements MySQL specific bits of DBIx::Class::Storage::DBI, like AutoIncrement column support and savepoints. Also it augments
the SQL maker to support the MySQL-specific "STRAIGHT_JOIN" join type, which you can use by specifying "join_type => 'straight'" in the
relationship attributes
It also provides a one-stop on-connect macro "set_strict_mode" which sets session variables such that MySQL behaves more predictably as far
as the SQL standard is concerned.
STORAGE OPTIONS
set_strict_mode
Enables session-wide strict options upon connecting. Equivalent to:
->connect ( ... , {
on_connect_do => [
q|SET SQL_MODE = CONCAT('ANSI,TRADITIONAL,ONLY_FULL_GROUP_BY,', @@sql_mode)|,
q|SET SQL_AUTO_IS_NULL = 0|,
]
});
AUTHORS
See "CONTRIBUTORS" in DBIx::Class
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.18.2 2014-01-22 DBIx::Class::Storage::DBI::mysql(3)