Sponsored Content
Full Discussion: var memory usage increasing
Top Forums UNIX for Dummies Questions & Answers var memory usage increasing Post 302230428 by shamrock on Friday 29th of August 2008 11:28:34 AM
Old 08-29-2008
Quote:
Originally Posted by mcraul
Code:
# find /var -type f -xdev -size +50000000c
/var/lib/mysql/mailscanner/maillog.MYD
/var/lib/mysql/mailscanner/mtalog.MYD
/var/lib/mysql/timmartin/page_stats.MYD
/var/lib/mysql/glenntoyota/page_stats.MYD
/var/lib/mysql/barts/page_stats.MYD
/var/lib/mysql/michianaautomall/vehicle_manager.MYD
/var/lib/mysql/mikeanderson/page_stats.MYD

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.
 

10 More Discussions You Might Find Interesting

1. Programming

memory increasing on UNIX

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)
Discussion started by: netfer
1 Replies

2. Programming

Monitor CPU usage and Memory Usage

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)
Discussion started by: Gajanad Bihani
2 Replies

3. Programming

memory increasing

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)
Discussion started by: Frank2004
0 Replies

4. Solaris

increasing /var

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)
Discussion started by: roguekitton
0 Replies

5. HP-UX

how can I find cpu usage memory usage swap usage and logical volume usage

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)
Discussion started by: alert0919
3 Replies

6. Solaris

current CPU usage, memory usage, disk I/O oid(snmp)

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)
Discussion started by: S_venkatesh
2 Replies

7. AIX

How to monitor the IBM AIX server for I/O usage,memory usage,CPU usage,network..?

How to monitor the IBM AIX server for I/O usage, memory usage, CPU usage, network usage, storage usage? (3 Replies)
Discussion started by: laknar
3 Replies

8. UNIX for Dummies Questions & Answers

Command to display the space usage (memory usage) of a specific directory.

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)
Discussion started by: abhisheksunkari
2 Replies

9. UNIX for Dummies Questions & Answers

Memory usage per user,percent usage,sytem time in ksh

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)
Discussion started by: roy1912
2 Replies

10. Red Hat

Swap memory usage keeps increasing.

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
MYSQL_FIX_EXTENSI(1)					       MySQL Database System					      MYSQL_FIX_EXTENSI(1)

NAME
mysql_fix_extensions - normalize table file name extensions SYNOPSIS
mysql_fix_extensions data_dir DESCRIPTION
mysql_fix_extensions converts the extensions for MyISAM (or ISAM) table files to their canonical forms. It looks for files with extensions matching any lettercase variant of .frm, .myd, .myi, .isd, and .ism and renames them to have extensions of .frm, .MYD, .MYI, .ISD, and .ISM, respectively. This can be useful after transferring the files from a system with case-insensitive file names (such as Windows) to a system with case-sensitive file names. Invoke mysql_fix_extensions like this, where data_dir is the path name to the MySQL data directory. shell> mysql_fix_extensions data_dir COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc. 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
Sun Microsystems, Inc. (http://www.mysql.com/). MySQL 5.1 04/06/2010 MYSQL_FIX_EXTENSI(1)
All times are GMT -4. The time now is 01:26 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy