~Replication errors~
Hi, Iam getting the following error on my Mysql Slave server. This happened when my disk space got full and there was no space left on the device. I managed to free up some space and then ran mysql STOP SLAVE mysql CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000110', MASTER_LOG_POS=850202232; mysql START SLAVE I could find that replication started but with the following error. Can anyone help me out in fixing the issue ? I tried increasing the max_allowed_packet on master server but with no luck. 060510 0:56:22 [Note] Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'mysql-bin.000110' at position 850202232 060510 0:56:22 [ERROR] Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master ( server_errno=1236) 060510 0:56:22 [ERROR] Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when readingdata from binary log 060510 0:56:22 [Note] Slave I/O thread exiting, read up to log 'mysql- bin.000110', position 850202232 Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~Mysql performance~
Hi, The Server2 is not a slave. Seperate inserts were done on two different mysql servers. Thanks, Abdul. On Fri, 2006-04-28 at 12:01 -0400, Kishore Jalleda wrote: On 4/28/06, Mohammed Abdul Azeem [EMAIL PROTECTED] wrote: Hi, I have 2 mysql servers with version 5.0.15-standard-log running on redhat es4 installed on 2 different geographic locations. The default storage engine used is innodb on both the servers. I run an insert query on both the servers that inserts 25,00,000 records. first server takes 7.5 hrs, while the second server takes around 17 hrs for the same process. However the configuration file my.cnf is the same for both the machines. The first server has a 1GB RAM and a single processor. While the second server has a 2 GB RAM and it has a dual processor as well. If we go by the hardware specs the second server should take less time as it has a better hardware than the first one. Iam really puzzled . Can anyone help me out in fixing the issue ? Thanks, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] Is the server2 a slave of server1, and is the same insert on server2 run directly on it or is itpart of a replicated query from server1. This came to my mind as u mentioned the two servers are geographically seperated .. Kishore Jalleda http://kjalleda.googlepages.com/projects This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~Mysql performance~
Hi, The insert queries are run from the localhost on both the machines. -Abdul On Fri, 2006-04-28 at 10:28 -0700, Atle Veka wrote: On Fri, 28 Apr 2006, Mohammed Abdul Azeem wrote: Hi, I have 2 mysql servers with version 5.0.15-standard-log running on redhat es4 installed on 2 different geographic locations. The default storage engine used is innodb on both the servers. I run an insert query on both the servers that inserts 25,00,000 records. first server takes 7.5 hrs, while the second server takes around 17 hrs for the same process. Are these queries run from localhost or from a remote location? It's very unusual for an IDE based system to outperform SCSI. Atle - Flying Crocodile Inc, Unix Systems Administrator This email has been Scanned for Viruses! www.newbreak.com This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
~Mysql performance~
Hi, I have 2 mysql servers with version 5.0.15-standard-log running on redhat es4 installed on 2 different geographic locations. The default storage engine used is innodb on both the servers. I run an insert query on both the servers that inserts 25,00,000 records. first server takes 7.5 hrs, while the second server takes around 17 hrs for the same process. However the configuration file my.cnf is the same for both the machines. The first server has a 1GB RAM and a single processor. While the second server has a 2 GB RAM and it has a dual processor as well. If we go by the hardware specs the second server should take less time as it has a better hardware than the first one. Iam really puzzled . Can anyone help me out in fixing the issue ? Thanks, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~Mysql performance~
Hi, The following is the hard disk specs for both the servers: server one: ( whose performance is good ) --- class: HD bus: IDE detached: 0 device: hda driver: ignore desc: ST3200822A physical: 16383/16/63 logical: 24321/255/63 - class: HD bus: IDE detached: 0 device: hdb driver: ignore desc: ST3200822A physical: 16383/16/63 logical: 24321/255/63 This has 2 SATA hard disks of 200 GB capacity. There is no RAID configured. server two: ( whose performance is poor ) -- class: HD bus: SCSI detached: 0 device: sda driver: ignore desc: Seagate ST3146707LC host: 0 id: 0 channel: 0 lun: 0 generic: sg0 - class: HD bus: SCSI detached: 0 device: sdb driver: ignore desc: Seagate ST3146707LC host: 0 id: 1 channel: 0 lun: 0 generic: sg1 This has 2 SCSI hard disks of capacity 146 GB each. There is no RAID configured. Thanks, Abdul. On Fri, 2006-04-28 at 12:52 +0200, living liquid | Christian Meisinger wrote: Hi, I have 2 mysql servers with version 5.0.15-standard-log running on redhat es4 installed on 2 different geographic locations. The default storage engine used is innodb on both the servers. I run an insert query on both the servers that inserts 25,00,000 records. first server takes 7.5 hrs, while the second server takes around 17 hrs for the same process. However the configuration file my.cnf is the same for both the machines. The first server has a 1GB RAM and a single processor. While the second server has a 2 GB RAM and it has a dual processor as well. If we go by the hardware specs the second server should take less time as it has a better hardware than the first one. Iam really puzzled . Can anyone help me out in fixing the issue ? How does the harddisk setup looks like on both servers? This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~Mysql performance~
Hi, I would like to make one correction. The server one has 2 IDE hard disks and not SATA hard disks. Thanks, Abdul. On Fri, 2006-04-28 at 16:33 +0530, Mohammed Abdul Azeem wrote: Hi, The following is the hard disk specs for both the servers: server one: ( whose performance is good ) --- class: HD bus: IDE detached: 0 device: hda driver: ignore desc: ST3200822A physical: 16383/16/63 logical: 24321/255/63 - class: HD bus: IDE detached: 0 device: hdb driver: ignore desc: ST3200822A physical: 16383/16/63 logical: 24321/255/63 This has 2 SATA hard disks of 200 GB capacity. There is no RAID configured. server two: ( whose performance is poor ) -- class: HD bus: SCSI detached: 0 device: sda driver: ignore desc: Seagate ST3146707LC host: 0 id: 0 channel: 0 lun: 0 generic: sg0 - class: HD bus: SCSI detached: 0 device: sdb driver: ignore desc: Seagate ST3146707LC host: 0 id: 1 channel: 0 lun: 0 generic: sg1 This has 2 SCSI hard disks of capacity 146 GB each. There is no RAID configured. Thanks, Abdul. On Fri, 2006-04-28 at 12:52 +0200, living liquid | Christian Meisinger wrote: Hi, I have 2 mysql servers with version 5.0.15-standard-log running on redhat es4 installed on 2 different geographic locations. The default storage engine used is innodb on both the servers. I run an insert query on both the servers that inserts 25,00,000 records. first server takes 7.5 hrs, while the second server takes around 17 hrs for the same process. However the configuration file my.cnf is the same for both the machines. The first server has a 1GB RAM and a single processor. While the second server has a 2 GB RAM and it has a dual processor as well. If we go by the hardware specs the second server should take less time as it has a better hardware than the first one. Iam really puzzled . Can anyone help me out in fixing the issue ? How does the harddisk setup looks like on both servers? This email has been Scanned for Viruses! www.newbreak.com This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQLDump and Restore
Hello Jim, mysql -u root -p ROOTPASSWD dump.sql Thanks, Abdul. On Fri, 2006-04-21 at 17:02 +1000, Jim wrote: Hi All, Am using mySQLDump to backup db as follows mysqldump --databases OURDB -uroot -pROOTPASSWRD dump.sql How can I restore OURDB from dump.sql? Thanks Jim This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
~Master Slave setup on the same machine~
Hi, Is it possible to configure a master and slave server on the same machine ? I have 3 instances of mysql running on the same server. I need to replicate a database from one server to other 2 servers. Any links or suggestions required regarding the same. Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
~mytop output~
Hi, Iam using mytop script to monitor the processes on mysql server. This is output from mytop: MySQL on localhost (5.0.15-standard-log) up 0+02:24:46 [13:08:20] Queries: 22.6M qps: 2733 Slow: 0.0 Se/In/Up/De(%): 00/00/00/00 qps now: 2801 Slow qps: 0.0 Threads:8 ( 4/ 1) 00/00/00/00 Key Efficiency: 98.3% Bps in/out: 0.0/ 2.3 Now in/out: 8.4/ 1.3k My problem is iam unable to see Se/In/Up/De(%) values in my mytop output. Iam running insert, select update queries but still iam unable to see the values for Se/In/Up/De(%) Can anyone help me fix the issue ? Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ~ How to install 3 instances of mysql~
Thanks Rich.
On Mon, 2006-04-17 at 08:28 -0500, Duzenbury, Rich wrote:
I just did this last week on a 5.0.18 machine. It's supported by the
mysqlmanager out of the box. Here are a copy of my notes, and worked
well on a Suse machine. The locations of your files may not be the
same.
# stop the server, if running
/etc/init.d/mysql stop
# edit /etc/my.cnf to set up the instances and
# and also tell the startup script to use mysqlmanager
[mysql.server]
use-manager
[mysqld07]
port= 3307
socket = /srv/mysql/lx07sock
pid-file= /srv/mysql/lx07/lx09.pid07
datadir = /srv/mysql/lx07/data
log-error = /srv/mysql/lx07/mysql.error.log
[mysqld20]
port= 3320
socket = /srv/mysql/lx20sock
pid-file= /srv/mysql/lx20/lx09.pid20
datadir = /srv/mysql/lx20/data
log-error = /srv/mysql/lx20/mysql.error.log
# run commands as user mysql
su mysql
# go to the main mysql directory
cd /srv/mysql
# make a directory for each instance
mkdir lx07
mkdir lx20
mysql_install_db --datadir=/srv/mysql/lx07/data --user=mysql --verbose
mysql_install_db --datadir=/srv/mysql/lx20/data --user=mysql --verbose
# start the server
/etc/init.d/mysql start
# connect to first instance and configure so root can log in
# from anywhere. You may or may not want to do this.
mysql --socket=/srv/mysql/lx07sock
create user 'root'@'%' identified by 'password'
grant all on *.* to 'root'@'%' identified by 'password;
use mysql;
update user set password=password('password') where user='root';
flush privileges
# same for second instance
mysql --socket=/srv/mysql/lx20sock
create user 'root'@'%' identified by 'password'
grant all on *.* to 'root'@'%' identified by 'password';
use mysql;
update user set password=password('password') where user='root';
flush privileges
Regards,
Rich
-Original Message-
From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 15, 2006 12:53 AM
To: mysql@lists.mysql.com
Subject: ~ How to install 3 instances of mysql~
Hi,
I need to install 3 instances of mysqld server on a single
machine. Can anyone let me know how this can be acheived ?
It would be helpful if someone can send me some links and
suggestions regarding the same. Also pls lemme know what kind
of a configuration file i need to have in order to acheive the same.
Thanks in advance,
Abdul.
This email has been Scanned for Viruses!
www.newbreak.com
This email has been Scanned for Viruses!
www.newbreak.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ~ How to install 3 instances of mysql~
Hi Logan,
Thanks for the links. But how am i suppose to allocate my physical
memory for the 3 mysql instances. Pls guide me on the innodb memory
settings. My total RAM memory is 1 GB.
Thanks in advance,
Abdul.
On Sat, 2006-04-15 at 23:35 +1000, Logan, David (SST - Adelaide) wrote:
Hi,
Also a read of
http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html and
http://dev.mysql.com/doc/refman/5.0/en/mysqld-multi.html would probably
be quite helpful. The second gives you a good idea on how to setup the
my.cnf file for multiple servers. The concepts are the same for version
4.1
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, 15 April 2006 10:45 PM
To: mysql@lists.mysql.com
Subject: Re: ~ How to install 3 instances of mysql~
On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote:
To: [EMAIL PROTECTED]
From: Mohammed Abdul Azeem [EMAIL PROTECTED]
Subject: Re: ~ How to install 3 instances of mysql~
Hello Keith,
Thank you very much for your guidence.
This is my existing my.cnf file
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
thread_cache = 8
query_cache_size = 32M
log_bin_trust_routine_creators = 1
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
#specify the storage engine
default-storage-engine = InnoDB
#specify the table type
default-table-type = InnoDB
#enable the full query log
log
#Print warnings to error log file
log_warnings
#specify max connections
max_connections = 30
#specify max user connections
max_user_connections = 12
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /mysql-system/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /mysql-system/mysql/data/
innodb_log_arch_dir = /mysql-system/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5242880
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 100
The variables key_buffer = 384M, innodb_buffer_pool_size = 384M,
innodb_additional_mem_pool_size = 20M, innodb_log_buffer_size = 8M
are set for 1 instance.
My RAM memory is 1GB. Can i have the same values for the above
variables
set for all the 3 instances ? if yes, will that not exceed the
available
RAM memory. Please help me set the correct values for these variables
for each instance.
Well, if you are running multiple instances of mysqld
concurrently, then I guess you will have to share the system
resorces as well, such as memory and file handles.
Note that if you are using qps to monitor processes, for
each mysqld you have running, the memory usage will increase
appropriately.
I only use MyISAM tables the moment, so I cannot help you
with your InnoDB table settings.
Kind Regards
Keith Roberts
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This email has been Scanned for Viruses!
www.newbreak.com
This email has been Scanned for Viruses!
www.newbreak.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
~ How to install 3 instances of mysql~
Hi, I need to install 3 instances of mysqld server on a single machine. Can anyone let me know how this can be acheived ? It would be helpful if someone can send me some links and suggestions regarding the same. Also pls lemme know what kind of a configuration file i need to have in order to acheive the same. Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~ How to install 3 instances of mysql~
/local/mysql-version/my.cnf #--- # mysql client program configuration options #--- [mysql] no-auto-rehash # needed for security - to stops multiple deletes/updates # without a where clause safe-updates # # The following options will be passed to all MySQL clients [client] socket = /var/lib/mysql/mysql.sock port = # [myisamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M # [mysqldump] quick set-variable = max_allowed_packet=16M # # available programs/scripts are: #my_print_defaults mysqladmin #myisamchk mysqlbinlog #myisamlog mysqlbug - n/a #myisampack mysqlcheck #mysql mysqld #mysql_convert_table_format - .plmysqld_multi #mysql_find_rows mysqldump #mysql_fix_privilege_tables n/a mysqlhotcopy - .pl #mysql_install_dbmysqlimport #mysql_setpermission - .pl mysqlshow #mysql_zap mysqltest #mysqlaccess - .pl safe_mysqld # # end of mysql client program configurations # /etc/my.cnf To monitor the mysql instances and the parameters passed to each one, you could use a process monitoring tool like: http://www.student.nada.kth.se/~f91-men/qps/ To cleanly shut down the servers, use a script for each server instance like: #! /bin/sh # # stop the MySQL database server /usr/local/mysql-5.0.18/bin/mysqladmin shutdown \ -uroot_user_name -proot_password \ --socket=/usr/local/mysql-5.0.20-srv1/data/mysql.sock HTH Keith In theory, theory and practice are the same; in practice they are not. To unsubscribe from this list, please see detailed instructions already posted at: http://marc.theaimsgroup.com/?l=php-installm=114138567814319w=2 On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote: To: mysql@lists.mysql.com From: Mohammed Abdul Azeem [EMAIL PROTECTED] Subject: ~ How to install 3 instances of mysql~ Hi, I need to install 3 instances of mysqld server on a single machine. Can anyone let me know how this can be acheived ? It would be helpful if someone can send me some links and suggestions regarding the same. Also pls lemme know what kind of a configuration file i need to have in order to acheive the same. Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
~problem with select into outfile~
Hi Iam having a problem using select into outfile command, iam getting the following error. can anyone help me trace the problem. mysql SELECT * INTO OUTFILE'/home/public1/data.txt' FROM temp_table WHERE last_time_update = 2006-04-01; ERROR 1 (HY000): Can't create/write to file '/home/public1/data.txt' (Errcode: 13) Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
~Mysql db crashing again and again~
Hi, Iam having a mysql version 5.0.15-standard-log installed on redhat es4. It is configured as slave server. It was running fine till yesterday. Then it hit a mysql bug with signal 6. The mysql db was throwing the following errors on the shell prompt ie the OS shell prompt. *** glibc detected *** free(): invalid pointer: 0x089e6843 *** *** glibc detected *** free(): invalid pointer: 0x089e6843 *** The mysql error log shows continuous occurence of mysql signal 6 and signal 11. The output of error log file is as follows: - mysqld got signal 6; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402653184 read_buffer_size=2093056 max_used_connections=0 max_connections=10 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 434135 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x89fd360 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0x177f9c, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x814e7f8 0x8787c8 (nil) 0x69840a 0x69eb3f 0x69eeba 0x81f8bb3 0x8240d56 0x824123a 0x82403cb 0x8166f0b 0x8168d82 0x81bf14b 0x81beb8c 0x8222586 0x8220387 0x872341 0x7046fe New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x89f1860 = drop procedure FHLMC.pool_info_select thd-thread_id=2 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 060413 13:01:56 mysqld restarted Can anyone help me trace out the problem and how to go about the same ? Is it something related to glibc version that is causing the problem ? Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~performance issues~
Thanks Ravi On Tue, 2006-04-11 at 11:41 +0530, Ravi Prasad LR wrote: yes, that is the reason for slowness . Thanks, Ravi On Tuesday 11 April 2006 10:51, Mohammed Abdul Azeem wrote: Hi Ravi, Since the sync'ing is done to disk with sync_binlog=1, the update queries to server are slower compared to the server having sync_binlog=0 rite ? Thanks, Abdul. On Tue, 2006-04-11 at 10:51 +0530, Ravi Prasad LR wrote: Hi Abdul, When sync_binlog is set to 1, innodb fsyncs the binary log to disk after every single write to binary log, but not in the case of sync_binlog=0. From MySQL manual: snip If the value of this variable is positive, the MySQL server synchronizes its binary log to disk (fdatasync()) after every sync_binlog writes to this binary log. Note that there is one write to the binary log per statement if in autocommit mode, and otherwise one write per transaction. The default value is 0 which does no sync'ing to disk. A value of 1 is the safest choice, because in case of crash you lose at most one statement/transaction from the binary log; but it is also the slowest choice (unless the disk has a battery-backed cache, which makes sync'ing very fast). This variable was added in MySQL 4.1.3. /snip --Ravi On Tuesday 11 April 2006 10:22, Mohammed Abdul Azeem wrote: Hi, I have a master/slave setup ( replication enabled ) for mysql in two different geographic locations ( one master/slave set up in each location). In one location i have configured the sync_binlog=1 . And the other location does not have the same. My problem is, when i run similar update processes on both the master servers, the server with sync_binlog=1 is very slower in terms of completing the update query as compared to the machine having sync_binlog=0. Is that a cause for slow performance ? Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com This email has been Scanned for Viruses! www.newbreak.com This email has been Scanned for Viruses! www.newbreak.com This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
~performance issues~
Hi, I have a master/slave setup ( replication enabled ) for mysql in two different geographic locations ( one master/slave set up in each location). In one location i have configured the sync_binlog=1 . And the other location does not have the same. My problem is, when i run similar update processes on both the master servers, the server with sync_binlog=1 is very slower in terms of completing the update query as compared to the machine having sync_binlog=0. Is that a cause for slow performance ? Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~performance issues~
Hi Ravi, Since the sync'ing is done to disk with sync_binlog=1, the update queries to server are slower compared to the server having sync_binlog=0 rite ? Thanks, Abdul. On Tue, 2006-04-11 at 10:51 +0530, Ravi Prasad LR wrote: Hi Abdul, When sync_binlog is set to 1, innodb fsyncs the binary log to disk after every single write to binary log, but not in the case of sync_binlog=0. From MySQL manual: snip If the value of this variable is positive, the MySQL server synchronizes its binary log to disk (fdatasync()) after every sync_binlog writes to this binary log. Note that there is one write to the binary log per statement if in autocommit mode, and otherwise one write per transaction. The default value is 0 which does no sync'ing to disk. A value of 1 is the safest choice, because in case of crash you lose at most one statement/transaction from the binary log; but it is also the slowest choice (unless the disk has a battery-backed cache, which makes sync'ing very fast). This variable was added in MySQL 4.1.3. /snip --Ravi On Tuesday 11 April 2006 10:22, Mohammed Abdul Azeem wrote: Hi, I have a master/slave setup ( replication enabled ) for mysql in two different geographic locations ( one master/slave set up in each location). In one location i have configured the sync_binlog=1 . And the other location does not have the same. My problem is, when i run similar update processes on both the master servers, the server with sync_binlog=1 is very slower in terms of completing the update query as compared to the machine having sync_binlog=0. Is that a cause for slow performance ? Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
~How to load a mysql data file into sybase~
Hello, I have a mysql data bcp file ( using select into outfile ) from a table in mysql database. I have a similar table existing in a sybase database. I need to bcp in the mysql data file into sybase. Can anyone help me on how to go about the same ? Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
~how to add a new innodb data file~
Hi, Iam running a mysql server 5.0.15 over Redhat linux es4. My disk space has exhausted. so i need to add a new ibdata file to my /etc/my.cnf configuration. I followed the following procedure to do so. 1. I checked the ibdata1 file size. when i do a du -sh ibdata1 , i get the size to be 443M when i do a ls -ltr ibdata1 , i get the size to be 463470592 bytes 2. I edited my /etc/my.cnf to add the following: innodb_data_file_path = /mysql-system/mysql/data/ibdata1:443M;/mysql- system2/ibdata2:50M:autoextend i got the following error: 060330 01:48:42 mysqld started InnoDB: Error: data file /mysql-system/mysql/data/ibdata1 is of a different size InnoDB: 28288 pages (rounded down to MB) InnoDB: than specified in the .cnf file 28416 pages! InnoDB: Could not open or create data files. InnoDB: If you tried to add new data files, and it failed here, InnoDB: you should now edit innodb_data_file_path in my.cnf back InnoDB: to what it was, and remove the new ibdata files InnoDB created InnoDB: in this failed attempt. InnoDB only wrote those files full of InnoDB: zeros, but did not yet use them in any way. But be careful: do not InnoDB: remove old data files which contain your precious data! 060330 1:48:42 [Note] /mysql-system/mysql/bin/mysqld: ready for connections. Version: '5.0.15-standard-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL) 3. Then i tried adding the value from 'ls -ltr ibdata1' which is 463470592 bytes. I rounded the same to 464M . but still got the same error. Can anyone help me out on how to go about the same. Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ~Mysql cluster info~
Hello Jimmy, Do we have a production release of MYSQL cluster 5.1 ? If yes please let me know the path from where i can download the same. Thanks in advance, Abdul. On Tue, 2006-03-21 at 07:16 -0600, Jimmy Guerrero wrote: Hello, MySQL 5.0 Cluster is an in-memory database. Meaning that the entire database (tables, indexes, etc.) must fit in RAM along with your other OS and application processes. In 5.1, we have introduced disk-based data support. Note, that although data can now be stored on disk, indexes must still reside in memory. Might be worth checking out, however 55 GB is def. on the large size for a MySQL Cluster configuration. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Monday, March 20, 2006 9:33 PM To: mysql@lists.mysql.com Subject: ~Mysql cluster info~ Hi, Iam new to clustering in mysql. I went through the reference manual 5.0 and found that the RAM memory requirements for implementing a cluster is almost twice the size of the database. My problem is i have a database which is 55GB. So does it mean that i need to have 110 GB RAM memory ? Can anyone let me know whether it is possible for me to configure a cluster for such a huge database. If yes, how am i suppose to proceed ( regarding memory requirements ). Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
~BCP for mysql~
Hi, Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not, is there any other tool which can do the same operation. I need to perform a bcp out from Mysql and then bcp in to Sybase. Please help me out regarding the same. Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
~Mysql cluster info~
Hi, Iam new to clustering in mysql. I went through the reference manual 5.0 and found that the RAM memory requirements for implementing a cluster is almost twice the size of the database. My problem is i have a database which is 55GB. So does it mean that i need to have 110 GB RAM memory ? Can anyone let me know whether it is possible for me to configure a cluster for such a huge database. If yes, how am i suppose to proceed ( regarding memory requirements ). Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ~~Info needed~~
Hi Green Eugene,
Thanks a lot.
On Fri, 2006-03-10 at 09:57 -0500, [EMAIL PROTECTED] wrote:
Косов Евгений [EMAIL PROTECTED] wrote on 03/10/2006 07:53:37 AM:
Hm... It seems to me In MySQL there's no such thing as database owner.
Or am I missing something?
Mohammed Abdul Azeem пишет:
Hi,
How to check for the database owner for a particular database ? The
way
show procedure status command lists the definer column, Is there a
command that shows the database owner. Similarly, what is the command
to
see the owner of a table in a database ?
Thanks in advance,
Abdul.
This email has been Scanned for Viruses!
www.newbreak.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Eugene is right. Objects within a MySQL database are not owned by any
one account. They are essentially all global objects organized into
specific databases.
Here's the reason behind the column your found. In the CREATE STORED
PROCEDURE statement there is a clause:
SQL SECURITY { DEFINER | INVOKER }
That clause tells the database under whose credentials should the
statements of the SPROC be executed. It determines if the SPROC will
execute under the credentials of the user who created it or the user who
is invoking it. DEFINER is the default value if none is specified.
More details here:
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
This email has been Scanned for Viruses!
www.newbreak.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
~~Info needed~~
Hi, How to check for the database owner for a particular database ? The way show procedure status command lists the definer column, Is there a command that shows the database owner. Similarly, what is the command to see the owner of a table in a database ? Thanks in advance, Abdul. This email has been Scanned for Viruses! www.newbreak.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
