Home Archives for Juli 2019

Kamis, 25 Juli 2019

How to Check and Set the MySql max connection

    Tidak ada komentar
Check the max connection 
mysql> SHOW VARIABLES LIKE "max_connections";
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 151   |
+-----------------+-------+
1 row in set (0.00 sec)
Set the max connection again
mysql> SET GLOBAL max_connections = 250;
Query OK, 0 rows affected (0.02 sec)
Check the max connection again
mysql> SHOW VARIABLES LIKE "max_connections";
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 250   |
+-----------------+-------+
1 row in set (0.00 sec)


Rabu, 24 Juli 2019

How to fix 0506-342 The superblock on /dev/xx is dirty on AIX

    Tidak ada komentar
Disk is dirty
bash-4.2# mount /dev/fslv02 /data
Replaying log for /dev/fslv02.
mount: 0506-324 Cannot mount /dev/fslv02 on /data: The media is not formatted or the format is not correct.
0506-342 The superblock on /dev/fslv02 is dirty.  Run a full fsck to fix.
bash-4.2#
Fix the disk
bash-4.2# fsck /dev/fslv02



The current volume is: /dev/fslv02
Primary superblock is valid.
J2_LOGREDO:log redo processing for /dev/fslv02
j2_logredo.cpp: ERROR in j2_logredo line 672, log already redone!

Primary superblock is valid.
*** Phase 1 - Initial inode scan
*** Phase 2 - Process remaining directories
*** Phase 3 - Process remaining files
*** Phase 4 - Check and repair inode allocation map
File system inode map is corrupt; FIX? yes
Superblock marked dirty because repairs are about to be written.
*** Phase 5 - Check and repair block allocation map
Block allocation map is corrupt; FIX? yes
File system is clean.
Superblock is marked dirty; FIX? yes
All observed inconsistencies have been repaired.
bash-4.2#

Disk can be mount again
bash-4.2# mount /dev/fslv02 /data
bash-4.2#
bash-4.2# df -g
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4           0.50      0.10   81%    11278    31% /
/dev/hd2          12.50     10.33   18%    47994     2% /usr
/dev/hd9var        2.00      0.91   55%     8630     4% /var
/dev/hd3           6.00      5.19   14%      788     1% /tmp
/dev/hd1           4.00      2.58   36%      879     1% /home
/dev/hd11admin      0.25      0.25    1%        5     1% /admin
/proc                 -         -    -         -     -  /proc
/dev/hd10opt      72.00     20.15   73%   201162     4% /opt
/dev/livedump      0.25      0.25    1%        4     1% /var/adm/ras/livedump
/dev/fslv01        0.50      0.50    1%        5     1% /data_old
/dev/fslv02     2018.00   1045.32   49%   906613     1% /data
bash-4.2#



How to mount disk on AIX

    Tidak ada komentar
Before disk mount
bash-4.2# df -g
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4           0.50      0.10   81%    11278    31% /
/dev/hd2          12.50     10.33   18%    47994     2% /usr
/dev/hd9var        2.00      0.91   55%     8630     4% /var
/dev/hd3           6.00      5.19   14%      788     1% /tmp
/dev/hd1           4.00      2.58   36%      879     1% /home
/dev/hd11admin      0.25      0.25    1%        5     1% /admin
/proc                 -         -    -         -     -  /proc
/dev/hd10opt      72.00     20.15   73%   201162     4% /opt
/dev/livedump      0.25      0.25    1%        4     1% /var/adm/ras/livedump
/dev/fslv01        0.50      0.50    1%        5     1% /data_old
bash-4.2#
Mount the disk 
bash-4.2# mount /dev/fslv02 /data
bash-4.2#
bash-4.2# df -g
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4           0.50      0.10   81%    11278    31% /
/dev/hd2          12.50     10.33   18%    47994     2% /usr
/dev/hd9var        2.00      0.91   55%     8630     4% /var
/dev/hd3           6.00      5.19   14%      788     1% /tmp
/dev/hd1           4.00      2.58   36%      879     1% /home
/dev/hd11admin      0.25      0.25    1%        5     1% /admin
/proc                 -         -    -         -     -  /proc
/dev/hd10opt      72.00     20.15   73%   201162     4% /opt
/dev/livedump      0.25      0.25    1%        4     1% /var/adm/ras/livedump
/dev/fslv01        0.50      0.50    1%        5     1% /data_old
/dev/fslv02     2018.00   1045.32   49%   906613     1% /data
bash-4.2#

Langganan: Postingan ( Atom )