Lots of page faults on AIX mySQL lpar Post: 302477390

Sponsored Content

Operating Systems AIX Lots of page faults on AIX mySQL lpar Post 302477390 by zxmaus on Saturday 4th of December 2010 09:00:19 PM

12-04-2010

Moderator

assuming that you run jfs2 and not jfs filesystems, you should rather choose cio than dio to get the full advantage of the settings. You might want to set AIXTHREADSCOPE=S in your /etc/environment and you want for sure mount your filesystems with noatime option. I do not know anything about mysql on AIX but if the DB is capable to take advantage from async IO like oracle does, than you may want to adjust the aio settings to a higher maxreq setting and to give you more hints on optimization, it would be interesting to know what kind of workload your DB has ... random like for trading / oltp databases or more serial ... like typical for batch- and reporting workloads.

BTW - if you want to show us sample data - please take that data from a time where your system is particularly busy - the data you have posted so far shows a completely idle box - and a system that doesnt do anything has usually no performance issues.

You have a realtively high amount of cpu for a pretty low amount of memory - if your DB has caches like oracle or sybase, it might be worth extending these for more performance ...

Regards
zxmaus

Last edited by zxmaus; 12-04-2010 at 10:08 PM..

zxmaus

View Public Profile for zxmaus

Find all posts by zxmaus

10 More Discussions You Might Find Interesting

1. HP-UX

Copy on Write page faults

Hello Please can you tell me how to access COPY ON WRITE page faults in HP -UNIX. I found the structure in /usr/include/sys/vmmeter with the structure name vmmeter. Please tell me the function to fill the values to this structure and also the arguments for function.::

2. HP-UX

Intransient blocking page faults

Hi, Will anybody tell me what is this 'intransient blocking page faults' in HP-UX, it is in the structure _pst_vminfo in the header file /ust/include/sys/pstat/vm_pstat_body.h?

3. AIX

High Page Faults

Sorry my poor english In 570 pseries nmon shows excessive page faults, ascents of something more than 30000 Page faults. System: AIX 5.2 ML5 Processor Type: PowerPC_POWER5 Number Of Processors: 2 Processor Clock Speed: 1656 MHz CPU Type: 64-bit Kernel Type: 64-bit Memory Size: 2816 MB ...

4. AIX

How to Find if AIX machine is LPar or not

Hi, I want to know if there is any command which will tell me if an AIX machine is a LPar or not. I am using "lparstat -i" but it does not work on all AIX machines. Is there any generic command by whose output I will come to know if it is an LPar or not? Please help. Thanks, Vineet

5. AIX

Lots of page faults and free memory

Hello, I've been reading your forums for quite a while and the great amount of information I find here always come in hand.This time however, I need some specific help... I have a doubt with an AIX server which I'm failing to understand as I'm new to its concept of memory management... ...

6. AIX

AIX 7.1 high page faults

hi guys i hope you can help me with this situation. i have 2 lpar with aix 7.1 and oracle 11gr2 in grid mode. when i start nmon to check the current system health i notice that page fault are over 3000/s. than i have opened a case with ibm and they say that the problem is not paging nor...

7. AIX

Will it affect my AIX LPAR security, when i set up email alerts on AIX server.

Hello, I've set up email alerts on AIX Servers. so that i can get email notifications (via mail relay server) when ever there is abnormal behavior. for example 1) my script monitors CPU/disk/memory etc... when it reaches high water ark, it will send an email alert. 2) disk usage alerts 3)...

8. Solaris

Page faults on OS

Hi guys, I have a zone on a M5000 server running solaris 10. The zone has an SAP application running on it and facing some performance issues. As part of the troubleshooting, I've been recommended to look for any paging on the OS. Please advise how to look for the paging. I've been looking at...

9. AIX

High Paging when lots of free memory AIX 5.3

I am new to AIX, I have few AIX 5.3 servers and I could see there are significant difference in paging space utilization on servers even though they are running same applications below server is working fine which shows 2-5 % paging usage throuh out the day cpu_scale_memp = 8...

10. AIX

AIX LPAR FC connection to SAN

Hi all, In my system, I have HMC 7 with Power Machine 6 & 7. On the managed system, we have many lpars. In some lpars, I can see they are using virtual fiber channel to connect to DS8K storage. In search with google, I understand that it is configured with VIOS server to share the physical FC...

LEARN ABOUT DEBIAN

virtual-filesystems

virtual-filesystems(7)					 Miscellaneous Information Manual				    virtual-filesystems(7)

NAME

       virtual-filesystems - event signalling that virtual filesystems have been mounted

SYNOPSIS

       virtual-filesystems [ENV]...

DESCRIPTION

       The  virtual-filesystems  event	is  generated  by  the mountall(8) daemon after it has mounted all virtual filesystems listed in fstab(5).
       mountall(8) emits this event as an informational signal, services and tasks started or stopped by this event will do so	in  parallel  with
       other activity.

       This event is typically used by services that must be started in order to mount other filesystems.  When this event occurs, common filesys-
       tems such as /usr may not be mounted.  For most normal services the filesystem(7) event is sufficient.

EXAMPLE

       A service that wishes to be running once virtual filesystems are mounted might use:

	      start on virtual-filesystems

SEE ALSO

       mounting(7) mounted(7) local-filesystems(7) remote-filesystems(7) all-swaps(7) filesystem(7)

mountall							    2009-12-21						    virtual-filesystems(7)

10 More Discussions You Might Find Interesting

1. HP-UX

Copy on Write page faults

Discussion started by: manjunath

2. HP-UX

Intransient blocking page faults

Discussion started by: sushaga

3. AIX

High Page Faults

Discussion started by: daviguez

4. AIX

How to Find if AIX machine is LPar or not

Discussion started by: vineetd