RE: slave is running slow in another data center
do a show full processlist on the 4th slave and see what process is running. This will the sql's running which will be the cause of the slowness. This does not help because there is not a specific query, which is running slow. Other 3 slaves are running same query and Ive compared the explain on all slaves for most of the updates and they looks same. All H/W and S/W config are same including the cnf file settings. Also u need to check on the INTERNET bandwidth from the current data center to the other data center. This is also not an issue because IO thread is way ahead then SQL thread. It's a SQL thread, which is not able to keep up. On 6/18/08, Sagar, Sanjeev [EMAIL PROTECTED] wrote: Hello All, I've 4 slaves of a master. Out of 4, 3 are in same data center and have no issues. The fourth one is in another data center and some time that slave sql_thread lag behind more then 5000 sec. It's only sql_thread, which slow down. All H/W, S/W and my.cnf files are same for all slaves. I ran the mysqladmin extended-status in iterative mode and following kind of results are there in my log file | Variable_name | Value | ++---+ | Bytes_received | 2117975 | | Com_insert | 39| | Com_show_slave_status | 4 | | Com_show_status| 1 | | Com_update | 49| | Connections| 1 | | Handler_read_key | 49| | Handler_read_next | 2 | | Handler_update | 3629 | | Key_blocks_not_flushed | 1 | | Key_blocks_unused | -21 | | Key_blocks_used| 21| | Key_reads | 21| | Key_write_requests | 94| | Key_writes | 75| | Max_used_connections | 1 | | Questions | 93| | Table_locks_immediate | 88| | Threads_connected | 1 | | Threads_created| 1 | ++---+ ++---+ | Variable_name | Value | ++---+ | Bytes_received | 1469626 | | Bytes_sent | 3837 | | Com_delete | 2 | | Com_insert | 143 | | Com_show_status| 1 | | Com_update | 1247 | | Handler_delete | 5 | | Handler_read_key | 1249 | | Handler_read_next | 73| | Handler_read_rnd | 8379 | | Handler_update | 9625 | | Handler_write | 8492 | | Key_blocks_not_flushed | 1 | | Key_blocks_unused | -158 | | Key_blocks_used| 158 | | Key_read_requests | 52672 | | Key_reads | 158 | | Questions | 1394 | | Table_locks_immediate | 1392 | | Threads_cached | 1 | | Threads_connected | -1| Any idea any one, that what can be tunned here for keeping sql_thread running same as other slaves. My key_buffers are set to 1G in cnf file. Also on this slave, no binary logging is enabled or no slow log is enabled. And no application is connected. This is purely stand alone slave for disaster recovery. Regards,
slave is running slow in another data center
Hello All, I've 4 slaves of a master. Out of 4, 3 are in same data center and have no issues. The fourth one is in another data center and some time that slave sql_thread lag behind more then 5000 sec. It's only sql_thread, which slow down. All H/W, S/W and my.cnf files are same for all slaves. I ran the mysqladmin extended-status in iterative mode and following kind of results are there in my log file | Variable_name | Value | ++---+ | Bytes_received | 2117975 | | Com_insert | 39| | Com_show_slave_status | 4 | | Com_show_status| 1 | | Com_update | 49| | Connections| 1 | | Handler_read_key | 49| | Handler_read_next | 2 | | Handler_update | 3629 | | Key_blocks_not_flushed | 1 | | Key_blocks_unused | -21 | | Key_blocks_used| 21| | Key_reads | 21| | Key_write_requests | 94| | Key_writes | 75| | Max_used_connections | 1 | | Questions | 93| | Table_locks_immediate | 88| | Threads_connected | 1 | | Threads_created| 1 | ++---+ ++---+ | Variable_name | Value | ++---+ | Bytes_received | 1469626 | | Bytes_sent | 3837 | | Com_delete | 2 | | Com_insert | 143 | | Com_show_status| 1 | | Com_update | 1247 | | Handler_delete | 5 | | Handler_read_key | 1249 | | Handler_read_next | 73| | Handler_read_rnd | 8379 | | Handler_update | 9625 | | Handler_write | 8492 | | Key_blocks_not_flushed | 1 | | Key_blocks_unused | -158 | | Key_blocks_used| 158 | | Key_read_requests | 52672 | | Key_reads | 158 | | Questions | 1394 | | Table_locks_immediate | 1392 | | Threads_cached | 1 | | Threads_connected | -1| Any idea any one, that what can be tunned here for keeping sql_thread running same as other slaves. My key_buffers are set to 1G in cnf file. Also on this slave, no binary logging is enabled or no slow log is enabled. And no application is connected. This is purely stand alone slave for disaster recovery. Regards,
Row level security in MySQL
Hello All, I have a requirement where I have to implement the Oracle fine grain access control functionality in MySQL 4.0.19 Any ideas will be highly appreciable that how can I implement this in MySQL. I know how to do it in Oracle but not sure if MySQL can do this. For details about Oracle fine grain access or row level security, see below mention link http://www.unix.org.ua/orelly/oracle/guide8i/ch08_01.htm http://www.unix.org.ua/orelly/oracle/guide8i/ch08_01.htm Best Regards, Sagar, Sanjeev.vcf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: Row level security in MySQL
Thanks ! -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:28 AM To: Sagar, Sanjeev; [EMAIL PROTECTED] Subject: Re: Row level security in MySQL At 10:16 -0500 5/11/04, Sagar, Sanjeev wrote: Hello All, I have a requirement where I have to implement the Oracle fine grain access control functionality in MySQL 4.0.19 Any ideas will be highly appreciable that how can I implement this in MySQL. I know how to do it in Oracle but not sure if MySQL can do this. It cannot. You must implement this in your application. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Space allocation info for MyISAM tables
I have a requirement where I have to accept only two parameters in script for space and other calculation i.e. -i instance_name -o outfile My instance can have multiple databases and can have MyISAM and Innodb table type both. I am looking for following info for MyISAM tabel type Total space allocated Total space used I am clear for Innodb but I don't see anything for MyISAM like any data file path and file size. I am sharing same file system for both kind of tables. I tried show table status or mysqlshow -i commands but did not help much for MyISAM tables. Any ideas will be appreciable. Sagar, Sanjeev.vcf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL install problem on RH 3.0 IA64
Hello Everyone, We are already working with MySQL support on this issue but just wondering if there are anyone using MySQL database on RH 3.0. Following is our O/S and DB version info O/S : Red Hat Enterprise Linux AS release 3 (Taroon Update 1) Kernel 2.4.21-9.ELsmp on an x86_64 Linux pinhpe02 2.4.21-9.EL #1 SMP Thu Jan 8 16:54:40 EST 2004 ia64 ia64 ia64 GNU/Linux MySQL: mysql-pro-4.0.18-unknown-linux-ia64 Problem Description: /usr/local/mysql ./scripts/mysql_install_db --user=hybmysql WARNING: The host 'pinhpe02' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL daemon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables mysqld got signal 11; 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=8388600 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! As you can see grant table installation failed. Following is the output from ./bin/mysqlbug SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: hybmysql To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-4.0.18-pro (Official MySQL-pro binary) C compiler: C++ compiler: Environment: machine, os, target, libraries (multiple lines) System: Linux pinhpe02 2.4.21-9.EL #1 SMP Thu Jan 8 16:54:40 EST 2004 ia64 ia64 ia64 GNU/Linux Architecture: ia64 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/ia64-redhat-linux/3.2.3/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checkin g --with-system-zlib --enable-__cxa_atexit --host=ia64-redhat-linux Thread model: posix gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-24) Compilation info: CC='ecc' CFLAGS='-O2 -tpp2 -ip -nolib_inline' CXX='ecc' CXXFLAGS='-O2 -tpp2 -ip -nolib_inline' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Mar 26 04:44 /lib/libc.so.6.1 - libc-2.3.2.so -rwxr-xr-x1 root root 2898136 Nov 7 12:45 /lib/libc-2.3.2.so -rw-r--r--1 root root
FW: MySQL install problem on RH 3.0 IA64
Small correction : Kernel 2.4.21-9.ELsmp on an x86_64 is not valid in this case. It came form another machine. Real kernel version is Linux pinhpe02 2.4.21-9.EL #1 SMP Thu Jan 8 16:54:40 EST 2004 ia64 ia64 ia64 GNU/Linux MySQL: mysql-pro-4.0.18-unknown-linux-ia64 Problem Description: /usr/local/mysql ./scripts/mysql_install_db --user=hybmysql WARNING: The host 'pinhpe02' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL daemon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables mysqld got signal 11; 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=8388600 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! As you can see grant table installation failed. Following is the output from ./bin/mysqlbug SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: hybmysql To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-4.0.18-pro (Official MySQL-pro binary) C compiler: C++ compiler: Environment: machine, os, target, libraries (multiple lines) System: Linux pinhpe02 2.4.21-9.EL #1 SMP Thu Jan 8 16:54:40 EST 2004 ia64 ia64 ia64 GNU/Linux Architecture: ia64 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/ia64-redhat-linux/3.2.3/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checkin g --with-system-zlib --enable-__cxa_atexit --host=ia64-redhat-linux Thread model: posix gcc version 3.2.3 20030502 (Red Hat Linux 3.2.3-24) Compilation info: CC='ecc' CFLAGS='-O2 -tpp2 -ip -nolib_inline' CXX='ecc' CXXFLAGS='-O2 -tpp2 -ip -nolib_inline' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Mar 26 04:44 /lib/libc.so.6.1 - libc-2.3.2.so -rwxr-xr-x1 root root 2898136 Nov 7 12:45 /lib/libc-2.3.2.so -rw-r--r--1 root root 5171628 Nov 7 12:46 /usr/lib/libc.a -rw-r--r--1 root root 213 Nov 7 12:01 /usr/lib/libc.so Configure command: ./configure
Udf_Example.so compilation error with gcc
Hello All, I am trying to compile udf_example.cc or myfunc.cc (copy of udf_example) with gcc on Solaris 2.8 but facing following errors [EMAIL PROTECTED]:/usr/local/mysql-4.0.14/sqlgcc -shared -I/usr/local/mysql-4.0.14/include -o myfunc.so myfunc.cc In file included from myfunc.cc:122: /usr/local/mysql-4.0.14/include/my_global.h:70:23: my_config.h: No such file or directory In file included from myfunc.cc:122: /usr/local/mysql-4.0.14/include/my_global.h:456: syntax error before `;' token /usr/local/mysql-4.0.14/include/my_global.h:701: syntax error before string constant /usr/local/mysql-4.0.14/include/my_global.h:781: redeclaration of C++ built-in type `bool' In file included from myfunc.cc:123: /usr/local/mysql-4.0.14/include/my_sys.h:593: `func' was not declared in this scope /usr/local/mysql-4.0.14/include/my_sys.h:593: type specifier omitted for parameter `RETSIGTYPE()()' /usr/local/mysql-4.0.14/include/my_sys.h:593: invalid declarator /usr/local/mysql-4.0.14/include/my_sys.h:644: syntax error before `(' token /usr/local/mysql-4.0.14/include/my_sys.h:654: syntax error before `(' token /usr/local/mysql-4.0.14/include/my_sys.h:658: syntax error before `(' token I tried through make also. See below [EMAIL PROTECTED]:/usr/local/mysql-4.0.14/sql/usr/ccs/bin/make udf_example.o source='udf_example.cc' object='udf_example.o' libtool=no \ depfile='.deps/udf_example.Po' tmpdepfile='.deps/udf_example.TPo' \ depmode=none /bin/bash ../depcomp \ gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql-4.0.14\ -DDATADIR=\/usr/local/mysql-4.0.14/var\ -DSHAREDIR=\/usr/local/mysql-4.0.14/share/mysql\ -DHAVE_CONFIG_H -I. -I. -I.. -I../innobase/include -I./../include -I./../regex -I. -I../include -I. -O3 -DDBUG_OFF -O3 -m64 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW -DDEFINE_CXA_PURE_VIRTUAL -D_FILE_OFFSET_BITS=64 -DHAVE_CURSES_H -I/usr/local/mysql-4.0.14/include -DHAVE_RWLOCK_T -c -o udf_example.o `test -f udf_example.cc || echo './'`udf_example.cc In file included from udf_example.cc:122: ../include/my_global.h:70:23: my_config.h: No such file or directory In file included from udf_example.cc:122: ../include/my_global.h:456: syntax error before `;' token ../include/my_global.h:701: syntax error before string constant ../include/my_global.h:781: redeclaration of C++ built-in type `bool' In file included from udf_example.cc:123: ../include/my_sys.h:593: `func' was not declared in this scope ../include/my_sys.h:593: type specifier omitted for parameter `RETSIGTYPE()()' ../include/my_sys.h:593: invalid declarator ../include/my_sys.h:644: syntax error before `(' token ../include/my_sys.h:654: syntax error before `(' token ../include/my_sys.h:658: syntax error before `(' token *** Error code 1 make: Fatal error: Command failed for target `udf_example.o' Just for testing I commented out the code at error line number and got udf_example.so or myfunc.so file but when I tried to create function in mysql, it gave following error mysql CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME myfunc.so; ERROR 1126: Can't open shared library 'myfunc.so' (errno: 0 ld.so.1: /usr/local/mysql-standard-4.0.14-sun-solaris2.8-sparc-6) Any tip will be highly appreciable. Regards, Sagar, Sanjeev.vcf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL to syslog
I am not sure that MySQL can directly log to syslog but Unix provide this logger - make entries in the system log logger [-t tag] [-p pri] [-i] [-f file] [message...] So you use MysQL to put messages in a file and then use logger to send it to syslogs. This is how we do it too. Regards, -Original Message- From: Stephen Touset [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 10:28 AM To: [EMAIL PROTECTED] Subject: MySQL to syslog Is there now a way within MySQL to log to syslog? I was reading an archived email conversation between Sinisa Milivojevic and Vincent Stoessel in which they seemed to indicate that there was no need to log to syslog. As Vincent only had a request for timestamps in the error log, Sinisa simply satisfied that demand and moved on. However, I have a different need. I'm setting up several machines on a network, and wish for them all to send logs through stunneled syslog connections to a central logging server, where I can run logcheck et al to generate reports of system abuse and ensure that all services are running smoothly. However, with MySQL logging to it's own file, this presents a problem to me. Some solutions I can see are simply rsync'ing the logs over daily or mounting the directory over NFS and copying the logs. However, both of these require me to set up new services, and/or change already-existing firewall rules, and write new scripts to do the fetching/retrieval, all of which takes time and effort--not to mention, needlessly complicates the system. Have other people expressed a need to do this? I can't imagine that I'm the first person to run into this limitation, so all I can reason is that either a) the functionality's in there, and my Google skills have failed me, or b) there are valid reasons for the lack of inclusion, and there's a simple workaround. If either is the case, please, let me know! Thanks in advance. -- Stephen Touset [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error while using Mysqldump
Hello All, I am using Mysql 4.0.13-max-log on Solaris 2.8 If I run mysqldump like below /usr/local/mysql/bin/mysqldump -u root -pabc -d -r /usr/local/mysql/testbackup/schemadump.sql --all-databases It abort with following error /usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table 'address' (Can't open file: 'address.InnoDB'. (errno: 1)) But if I take out -u root -p option then it work fine. Also I don't have any table like address, see below | Tables | +---+ | ACCOMPANIEDTRAVEL | | ADVRESTKT | | AGENCYCALCULATE | | BASEFAREINFOTBL | | TABLE02 | | bench1| | bench_1 | | bench_10 | | bench_11 | | bench_12 | | bench_13 | | bench_14 | | bench_15 | | bench_16 | | bench_17 | | bench_18 | | bench_19 | | bench_2 | | bench_20 | | bench_21 | | bench_22 | | bench_23 | | bench_24 | | bench_3 | | bench_4 | | bench_5 | | bench_6 | | bench_7 | | bench_8 | | bench_9 | | testac| | testad| +---+ Am I missing anything here for root privilege. My login id is mysql, which owns the MySQL binaries. I have tried with different database and it's same behavior. Appreciate it. Sagar, Sanjeev.vcf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error while using Mysqldump
This issue is closed. THANKS ! -Original Message- From: Sagar, Sanjeev Sent: Wednesday, July 16, 2003 3:28 PM To: [EMAIL PROTECTED] Cc: Sagar, Sanjeev Subject: Error while using Mysqldump Hello All, I am using Mysql 4.0.13-max-log on Solaris 2.8 If I run mysqldump like below /usr/local/mysql/bin/mysqldump -u root -pabc -d -r /usr/local/mysql/testbackup/schemadump.sql --all-databases It abort with following error /usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table 'address' (Can't open file: 'address.InnoDB'. (errno: 1)) But if I take out -u root -p option then it work fine. Also I don't have any table like address, see below | Tables | +---+ | ACCOMPANIEDTRAVEL | | ADVRESTKT | | AGENCYCALCULATE | | BASEFAREINFOTBL | | TABLE02 | | bench1| | bench_1 | | bench_10 | | bench_11 | | bench_12 | | bench_13 | | bench_14 | | bench_15 | | bench_16 | | bench_17 | | bench_18 | | bench_19 | | bench_2 | | bench_20 | | bench_21 | | bench_22 | | bench_23 | | bench_24 | | bench_3 | | bench_4 | | bench_5 | | bench_6 | | bench_7 | | bench_8 | | bench_9 | | testac| | testad| +---+ Am I missing anything here for root privilege. My login id is mysql, which owns the MySQL binaries. I have tried with different database and it's same behavior. Appreciate it. File: Sagar, Sanjeev.vcf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysqlhotcopy usage problem
Hello All, I am facing following error while I am trying to use mysqlhotcopy utility for hot backups. I am not sure that how can I check the perl correct installation. Please see below [EMAIL PROTECTED]:/usr/local/mysql/bin mysqlhotcopy --help Can't locate DBI.pm in @INC (@INC contains: /opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi /opt/perl/lib/5.6.1 /opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi /opt/perl/lib/site_perl/5.6.1 /opt/perl/lib/site_perl .) at /usr/local/mysql/bin/mysqlhotcopy line 8. BEGIN failed--compilation aborted at /usr/local/mysql/bin/mysqlhotcopy line 8. My O/S is HP-UX 11 and My-SQL verion 4.0.9 Any help will be highly appreciated. Sanjeev Sagar EDS - My-SQL DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: copying
I tried mysqldump in past but it do come INSERT statement (with DATA). Is there any option if you just need schema. I might have missed it. Appreciate it, -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 9:51 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: copying use mysqldump to just dump the schema. Then edit the script to change the database name and pump it back into mysql. =C= * Cal Evans * http://www.christianperformer.com * Stay plugged into your audience * The measure of a programmer is not the number of lines of code he writes but the number of lines he does not have to write. * - Original Message - From: Darryl Hoar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 9:49 AM Subject: copying Greetings, in my last email nobody tackled the schema copy issue. Here is what I need to do: I have a live database that contains several tables. I need to create a history database with the same tables (without the data). I would like to do this without manually creating all the tables in the history db. Is there a more automated way to do this? thanks in advance, Darryl -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: copying
Please ignore my first mail. I got the answer in next email. Regards, -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 9:51 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: copying use mysqldump to just dump the schema. Then edit the script to change the database name and pump it back into mysql. =C= * Cal Evans * http://www.christianperformer.com * Stay plugged into your audience * The measure of a programmer is not the number of lines of code he writes but the number of lines he does not have to write. * - Original Message - From: Darryl Hoar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 9:49 AM Subject: copying Greetings, in my last email nobody tackled the schema copy issue. Here is what I need to do: I have a live database that contains several tables. I need to create a history database with the same tables (without the data). I would like to do this without manually creating all the tables in the history db. Is there a more automated way to do this? thanks in advance, Darryl -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql query output get wrapped
Try -E option or put \g in end of your sql statement like below Mysql -u id -ppasswd -E -e show innodb status OR Mysql -u id -ppasswd -e show innodb status \g I am not sure it is little g or capital G. Try both way. -Original Message- From: Asif Iqbal [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 10:27 AM To: [EMAIL PROTECTED] Subject: mysql query output get wrapped mysql select * from Tickets limit 1; ++-+---++++---+- --+-+---+--+--+- ---+--+-++-+ -+--+---+-+-+--- --+--+ | id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner | Subject | InitialPriority | FinalPriority | Priority | Status | TimeWorked | TimeLeft | Told| Starts | Started | Due | Resolved | LastUpdatedBy | LastUpdated | Creator | Created | Disabled | ++-+---++++---+- --+-+---+--+--+- ---+--+-++-+ -+--+---+-+-+--- --+--+ | 5 | 5 | 4 | ticket | NULL | NULL |16 | RE: phonebook | 10 |80 | 10 | resolved | 0 | NULL | 1970-01-01 00:00:00 | NULL | NULL| 1970-01-01 00:00:00 | NULL | 1 | 2001-04-17 18:38:02 | 1 | 2001-04-17 18:26:46 |0 | ++-+---++++---+- --+-+---+--+--+- ---+--+-++-+ -+--+---+-+-+--- --+--+ 1 row in set (0.00 sec) Is there a way I can get the output unwrapped something like this mysql select * from Tickets limit 1 \G *** 1. row *** id: 5 EffectiveId: 5 Queue: 4 Type: ticket IssueStatement: NULL Resolution: NULL Owner: 16 Subject: RE: phonebook InitialPriority: 10 FinalPriority: 80 Priority: 10 Status: resolved TimeWorked: 0 TimeLeft: NULL Told: 1970-01-01 00:00:00 Starts: NULL Started: NULL Due: 1970-01-01 00:00:00 Resolved: NULL LastUpdatedBy: 1 LastUpdated: 2001-04-17 18:38:02 Creator: 1 Created: 2001-04-17 18:26:46 Disabled: 0 1 row in set (0.00 sec) Except I want it Horizontally Thanks Asif -- -- 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]