While restoring a dump file having 4 GB of size Mysql gives Out of memory around after 10 minutes success full restore. Error details are given below.
Configuration: Mysql version : Mysql 5.0.41 32 bit max_allowed_packet = 300M
mysql>source my_dump.sql
Error:
Query OK, 2310 rows affected (0.69 sec)
Records: 2310 Duplicates: 0 Warnings: 0
mysql: Out of memory (Needed 1564047040 bytes)
mysql: Out of memory (Needed 1564047048 bytes)
Solutions will be appreciable.
We have given the following setting with corosync and pacemaker.
crm configure rsc_defaults resource-stickiness="100"
And it works fine when the primary server goes down. But it wont work revers, resource(httpd) migration back to primary after restarting the primary and bringing down the secondary.
ie
As I said everything works well, but i need just one thing, i have the directive " resource-stickiness="100", when node1 is down, the node2 starts all resources and prevent failback again though the node1 is up, back i need move all resources to the first one when I certainly sure the node1 is runnig, is there some directive to tell pacemaker that move back again the to node1 automatically? i mean, is posibble to move back resources to node1 when It has passed certain time, maybe 1 hour or something?
I have added the user "test" in myuser group usermod -a -G test myuser. But if I try to execute or try to cd to datadir as "test" user gives the Permission denied error. datadir is having the following privilege 770 and the user "test" belongs to myuser group and still it gives the Permission denied error.
drwxrwx--- 3 myuser myuser 4096 Feb 6 16:24 datadir
$ grep "^test" /etc/group
test:x:503:myuser
$ groups myuser
myuser : myuser test
watch command to notify on newly created files on linux
How to modify the below command to notify on creating a new file to /usr/local/mydir/ by linux user john ?
watch -d 'ls -l /usr/local/mydir/ | fgrep john'
ie I want to continually monitor and call an another script if any new file is created to /usr/local/mydir/.
As In production I cannot go for any tool instead of shell script. So can help me with shell scripting solution ?
How to fetch lines between two strings using shell script? For example I am having a file called file_text.txt as below.
MEDIUMINT
CREATE (
MAXVALUE
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MIDDLEINT );
MINUTE_SECOND
MINUTE_SECOND
CREATE (
MINUTE_MICROSECOND
MINUTE_SECOND
MOD );
MODIFIES
MEDIUMINT
CREATE (
NATURAL
NOT
NO_WRITE_TO_BINLOG
NULL );
NUMERIC
ON
OPTIMIZE
I want to grep all lines between CREATE and ; from the file. Including the CREATE and ;string.
While restoring the Mysql dump file it throws the following error.
ERROR 1665 (HY000): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging.
Query OK, 0 rows affected (0.00 sec)
The replication configuration is as below.
my.cnf
server-id = 33
max_binlog_size=40M
log_bin=/MySql_5.5.8/log/my-bin
log-bin-index=/MySql_5.5.8/log/log/mysql_rpllg/my-bin.index
I am running the mysql with a max_allowed_packet of 32 M (33554432). As I want to dynamically allocate 126M I have gone for the below option
set GLOBAL max_allowed_packet=132120576;
But the show variables like '%max_allowed_packet%'; still Shows 32M only with the already logged mysql sessions but the new sessions are reflected with the new value.
max_allowed_packet | 33554432
Issue Details : While restoring the dump file, I can see the source operation is hanging hence I gone for the above option but still it is in the same state. Can I dynamically do any changes and solve the issue ?
How to log the error and warning while restoring the SQL dump on MySQL ?
Following are the steps we were doing.
mysql> CREATE DATABASE dbname;
mysql> USE dbname;
mysql> SOURCE dbdumpname.sql
1 ) How to relocate the data dir while installing the MySQL-server-5.5.18-1.linux2.6.i386.rpm.
rpm -ivh MySQL-server-5.5.18-1.linux2.6.i386.rpm
The following will allow newuser to run any commands anywhere? How can I prevent it by allowing the user to run certain commands only?
visudo
## Allow root to run any commands anywhere
root ALL=(ALL) ALL
newuser ALL=(ALL) ALL
After doing the cifs mount we are unable to touch on the share with the user kvk. But we are able to do the same as a root user. following are the configuration and error log.
Fedora version 15: fstab:
//<windows-ip>/HS /home/kvk/share/HS cifs defaults,username=user_support 0 0
Error while touch :
[kvk@ats-079 @temp]$ pwd
/home/kvk/share/HS/temp
[kvk@ats-079 @temp]$ touch newfile
touch: cannot touch `newfile': Permission denied
@temp is the directory with in //windows-ip>/HS
How can I use --nice=-10 with cp command in linux ?
Following are the example when I tried the option and it gives the error unrecognized option EX- error:
cp --nice=-20 -r dir1 /d/
cp: unrecognized option `--nice=-20'
Try `cp --help' for more information.
scp with password less authentication is working fine but if delete a file on the source it will not get replicated ie the destination directory is not completely replaced with source. I can see the new files or modifications are properly get replicated.
scp -r /user/local/img [email protected]:/user/local/img
Vnc viewer is showing black screen. Following are the configuration : Please figure out the issue ?
cat /root/.vnc/xstartup
#!/bin/sh
# Uncomment the following two lines for normal desktop:
unset SESSION_MANAGER
exec /etc/X11/xinit/xinitrc
[ -x /etc/vnc/xstartup ] && exec /etc/vnc/xstartup
[ -r $HOME/.Xresources ] && xrdb $HOME/.Xresources
xsetroot -solid grey
vncconfig -iconic &
xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &
twm &
====================================================================
vi /etc/sysconfig/vncservers
VNCSERVERS="2:root"
VNCSERVERARGS[2]="-geometry 1024x768"
=================================================================
Run level :
chkconfig --list vncserver
vncserver 0:off 1:off 2:on 3:on 4:on 5:on 6:off