looks like these mysql files are the biggest but Im not sure if its ok to reduce these or what. I know this server does alot of php database callups for the various websites we host.
Never worked with MySQL but Googling it shows that each of the MYD files corresponds to a table in the database...so removing them is not a good idea. Try allocating more space to /var and setup database archiving so that partition does not fillup so fast.
hi,
i'm writing a program that is running always...
but, i have a problem that memory is increasing..
i want to know whether does stack size inscease or not, when program is running..
i don't know what is the cause stack or heap...
i need some help.. :( (1 Reply)
how can i monitor usages of CPU, Memory, Hard disk etc. under SUN Solaries
through a c program or java program
i want to store that data into database so i can show it graphically
thanks in advance (2 Replies)
On Alpha True64 UNIX platform, we use "ps aux" command to display the process information, it also displays the %MEM,VSZ, RRS field. The question is that which field really indicates the program's memeory is increasing, thanks (0 Replies)
i need to increase the size of my /var filesystem but i have no idea how to do it.
Filesystem kbytes used avail capacity Mounted on
/dev/dsk/c0t3d0s0 144799 74952 55377 58% /
/dev/dsk/c0t3d0s6 342183 201079 106894 66% /usr
/proc ... (0 Replies)
how can I find cpu usage memory usage swap usage and
I want to know CPU usage above X% and contiue Y times and memory usage above X % and contiue Y times
my final destination is monitor process
logical volume usage above X % and number of Logical voluage above
can I not to... (3 Replies)
Hi,
I want to monitor the current cpu usage, monitor usage , disk I/o and network utlization for solaris using SNMP.
I want the oids for above tasks.
can you please tell me that
Thank you (2 Replies)
Hi all,
Can you please tell me the command, with which one can know the amount of space a specific directory has used.
df -k . ---> Displays, the amount of space allocated, and used for a directory.
du -k <dir name> - gives me the memory used of all the files inside <dir>
But i... (2 Replies)
Let's say i have 20 users logged on Server. How can I know how much memory percent used each of them is using with system time in each user? (2 Replies)
Hi
the version is RedHat 6.2 (Oracle DB server)
I don't know why swap memory usage keeps increasing...
I used to check swap memory usage Free -m and another way.
total used free shared buffers cached
Mem: 32183 31861 322 ... (3 Replies)
Discussion started by: tom8254
3 Replies
LEARN ABOUT OPENSOLARIS
mysql_zap
zap(1) MySQL database zap(1)NAME
zap - a perl script used to kill processes
USAGE
/usr/bin/mysql_zap [-signal] [-?Ift] pattern
SYNOPSIS
zap [-I|-?] [-f] [-t]
DESCRIPTION
zap supports by executing
-I|-? info
-f force
-t test
NOTE
If -f isn't given, ask user for confirmation for each process to kill. If signal isn't given, try first with signal 15 and after that with
signal 9. If -t is given the processes is only shown on stdout.
SEE ALSO isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
lege_tables(1), mysqlshow(1), perror(1), replace(1)
For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
at http://www.mysql.com/doc/en/
BUGS
Please refer to http://bugs.mysql.com/ to report bugs.
AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no war-
ranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercurme-
dia.com)
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+------------------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+------------------------------------+
|Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
+--------------------+------------------------------------+
|Interface Stability | External |
+--------------------+------------------------------------+
NOTES
Source for mysql is available on http://opensolaris.org.
MySQL 4.0 19 December 2000 zap(1)