Re: Upgrade glitches
Sebastien, please consult http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html. For InnoDB, the following is the most important upgrade note: " Upgrading: If you have stored characters < ASCII(32) to non-latin1 non-BINARY indexed columns in MySQL versions <= 4.1.2, then you have to rebuild those tables after you upgrade to >= 4.1.3. The reason is that the sorting order of those characters and the space character changes for some character sets in 4.1.3. See the MySQL/InnoDB-4.1.3 changelog for a precise description of the cases where you need to rebuild the table. " Also the behavior of LOCK TABLES with InnoDB has changed since 4.0.14. See http://dev.mysql.com/doc/mysql/en/News-4.1.7.html. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ - Original Message - From: "Sebastien Hould" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, November 04, 2004 2:05 AM Subject: Upgrade glitches Hi, I am about to upgrade from mysql-standard-4.0.14 to mysql-standard-4.1.7 on two Red Hat ES 3 server (master/slave circular relationship). I would like to know about any glitches I might face while doing so... Has anyone had any problems or bugs with any incompatible directives. Here is the config: [client] port= 3306 socket = /tmp/mysql.sock [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 256M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M max_connections=400 thread_concurrency = 8 log-bin server-id = 2 master-host = xxx.xxx.xxx.xxx master-user = nobody master-password = 123abc999 master-port = 3306 log-bin innodb_data_home_dir = /usr/local/mysql/data/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data/ innodb_log_arch_dir = /usr/local/mysql/data/ innodb_buffer_pool_size = 256M innodb_additional_mem_pool_size = 20M innodb_log_file_size = 64M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout -- 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: field name (1 and 2) causes error
oh, ok. thank you!
On Thu, 4 Nov 2004 01:16:21 -0600, Dan Nelson <[EMAIL PROTECTED]> wrote:
> In the last episode (Nov 04), Louie Miranda said:
>
>
> > I did create a table and a fieldname of 1 and 2. when i did enter
> > this query to insert on my sql, it causes error.
> >
> > insert into rates_fedex (weight_kg,a,b,c,d,e,f,g,h,1,2) values **
> >
> > error: ERROR 1064: You have an error in your SQL syntax. Check the
> > manual that corresponds to your MySQL server version for the right
> > syntax to use near '1,2) values
> > (".5","10.4","17.33","19.64","21.42","22.58","24.26
> >
> > How do we insert properly something on a field with that the name is
> > numbers? or that aint right, im wrong.
>
> Put backtics around any table or field name that might be misparsed by
> mysql. This lets you use numbers, spaces, or even reserved words:
>
> insert into rates_fedex (weight_kg,a,b,c,d,e,f,g,h,`1`,`2`) values
>
> If you look at the queries generated by myodbc, you'll see this a lot
> (it plays safe and quotes everything)
>
> --
> Dan Nelson
> [EMAIL PROTECTED]
>
--
Louie Miranda
http://www.axishift.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: field name (1 and 2) causes error
In the last episode (Nov 04), Louie Miranda said:
> I did create a table and a fieldname of 1 and 2. when i did enter
> this query to insert on my sql, it causes error.
>
> insert into rates_fedex (weight_kg,a,b,c,d,e,f,g,h,1,2) values **
>
> error: ERROR 1064: You have an error in your SQL syntax. Check the
> manual that corresponds to your MySQL server version for the right
> syntax to use near '1,2) values
> (".5","10.4","17.33","19.64","21.42","22.58","24.26
>
> How do we insert properly something on a field with that the name is
> numbers? or that aint right, im wrong.
Put backtics around any table or field name that might be misparsed by
mysql. This lets you use numbers, spaces, or even reserved words:
insert into rates_fedex (weight_kg,a,b,c,d,e,f,g,h,`1`,`2`) values
If you look at the queries generated by myodbc, you'll see this a lot
(it plays safe and quotes everything)
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
field name (1 and 2) causes error
I did create a table and a fieldname of 1 and 2.
when i did enter this query to insert on my sql, it causes error.
insert into rates_fedex (weight_kg,a,b,c,d,e,f,g,h,1,2) values **
error: ERROR 1064: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to use near '1,2) values
(".5","10.4","17.33","19.64","21.42","22.58","24.26
How do we insert properly something on a field with that the name is
numbers? or that aint right, im wrong.
--
Louie Miranda
http://www.axishift.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Out of my depth.
Right, I upgraded my version of MySQL last night after a lot of digging about, found a few bugs to do with table coruption that possibly could have been the problem. I am re-runing my script and its seems to be going fine this time. I am now using 4.0.28, I was using an early version of 4 can't remeber the exact version but it contained "gamma" in the version if that tracks it down. I actually changed my script to convert the table to InnoDB, do the inserts/selects/updates, convert back to MyISAM (As i need fulltext) then run myisamchk, it took about 3-4 hours longer than a pure MyISAM version. Hohum, John ___ Have your own email and web address for life. http://www.homemaster.net - Homemaster. Come Together. Online. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Undefined symbols compiling against 4.1.7 on Solaris 2.8
On a whim, I removed the --disable-shared from the configure options and was greeted by a lot of unresolved symbols from libz.a and this pleasant message: ld: fatal: relocations remain against allocatable but non-writable sections collect2: ld returned 1 exit status Google search says to use GNU ld, but that didn't help matters any. Right now, it's either (1) --disable-shared set, MySQL 4.1.7 completes the 'make' successfully but there are unresolved libmysqlclient.a symbols, or (2) --disable-shared NOT set and MySQL 4.1.7 fails during the make at the point where libtool is handling libmysqlclient.la Neither seems like fun to me. Anyone have any other ideas/pointers? --V V. M. Brasseur wrote: Unfortunately, the --disable-shared is intentional. For various reasons, our programs use static libraries whenever possible rather than dynamically linking. Do you think the LDFLAGS and/or --enable-libgcc still help for static libraries? Many thanks for your help so far, --V Ken Menzel wrote: I ran into problems trying to use static libraries on Solaris 9. I think you may not really want --disable-shared, the shared libs do make life a bit easier. But try these solutions: LDFLAGS="$LDFLAGS -L/usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.0/ -lgcc" or --enable-libgcc if you are using a recent gnu configure. This link the gcc lib with your program. I don't know what you are trying to link but here is a php reference. http://bugs.php.net/bug.php?id=16826&edit=1 - Original Message - From: "V. M. Brasseur" <[EMAIL PROTECTED]> To: "MySQL Listserv" <[EMAIL PROTECTED]> Sent: Wednesday, November 03, 2004 1:18 PM Subject: Undefined symbols compiling against 4.1.7 on Solaris 2.8 We're trying to get 4.1.7 to play nicely with our code, but something isn't cooperating. First of all, the MySQL installation: Version 4.1.7, compiled from source using GCC 3.3. The source compile is required because we need a lot of default settings to use our own paths. This is the configure used for the compile (some values altered here to protect the innocent): CC=gcc CFLAGS="-O3" \ CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \ ./configure --prefix=/path/to/mysql \ --libexecdir=/path/to/mysql/bin \ --with-mysqld-user=ouruser \ --with-unix-socket-path=/path/to/mysql.sock --with-tcp-port=ourport \ --without-docs --without-bench --with-extra-charsets=complex \ --enable-thread-safe-client --enable-local-infile \ --localstatedir=/path/to/mysql/data \ --with-prefix=/path/to/mysql \ --with-low-memory --enable-assembler --disable-shared It appears to function well on its own. However, when attempting to compile a program which requires libmysqlclient.a... compiling -o progname /path/to/progname.c Undefined first referenced symbol in file __floatdisf /path/to/mysql/lib/libmysqlclient.a(libmysql.o) __floatdidf /path/to/mysql/lib/libmysqlclient.a(libmysql.o) __cmpdi2 /path/to/mysql/lib/libmysqlclient.a(libmysql.o) ld: fatal: Symbol referencing errors. No output written to progname compile:error=256,command=compiling -o progname /path/to/progname.c It's worth noting that we are only experiencing this problem on Solaris 2.8. Another 4.1.7 installation on OSF1 5.1 is chugging along nicely with no complaints. Google contains many references to these undefined symbols, encountered mostly when compiling other products. Yet none of those references contain an actual SOLUTION to the problem. Could someone out there with a bit more ld/gcc/C API experience than I have (which is not setting the bar high, I assure you) lend a hand dispersing these clouds? Many thanks, --V -- 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]
Upgrade glitches
Hi, I am about to upgrade from mysql-standard-4.0.14 to mysql-standard-4.1.7 on two Red Hat ES 3 server (master/slave circular relationship). I would like to know about any glitches I might face while doing so... Has anyone had any problems or bugs with any incompatible directives. Here is the config: [client] port= 3306 socket = /tmp/mysql.sock [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 256M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M max_connections=400 thread_concurrency = 8 log-bin server-id = 2 master-host = xxx.xxx.xxx.xxx master-user = nobody master-password = 123abc999 master-port = 3306 log-bin innodb_data_home_dir = /usr/local/mysql/data/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data/ innodb_log_arch_dir = /usr/local/mysql/data/ innodb_buffer_pool_size = 256M innodb_additional_mem_pool_size = 20M innodb_log_file_size = 64M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrade - Downgrade problems
- Original Message - From: "Schalk Neethling" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 03, 2004 5:59 PM Subject: Upgrade - Downgrade problems > Since installing the latest 4.1 version of MySQL I have not been able to > run phpMyAdmin. > > I have since gathered that the current version of phpMyAdmin is not > compatible. I therefore ran Add/Remove programs on Windows and installed > 4.0.22 but nothing is working correctly, the server starts as a service > using NET START MySQL but, phpMyAdmin continues to say: | #2003 - The > server is not responding|. > > First, how can I detect, on localhost, which port MySQL is using? And > second, how can I ensure that everything related to MySQL, including the > app itself, is removed before making a clean install of MySQL 4.0.22. > > I would appreciate any help or pointers. I am on WindowsXP as the > development machine. > Windows records the ports used by each program or service in the 'services' file. On my XP machine, and presumably on yours, it is in the C:\Windows\system32\drivers\etc directory. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrade - Downgrade problems
Since installing the latest 4.1 version of MySQL I have not been able to run phpMyAdmin. I have since gathered that the current version of phpMyAdmin is not compatible. I therefore ran Add/Remove programs on Windows and installed 4.0.22 but nothing is working correctly, the server starts as a service using NET START MySQL but, phpMyAdmin continues to say: | #2003 - The server is not responding|. First, how can I detect, on localhost, which port MySQL is using? And second, how can I ensure that everything related to MySQL, including the app itself, is removed before making a clean install of MySQL 4.0.22. I would appreciate any help or pointers. I am on WindowsXP as the development machine. -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] Global: www.volume4.com We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Upgrade to 4.1.7 caused "Sort Aborted" errors
Haitao,
are you using MyISAM or InnoDB tables?
There were only two weeks between the 4.1.6 and 4.1.7 releases, and
filesort.cc was not modified at all in that time. The error 'Sort aborted'
comes if the sort function fails for some reason.
Can you find out what query is causing these errors?
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
filesort.cc:
err:
if (param.tmp_buffer)
x_free(param.tmp_buffer);
x_free((gptr) sort_keys);
x_free((gptr) buffpek);
close_cached_file(&tempfile);
close_cached_file(&buffpek_pointers);
if (my_b_inited(outfile))
{
if (flush_io_cache(outfile))
error=1;
{
my_off_t save_pos=outfile->pos_in_file;
/* For following reads */
if (reinit_io_cache(outfile,READ_CACHE,0L,0,0))
error=1;
outfile->end_of_file=save_pos;
}
}
if (error)
my_error(ER_FILSORT_ABORT,MYF(ME_ERROR+ME_WAITTANG));
else
statistic_add(filesort_rows, (ulong) records, &LOCK_status);
*examined_rows= param.examined_rows;
#ifdef SKIP_DBUG_IN_FILESORT
DBUG_POP(); /* Ok to DBUG */
#endif
DBUG_PRINT("exit",("records: %ld",records));
DBUG_RETURN(error ? HA_POS_ERROR : records);
} /* filesort */
- Original Message -
From: "Haitao Jiang" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 03, 2004 11:06 PM
Subject: Upgrade to 4.1.7 caused "Sort Aborted" errors
Hi,
We were using MySQL 4.1.6g without this kind of error, but after we
upgrade to 4.1.7, we are having following errors:
041103 9:35:35 [ERROR] /var/opt/mysql4/11000/pkgroot/bin/mysqld: Sort
aborted
041103 9:35:35 [ERROR] /var/opt/mysql4/11000/pkgroot/bin/mysqld: Sort
aborted
What do these mean? How to fix it? Is it a bug? I just wondering if
anyone has upgraded to 4.1.7 and has seen these errors.
Thanks so much!
Haitao
--
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: slashes in update statement
Do you use POST or GET in the form? Try with a post. Santino At 8:31 -0500 3-11-2004, Ed Curtis wrote: I'm trying to get a slash in a variable into my database and am having some trouble. If the variable = "1 1/2" it echoes to the screen correctly but it seems to strip the 1/2 off the variable when updating the value to the database. I'm using php and a form select list to get this value from a previous page. Any ideas? Thanks, Ed -- 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: Fulltext search Strategy - Need Help
Search '+ford +focus' [in boolean mode] Santino At 13:22 + 3-11-2004, Lee Denny wrote: Hello, I'm doing fairly straight forward fulltext searches, but I want to nest them - basically do a keyword search on 'phrase 1' and then search the results this returns for 'phrase 2', for example if phrase 1 is 'ford' and phrase 2 is 'focus' - I search once for 'ford' and then go through the record-set this returns for 'focus'. My first thought is use a temporary table - but is there a way of doing this with one query? Cheers, lee -- 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: Undefined symbols compiling against 4.1.7 on Solaris 2.8
Unfortunately, the --disable-shared is intentional. For various reasons, our programs use static libraries whenever possible rather than dynamically linking. Do you think the LDFLAGS and/or --enable-libgcc still help for static libraries? Many thanks for your help so far, --V Ken Menzel wrote: I ran into problems trying to use static libraries on Solaris 9. I think you may not really want --disable-shared, the shared libs do make life a bit easier. But try these solutions: LDFLAGS="$LDFLAGS -L/usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.0/ -lgcc" or --enable-libgcc if you are using a recent gnu configure. This link the gcc lib with your program. I don't know what you are trying to link but here is a php reference. http://bugs.php.net/bug.php?id=16826&edit=1 - Original Message - From: "V. M. Brasseur" <[EMAIL PROTECTED]> To: "MySQL Listserv" <[EMAIL PROTECTED]> Sent: Wednesday, November 03, 2004 1:18 PM Subject: Undefined symbols compiling against 4.1.7 on Solaris 2.8 We're trying to get 4.1.7 to play nicely with our code, but something isn't cooperating. First of all, the MySQL installation: Version 4.1.7, compiled from source using GCC 3.3. The source compile is required because we need a lot of default settings to use our own paths. This is the configure used for the compile (some values altered here to protect the innocent): CC=gcc CFLAGS="-O3" \ CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \ ./configure --prefix=/path/to/mysql \ --libexecdir=/path/to/mysql/bin \ --with-mysqld-user=ouruser \ --with-unix-socket-path=/path/to/mysql.sock --with-tcp-port=ourport \ --without-docs --without-bench --with-extra-charsets=complex \ --enable-thread-safe-client --enable-local-infile \ --localstatedir=/path/to/mysql/data \ --with-prefix=/path/to/mysql \ --with-low-memory --enable-assembler --disable-shared It appears to function well on its own. However, when attempting to compile a program which requires libmysqlclient.a... compiling -o progname /path/to/progname.c Undefined first referenced symbol in file __floatdisf /path/to/mysql/lib/libmysqlclient.a(libmysql.o) __floatdidf /path/to/mysql/lib/libmysqlclient.a(libmysql.o) __cmpdi2 /path/to/mysql/lib/libmysqlclient.a(libmysql.o) ld: fatal: Symbol referencing errors. No output written to progname compile:error=256,command=compiling -o progname /path/to/progname.c It's worth noting that we are only experiencing this problem on Solaris 2.8. Another 4.1.7 installation on OSF1 5.1 is chugging along nicely with no complaints. Google contains many references to these undefined symbols, encountered mostly when compiling other products. Yet none of those references contain an actual SOLUTION to the problem. Could someone out there with a bit more ld/gcc/C API experience than I have (which is not setting the bar high, I assure you) lend a hand dispersing these clouds? Many thanks, --V -- 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++ header files
Spenser wrote: I'm trying to use the C++ API (a.k.a. MySQL++). There's a mailing list dedicated to MySQL++. If you were subscribed, you would have seen the messages announcing the changes that are causing you problems. The on-line manual ...is badly outdated. when I downloaded the latest version of MySQL++ (1.7.19-1 for RedHat 9) from mysql.com, Actually, you didn't download it from mysql.com. You downloaded it from my site, tangentsoft.net. The only resource MySQL AB is giving to MySQL++ now is the mailing list. And redirection from their old links to my site, of course. :) Has sqlplus.hh been replaced? Yes, a fact mentioned in the library's ChangeLog. What's the deal? The deal is that there's a lot of legacy crud in the library dating back to the days when MySQL++ was supposed to be some kind of cross-database library. Under my maintainership, this is being excised...MySQL++ has always been MySQL-specific, and I am committed to removing any illusion to the contrary within the library code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrade to 4.1.7 caused "Sort Aborted" errors
Hi, We were using MySQL 4.1.6g without this kind of error, but after we upgrade to 4.1.7, we are having following errors: 041103 9:35:35 [ERROR] /var/opt/mysql4/11000/pkgroot/bin/mysqld: Sort aborted 041103 9:35:35 [ERROR] /var/opt/mysql4/11000/pkgroot/bin/mysqld: Sort aborted What do these mean? How to fix it? Is it a bug? I just wondering if anyone has upgraded to 4.1.7 and has seen these errors. Thanks so much! Haitao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fault-tolerant replication ring in MySQL
On Wednesday 03 November 2004 02:43 pm, Mark Hennessy wrote: > I have three mail servers, on each is a MySQL DBMS. I want to set up a > replication ring between the three MySQL DBMS on these machines so they > will constantly share the same data in near real-time. But, the chance > exists that any one of those three mail servers may be completely down or > have services disabled including the MySQL DBMS. Is there a way for the > other two MySQL DBMS to continue to replicate to each other if the third is > down without manual attention? Not that I am aware of.. That would be a multi master type situation.. Thats a 5.x feature that suppose to be added. Jeff pgp6dWXXCLanp.pgp Description: PGP signature
Fault-tolerant replication ring in MySQL
I have three mail servers, on each is a MySQL DBMS. I want to set up a replication ring between the three MySQL DBMS on these machines so they will constantly share the same data in near real-time. But, the chance exists that any one of those three mail servers may be completely down or have services disabled including the MySQL DBMS. Is there a way for the other two MySQL DBMS to continue to replicate to each other if the third is down without manual attention? -- Mark Hennessy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql 4.1.7 Text truncates at first extended character on insert
We are in the process of upgrading our installation of MySQL 4.0 to 4.1.7 and are having an issue in our testing. We have an internal CMS that was developed with MySQL 4.0 and PHP. We very often insert Text with extended characters (trademark, copyright, registered, etc) into latin1 tables with no problem. After converting the tables to utf8 in mysql 4.1 with "ALTER TABLE table_name type=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin" Whenever we try to insert Text, it will insert up to the first extended character and then truncate the extended character to the end. It exhibits the same behavior in CHAR, VARCHAR and TEXT fields. I'm sure this is a configuration problem on my part, but I have searched google, mysql.com and the archives but have not found any information. If someone has any information or could point me in the right direction, I would greatly appreciate it. This is running on WindowsXP with apache 2.0.52 and PHP 4.3.9. BTW, it is not only from PHP that this happens. It does exactly the same thing when the query is run from MySQLCC and the MySQL Query Browser. I have also tried pasting the text into the MySQLCC text field editor and it appears the field will not store those characters (although I assume that mysqlcc is just running a query in the background so it wouldn't work) HELP!!! Thanks in advance. -- :: Keith Morris :: Creative Director :: Design / Effects :: IQ television group :: Atlanta, GA :: 404.255.3550 :: http://www.iqtv.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ANNOUNCE: MySQL Query Browser 1.1.0 and Administrator 1.0.14 released
Hi Yves, Administrator is intended for server maintenance and configuration, while with Query Browser you execute SQL queries and do related SQL scripting work. As a set, they do the same as mysqlcc, but are much better (we hope). MySQLCC will be replaced by Administrator and Query Browser and will be phased out in the near future. -- Alfredo Kojima, GUI Developer MySQL AB, www.mysql.com Buenos Aires, Argentina Are you MySQL certified? www.mysql.com/certification On Wed, 3 Nov 2004, Yves Goergen wrote: > On 03.11.2004 04:17 (+0200), Alfredo Kengi Kojima wrote: > > MySQL Administrator is a GUI management console for MySQL, > > with support for tasks such as managing users, > > configuring MySQL, editing table definitions etc. > > Ehm - what please is the difference between MySQLCC and MySQL > Administrator? And what is Query Browser again? It's confusing to have > three products that all do the same. > > -- > Yves Goergen <[EMAIL PROTECTED]> > > BlackBoard Internet Newsboard System --> blackboard.unclassified.de > Free (GPL), easy to use and install, secure, innovative! (PHP+MySQL) > > -- > 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]
SELECT or SHOW full table name?
I don't see a way to ask MySQL what the "full" name of a table is... the equivalent of this: SELECT CONCAT(DATABASE(), ".", "table_name") which would return something like this (assuming the current database is called "my_database": my_database.table_name The reason I want this is to ensure that a scripted operation isn't treating the same table as if it were two different tables. I have a method that moves records among tables by copying and then deleting. If the two tables are really the same table, it'll lose the records, since it will have copied them to the same table, then delete them. I can do it the way above, but I'm thinking there might be a better way... Thanks! Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql does not respond
Hello, MySQL Gurus, I have a mysql server (4.0.20) that has been flaky these days. I can't connect to it by 'mysql -p' or shutdown thru mysqladmin. It just hangs there forever without doing anything. I tried to 'ps -Aef | grep mysql' and sees nothing but the mysqld_safe and the mysqld_max thread initiated by mysqld_safe, and of course, the mysqladmin thread to shutdown mysql as it just hangs in there, ie, no client connected to mysql server that is preventing it from termination. Can anyone give me some help on this? Is there anyway I can find out what is going on in there or shut it down cleanly without having to worry about having defective files? Thanks a lot -- ginger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL++ header files
For the archives: Well, I may be onto my own solution to why I can't find sqlplus.hh. As of version 1.7.11, sqlplus.hh is now called mysql++.hh. This was announced on August 17, 2004. Of course, I'm still having problems getting that header file to work, but at least I have a fighting chance. On Wed, 2004-11-03 at 01:07, Spenser wrote: > I'm trying to use the C++ API (a.k.a. MySQL++). The on-line manual and > some of the books that I have say to include the file sqlplus.hh for > connecting to MySQL. However, when I downloaded the latest version of > MySQL++ (1.7.19-1 for RedHat 9) from mysql.com, it didn't seem to > include sqlplus.hh in the directory /usr/include/mysql++ or in any other > directory that I can find. Has sqlplus.hh been replaced? Do I use the > other header files in /usr/include/mysql++ instead? What's the deal? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Undefined symbols compiling against 4.1.7 on Solaris 2.8
We're trying to get 4.1.7 to play nicely with our code, but something isn't cooperating. First of all, the MySQL installation: Version 4.1.7, compiled from source using GCC 3.3. The source compile is required because we need a lot of default settings to use our own paths. This is the configure used for the compile (some values altered here to protect the innocent): CC=gcc CFLAGS="-O3" \ CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \ ./configure --prefix=/path/to/mysql \ --libexecdir=/path/to/mysql/bin \ --with-mysqld-user=ouruser \ --with-unix-socket-path=/path/to/mysql.sock --with-tcp-port=ourport \ --without-docs --without-bench --with-extra-charsets=complex \ --enable-thread-safe-client --enable-local-infile \ --localstatedir=/path/to/mysql/data \ --with-prefix=/path/to/mysql \ --with-low-memory --enable-assembler --disable-shared It appears to function well on its own. However, when attempting to compile a program which requires libmysqlclient.a... compiling -o progname /path/to/progname.c Undefined first referenced symbol in file __floatdisf /path/to/mysql/lib/libmysqlclient.a(libmysql.o) __floatdidf /path/to/mysql/lib/libmysqlclient.a(libmysql.o) __cmpdi2 /path/to/mysql/lib/libmysqlclient.a(libmysql.o) ld: fatal: Symbol referencing errors. No output written to progname compile:error=256,command=compiling -o progname /path/to/progname.c It's worth noting that we are only experiencing this problem on Solaris 2.8. Another 4.1.7 installation on OSF1 5.1 is chugging along nicely with no complaints. Google contains many references to these undefined symbols, encountered mostly when compiling other products. Yet none of those references contain an actual SOLUTION to the problem. Could someone out there with a bit more ld/gcc/C API experience than I have (which is not setting the bar high, I assure you) lend a hand dispersing these clouds? Many thanks, --V -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Windows 2000 and don't get connect with MySQL Administrator.
Hi. See: http://dev.mysql.com/doc/mysql/en/Problems_with_character_sets.html http://dev.mysql.com/doc/mysql/en/Cannot_initialize_character_set.html Svein Kristiansen <[EMAIL PROTECTED]> wrote: > ! use MySQL 4.1 in Windows 2000 and don't get connect with MySQL > Administrator. > > The message what get is: > Could not connect to the specified host. > MySQL Error Nr.1115 > Unknown character set: 'utf8' > > Details of the my connection: > Username: root > Password: > Hostname: localhost > Port: 3306 > > Someone can help me? > > Thanks in advance, > > > Med vennlig hilsen > Svein Kristiansen > > ErgoSolutions AS > Postboks 4364 Nydalen, 0402 Oslo > Telefon 99 24 69 75 Telefaks 23 14 50 01 > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL and partitions
Hi. By using DATA DIRECTORY='directory' or INDEX DIRECTORY='directory' in CREATE TABLE clause, you can specify where the MyISAM storage engine should put table's data and index file[s]. See: http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html Also,you may use 'datadir' server variable. See: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html Yves Arsenault <[EMAIL PROTECTED]> wrote: > Hello all, > > I have MySQL installed on a Mandrake Linux system, it is installed on > the /usr partition. > > I was wondering, is it possible to store some databases on the /var > partition while MySQL is installed on the /usr partition? > > And, if it is possible, can you store DB_A on /usr and DB_B on /var > (or at least 2 different partitions). > > Thanks, > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: .MYD, .MYI files don't exist... but queries WORK??????
Hi. > is "Where does InnoDB data get stored?" > table type since it describes it as "default">" Use: show variables like '%innodb_data%'; show variables like 'storage_engine'; Anders Green <[EMAIL PROTECTED]> wrote: > Sequence of events: > -had an MS Access db > -converted it to MySQL 4.1.7 with a utility > -everything worked > -using MySQL Query Browser 1.0.1, added three tables > -everything worked > -comes time to deploy to another machine for testing, > copy directory of database over to other machine > -any queries involving the three new tables fail: > mysql> select * from admin; > ERROR 1016 (HY000): Can't open file: 'admin.InnoDB' (errno: 1) > > Now, the first thing to do is go looking for files. > What I find shocks and amazes me! There are missing > files! *grin* > > For each of the three new tables, there is a .frm > file, but no .myd or myi file. Okay. transfer > aborted or something I'll go back to the first > development machine and copy them over. > > WAIT A SECOND! They don't exist on the first > development machine either! And yet, queries > on the first development machine are working, > and those files are nowhere to be found on the > entire drive. > > Ok, I was about to add some info about the > table types... and with the query browser > on the first machine, I saw that they were > all InnoDB instead of MyISAM. Changing those > to MyISAM created the files. Copied those > over to the other machine, restarted the > server there, and they work. > > So now my question (which might be "Why does > the query browser not select MyISAM as the > table type since it describes it as "default">", > or might be "why is my junk not working?") > is "Where does InnoDB data get stored?" > > That is, in what file and what location? > Cause now I'm curious. :) > > Cheers, > Anders > +===+ > |Anders Green Email: [EMAIL PROTECTED] | > | Home: 919.303.0218 | > |Off Road Rally Racing Team: http://LinaRacing.com/ | > +===+ > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: slashes in update statement
Hi. What type of the field in which you insert? Send us output of SHOW CREATE TABLE 'table'. Ed Curtis <[EMAIL PROTECTED]> wrote: > > I'm trying to get a slash in a variable into my database and am having > some trouble. If the variable = "1 1/2" it echoes to the screen correctly > but it seems to strip the 1/2 off the variable when updating the value to > the database. I'm using php and a form select list to get this value from > a previous page. Any ideas? > > Thanks, > > Ed > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL and partitions
Thanks to all of you who replied. Yves On Wed, 3 Nov 2004 13:57:33 + (GMT), andy thomas <[EMAIL PROTECTED]> wrote: > On Wed, 3 Nov 2004, Yves Arsenault wrote: > > > Thanks for the reply, > > > > Is there any information on the mysql.com website on how to store data > > on 2 separate partitions? > > I'm not sure but you can use symbolic links to make databases in different > partitions appear to be under the one that mysql uses. For example, > suppose that on your system, the database DB_A is under /usr and database > DB_B is uder /var - mysql can see /usr/DB_A but not /var/DB_B. But if you > symbilically link /var/DB_B to /usr/DB_B with: > > ln -s /var/DB_B /usr/DB_B > > then mysql can see and use DB_B. Of course, you also need to be sure mysql > has permissions to read and write to DB_B in /var. > > Hope this helps, > > Andy > > > > > On Wed, 3 Nov 2004 13:21:59 + (GMT), andy thomas <[EMAIL PROTECTED]> wrote: > > > On Wed, 3 Nov 2004, Yves Arsenault wrote: > > > > > > > Hello all, > > > > > > > > I have MySQL installed on a Mandrake Linux system, it is installed on > > > > the /usr partition. > > > > > > > > I was wondering, is it possible to store some databases on the /var > > > > partition while MySQL is installed on the /usr partition? > > > > > > Yes. In fact, somewhere under the /var tree is the usual place for mysql > > > databases to reside in many installations. > > > > > > > And, if it is possible, can you store DB_A on /usr and DB_B on /var > > > > (or at least 2 different partitions). > > > > > > You can although current thinking in the UNIX/Linux world is that the > > > /usr filesystem should be read-only, which means files & directories that > > > change all the time shouldn't be under /usr. But older UNIXes and Linuxes > > > commonly use /usr/var, /usr/tmp and /usr/var/tmp for holding changing data > > > so it's really up to you. If the databases are big and/or heavily used, I > > > tend to put them on their own /mysql partition or even on their own fast > > > disk. /home/mysql or /export/home/mysql is another possibility. > > > > > > Andy > > > > > > > > > > > > -- > > Yves Arsenault > > > > -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ANNOUNCE: MySQL Query Browser 1.1.0 and Administrator 1.0.14 released
Trying to build from IDE. Unicode Editor will not compile because of missing StringContainers.dcu Where can find StringContainers unit? Thanks - Original Message - From: "Alfredo Kengi Kojima" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 02, 2004 7:17 PM Subject: ANNOUNCE: MySQL Query Browser 1.1.0 and Administrator 1.0.14 released > > MySQL Query Browser 1.1.0 Gamma and MySQL Administrator 1.0.14 have just > been released for Windows and Linux. > > This is the first gamma release of Query Browser, a graphical query shell > and SQL script editor. Feature highlights: > > - perform queries and edit resultsets; > - export resultsets to CSV, HTML and XML; > - syntax highlighting SQL script editor; > - query bookmarks and history, allowing easy retrieval of often used > queries; > - compare query results side-by-side; > - create master-detail queries. Select a row in one resultset and update > a second query, using values from the selectd row; > - much more > > This release contains an extensive list of improvements, most notably > the support for MySQL 5 features, such as Stored Procedures, Functions > and Views: > > - support for stored procedures which return multiple resultsets > - support for creating and editing Stored Procedures, Functions and Views > - many UI improvements > > > MySQL Administrator is a GUI management console for MySQL, > with support for tasks such as managing users, > configuring MySQL, editing table definitions etc. > > More details in: > > http://www.mysql.com/products/administrator/ > > This version fixes some bugs and contains some improvements. > > > Both tools are freely available under the GPL and can be downloaded in > binary or source forms, for Windows and Linux, from: > > http://dev.mysql.com/downloads/administrator/ > > and > > http://dev.mysql.com/downloads/query-browser/ > > > Note that not all mirror sites may be up-to-date at this point. If you > cannot find this version on a particular mirror, please try again later or > choose another download site. > > > -- > Alfredo Kojima, GUI Developer > MySQL AB, www.mysql.com > Buenos Aires, Argentina > > Are you MySQL certified? www.mysql.com/certification > > -- > 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: Production instances down - MySQL got signal 11
All - I got my answers. Thanks. -Original Message- From: [EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 10:18 AM To: Mysql General (E-mail) Subject: RE: Production instances down - MySQL got signal 11 All I have discovered that I had a memory problem on this server which caused the crash. I reduced the initial memory requirements for Innodb and now it is running. I am curious why it crashed in the first place. If anyone has insight on this, I world appreciate hearing it... Thanks - Gabe -Original Message- From: [EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 8:58 AM To: Mysql General (E-mail) Subject: Production instances down - MySQL got signal 11 Hi all I am on Solaris 8 using mysql.4.0.16 standard. My instances crashed with the following in the .err file: 041103 07:44:16 mysqld started 041103 7:44:17 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 4 3285189691 InnoDB: Doing recovery: scanned up to log sequence number 4 3285189691 InnoDB: Fatal error: cannot allocate 2213656 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 371642468 bytes. Operating system errno: 11 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. InnoDB: We now intentionally generate a seg fault so that InnoDB: on Linux we get a stack trace. 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=16777216 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 = 80383 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 041103 07:44:18 mysqld ended I have about 2 gig of filesystem space left. I don't believe that to be an issue. However, I was able to get it up for about 15 minutes when I purged some old binary logs. Any help would be greatly appreciated. Thanks - Gabe <><><><><><><><><><><><><><><><><><><><><> "There are no problems, only solutions." Gabe Tucker Bloomberg LP (609) 750 6668 - P (646) 268 5681 - F <><><><><><><><><><><><><><><><><><><><><> -- 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: .MYD, .MYI files don't exist... but queries WORK??????
On Wed, 3 Nov 2004, Anders Green wrote: > Tobias Asplund wrote: > >If you installed MySQL 4.1.7 on Windows with the new installer > > Yes I did. > > >it will automatically use InnoDB tables as the default > > Ah ha. Thanks. :) > > > That just leaves this: > > > > So now my question "Where does InnoDB data get stored?" You'll probably see some files in your data\ directory under your MySQL directory named something like 'ibdata1'. InnoDB stores all its data in a tablespace, so there won't (by default) be more than the .frm file per table (as of 4.1 you can override this with --innodb-file-per-table) You can read more about this here: http://dev.mysql.com/doc/mysql/en/InnoDB.html > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INTERSECT in mysql
On Wed, 3 Nov 2004, Chaitra Yale wrote: > ...how can union be the same as intersect..iam trying to get the names > of comapnies that are in both queries.for example the first query > gives me companies A, B AND C and the second query gives A , B..i want > the intersect of these 2 queriesso i get companies A and B...if i > did a union i will get A, B and C Could use the union in a subquery together with a HAVING COUNT(*) on the outside. SELECT * FROM ( SELECT DISTINCT col1 FROM t1 WHERE... UNION ALL SELECT DISTINCT col1 FROM t1 WHERE... ) AS tbl GROUP BY tbl.col1 HAVING COUNT(*) = 2 Or something... not sure how well that would performe, however. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INTERSECT in mysql
Wouldn't SELECT p.csymbol FROM tblavgPrice p JOIN tblAssets a ON p.csymbol = a.csymbol WHERE p.avg > 1 AND p.avg < 10 AND a.assets > 100 AND a.assets < 500 do what you want? Michael Chaitra Yale wrote: ...how can union be the same as intersect..iam trying to get the names of comapnies that are in both queries.for example the first query gives me companies A, B AND C and the second query gives A , B..i want the intersect of these 2 queriesso i get companies A and B...if i did a union i will get A, B and C On Wed, 3 Nov 2004 09:13:08 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Assuming you have access to MySQL 4.0+ select csymbol from tblavgPrice where avg > 1 and avg < 10 UNION select csymbol from tblAssets where assets > 100 and assets < 500 Unless you say UNION ALL, you won't get duplicate values. For more details: http://dev.mysql.com/doc/mysql/en/UNION.html Just out of curiosity and because this is not the first time the INTERSECT question has come up. What SQL dialect are you coming from? IF you are using a MySQL server that is pre-4.0+, you will have to recode that query using any of several variations that use a temporary table. Let me know if you need that work-around. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Chaitra Yale <[EMAIL PROTECTED]> wrote on 11/03/2004 02:12:42 AM: hi i have a problem mysql doesnt seem to support the intersect can somebody help how i can write the followoing code in mysql select csymbol from tblavgPrice where avg > 1 and avg < 10 intersect select csymbol from tblAssets where assets > 100 and assets < 500 thanks -- 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]
[Fwd: Re: Production instances down - MySQL got signal 11]
Hey Gabe, I saw that this came through the public lists - the you might want to just post to support as it's more than covered by your contract. My own take is that you've got an OS issue allocating disk space. According to perror, error 11 is "Resource temporarily unavailable". I actually hit this recently and found out that my PATH was picking up some different mysql libraries instead of my intended installed version (but then, my laptop is a rats nest of alternate mysql environments). let me know if I can help, Philip -- Philip Antoniades, Senior Consultant MySQL AB, www.mysql.com Office: +1 718 909 4549 "The open source movement has become a major force across the software industry, and MySQL is the world's most popular open source database." Fortune Magazine signature.asc Description: This is a digitally signed message part
Re: ANNOUNCE: MySQL Query Browser 1.1.0 and Administrator 1.0.14 released
On Wednesday 03 November 2004 09:59 am, Yves Goergen wrote: > Ehm - what please is the difference between MySQLCC and MySQL > Administrator? And what is Query Browser again? It's confusing to have > three products that all do the same. No, they are not all the same.. MySQLCC is depricated.. MySQL Administrator is geared towards dba's of mysql.. MySQL Query Browser, is to run sql's, and so forth. Stored procedure creation.. They are very different if you had read the product descriptions. Jeff pgpRJjCrqe5K9.pgp Description: PGP signature
Re: ANNOUNCE: MySQL Query Browser 1.1.0 and Administrator 1.0.14 released
On 03.11.2004 04:17 (+0200), Alfredo Kengi Kojima wrote: MySQL Administrator is a GUI management console for MySQL, with support for tasks such as managing users, configuring MySQL, editing table definitions etc. Ehm - what please is the difference between MySQLCC and MySQL Administrator? And what is Query Browser again? It's confusing to have three products that all do the same. -- Yves Goergen <[EMAIL PROTECTED]> BlackBoard Internet Newsboard System --> blackboard.unclassified.de Free (GPL), easy to use and install, secure, innovative! (PHP+MySQL) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INTERSECT in mysql
...how can union be the same as intersect..iam trying to get the names of comapnies that are in both queries.for example the first query gives me companies A, B AND C and the second query gives A , B..i want the intersect of these 2 queriesso i get companies A and B...if i did a union i will get A, B and C On Wed, 3 Nov 2004 09:13:08 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Assuming you have access to MySQL 4.0+ > > select csymbol from tblavgPrice where avg > 1 and avg < 10 > UNION > select csymbol from tblAssets where assets > 100 and assets < 500 > > Unless you say UNION ALL, you won't get duplicate values. > For more details: http://dev.mysql.com/doc/mysql/en/UNION.html > > Just out of curiosity and because this is not the first time the INTERSECT > question has come up. What SQL dialect are you coming from? > > IF you are using a MySQL server that is pre-4.0+, you will have to recode > that query using any of several variations that use a temporary table. Let > me know if you need that work-around. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > > Chaitra Yale <[EMAIL PROTECTED]> wrote on 11/03/2004 02:12:42 AM: > > > > > hi > > > > i have a problem mysql doesnt seem to support the intersect can > > somebody help how i can write the followoing code in mysql > > > > select csymbol from tblavgPrice where avg > 1 and avg < 10 > > intersect > > select csymbol from tblAssets where assets > 100 and assets < 500 > > > > thanks > > > > -- > > 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: Production instances down - MySQL got signal 11
All I have discovered that I had a memory problem on this server which caused the crash. I reduced the initial memory requirements for Innodb and now it is running. I am curious why it crashed in the first place. If anyone has insight on this, I world appreciate hearing it... Thanks - Gabe -Original Message- From: [EMAIL PROTECTED] Sent: Wednesday, November 03, 2004 8:58 AM To: Mysql General (E-mail) Subject: Production instances down - MySQL got signal 11 Hi all I am on Solaris 8 using mysql.4.0.16 standard. My instances crashed with the following in the .err file: 041103 07:44:16 mysqld started 041103 7:44:17 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 4 3285189691 InnoDB: Doing recovery: scanned up to log sequence number 4 3285189691 InnoDB: Fatal error: cannot allocate 2213656 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 371642468 bytes. Operating system errno: 11 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. InnoDB: We now intentionally generate a seg fault so that InnoDB: on Linux we get a stack trace. 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=16777216 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 = 80383 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 041103 07:44:18 mysqld ended I have about 2 gig of filesystem space left. I don't believe that to be an issue. However, I was able to get it up for about 15 minutes when I purged some old binary logs. Any help would be greatly appreciated. Thanks - Gabe <><><><><><><><><><><><><><><><><><><><><> "There are no problems, only solutions." Gabe Tucker Bloomberg LP (609) 750 6668 - P (646) 268 5681 - F <><><><><><><><><><><><><><><><><><><><><> -- 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]
Windows 2000 and don't get connect with MySQL Administrator.
! use MySQL 4.1 in Windows 2000 and don't get connect with MySQL Administrator. The message what get is: Could not connect to the specified host. MySQL Error Nr.1115 Unknown character set: 'utf8' Details of the my connection: Username: root Password:Hostname: localhost Port: 3306 Someone can help me? Thanks in advance, Med vennlig hilsen Svein Kristiansen ErgoSolutions AS Postboks 4364 Nydalen, 0402 Oslo Telefon 99 24 69 75 Telefaks 23 14 50 01 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error with phpMyAdmin and MySQL 4.1.7
hi, I've just installed MySQL 4.1.7 when I try to launch phpMyAdmin I see this: Witamy w phpMyAdmin 2.5.5-pl1 phpMyAdmin próbowal polaczyc sie z serwerem MySQL, a serwer odrzucil polaczenie. Powinienes sprawdzic nazwe hosta, nazwe uzytkownika i haslo w pliku config.inc.php i upewnic sie, ze odpowiadaja one informacjom danym przez administratora serwera MySQL. Warning: Cannot modify header information - headers already sent by (output started at E:\www_files\phpmyadmin\libraries\auth\config.auth.lib.php:96) in E:\www_files\phpmyadmin\libraries\header_http.inc.php on line 14 Warning: Cannot modify header information - headers already sent by (output started at E:\www_files\phpmyadmin\libraries\auth\config.auth.lib.php:96) in E:\www_files\phpmyadmin\libraries\header_http.inc.php on line 15 Warning: Cannot modify header information - headers already sent by (output started at E:\www_files\phpmyadmin\libraries\auth\config.auth.lib.php:96) in E:\www_files\phpmyadmin\libraries\header_http.inc.php on line 16 Warning: Cannot modify header information - headers already sent by (output started at E:\www_files\phpmyadmin\libraries\auth\config.auth.lib.php:96) in E:\www_files\phpmyadmin\libraries\header_http.inc.php on line 17 Warning: Cannot modify header information - headers already sent by (output started at E:\www_files\phpmyadmin\libraries\auth\config.auth.lib.php:96) in E:\www_files\phpmyadmin\libraries\header_http.inc.php on line 20 Serwer localhost Blad MySQL zwrócil komunikat: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client [Dokumentacja] in config.inc.php I have: $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = 'my_password';// MySQL password (only needed // with 'config' auth_type) I also have MySQL Connector/ODBC 3.51 installed [windows 2000, php 5] when I earlier installed MySQL 5 beta it worked good... what's wrong and how to correct this? with regards DeRyl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INTERSECT in mysql
Assuming you have access to MySQL 4.0+ select csymbol from tblavgPrice where avg > 1 and avg < 10 UNION select csymbol from tblAssets where assets > 100 and assets < 500 Unless you say UNION ALL, you won't get duplicate values. For more details: http://dev.mysql.com/doc/mysql/en/UNION.html Just out of curiosity and because this is not the first time the INTERSECT question has come up. What SQL dialect are you coming from? IF you are using a MySQL server that is pre-4.0+, you will have to recode that query using any of several variations that use a temporary table. Let me know if you need that work-around. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Chaitra Yale <[EMAIL PROTECTED]> wrote on 11/03/2004 02:12:42 AM: > hi > > i have a problem mysql doesnt seem to support the intersect can > somebody help how i can write the followoing code in mysql > > select csymbol from tblavgPrice where avg > 1 and avg < 10 > intersect > select csymbol from tblAssets where assets > 100 and assets < 500 > > thanks > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] >
Production instances down - MySQL got signal 11
Hi all I am on Solaris 8 using mysql.4.0.16 standard. My instances crashed with the following in the .err file: 041103 07:44:16 mysqld started 041103 7:44:17 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 4 3285189691 InnoDB: Doing recovery: scanned up to log sequence number 4 3285189691 InnoDB: Fatal error: cannot allocate 2213656 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 371642468 bytes. Operating system errno: 11 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. InnoDB: We now intentionally generate a seg fault so that InnoDB: on Linux we get a stack trace. 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=16777216 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 = 80383 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 041103 07:44:18 mysqld ended I have about 2 gig of filesystem space left. I don't believe that to be an issue. However, I was able to get it up for about 15 minutes when I purged some old binary logs. Any help would be greatly appreciated. Thanks - Gabe <><><><><><><><><><><><><><><><><><><><><> "There are no problems, only solutions." Gabe Tucker Bloomberg LP (609) 750 6668 - P (646) 268 5681 - F <><><><><><><><><><><><><><><><><><><><><> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fwd: MySQL and partitions
Ah, Thank you all so much. :-) My purpose for asking was some concerne with the possibility of growing DB sizes.. Question answered. Score one for the list. Yves On Wed, 3 Nov 2004 14:52:35 +0100 (CET), Thomas Spahni <[EMAIL PROTECTED]> wrote: > On Wed, 3 Nov 2004, Yves Arsenault wrote: > > > Thanks for the reply, > > > > Is there any information on the mysql.com website on how to store data > > on 2 separate partitions? > > There is something in the manual. The title is 'Symbolic links to > databases'. > > > > Using Symbolic Links > > > You can move tables and databases from the database directory to other > locations and replace them with symbolic links to the new locations. > You might want to do this, for example, to move a database to a file > system with more free space or increase the speed of your system by > spreading your tables to different disk. > > The recommended way to do this is to just symlink databases to a > different disk. Symlink tables only as a last resort. > > > > Thomas Spahni > > -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using an array(-ish) in SQL queries
Check here: http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
Look for the IN and NOT IN comparators :-)
DELETE FROM the_table WHERE `ID` IN(1,2,3,4,5,6)
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
-{ Rene Brehmer }- <[EMAIL PROTECTED]> wrote on 11/02/2004
07:29:20 PM:
> X-posted to MySQL and PHP DB
>
> Hi gang
>
> Task at hand: deleting or selecting (same difference) several numbers of
> records using only 1 query.
>
> My first version simply looped through all the ticked off IDs and ran a
> single query for each delete routine. I've still not suceeded in getting
> the delete queries to work on multiple tables at once, despite the
column
> names being the same. But besides this:
>
> My current version generates, for multi-select cases, queries like this:
>
> DELETE FROM the_table WHERE `ID`='1' OR ID`='2' OR `ID`='3' OR `ID`='4'
OR
> `ID`='5' OR `ID`='6'
>
> or similar with the SELECT statement.
>
> On some occasions this can result in a very large amount of OR
statements,
> like for 50 IDs totally.
>
> I've been reading through the MySQL manual and the comments in the
select
> and delete parts, but cannot seem to find any mentioning of an easier
way
> to do this. Or it's been deluting me cuz English is my second language,
so
> the MySQL manual doesn't always make much sense to me.
>
> I'm looking for something like passing on an array (as
comma-seperated-list
> maybe), and then just do statements like:
>
> DELETE FROM the_table WHERE `ID` ISIN(1,2,3,4,5,6)
>
> Did I totally miss that part of the manual, or is it just not possible
with
> MySQL ?
>
> Now, for my script it doesn't really matter much which approach to use,
but
> was more thinking performance wise it ought to be faster and less taxing
> for the server to parse an SQL statement that's closer to table
structure,
> rather than the OR statements that has to be transformed first.
>
> Sorry if I'm just a blind mouse that can't seem to find things in the
MySQL
> manual. It's not really my best friend...
>
> TIA
>
> Rene
> --
> Rene Brehmer
> aka Metalbunny
>
> If your life was a dream, would you wake up from a nightmare, dripping
of
> sweat, hoping it was over? Or would you wake up happy and pleased, ready
to
> take on the day with a smile?
>
> http://metalbunny.net/
> References, tools, and other useful stuff...
> Check out the new Metalbunny forums at http://forums.metalbunny.net/
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
Re: Fwd: MySQL and partitions
On Wed, 3 Nov 2004, Yves Arsenault wrote: > Thanks for the reply, > > Is there any information on the mysql.com website on how to store data > on 2 separate partitions? There is something in the manual. The title is 'Symbolic links to databases'. Using Symbolic Links You can move tables and databases from the database directory to other locations and replace them with symbolic links to the new locations. You might want to do this, for example, to move a database to a file system with more free space or increase the speed of your system by spreading your tables to different disk. The recommended way to do this is to just symlink databases to a different disk. Symlink tables only as a last resort. Thomas Spahni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: .MYD, .MYI files don't exist... but queries WORK??????
Tobias Asplund wrote: If you installed MySQL 4.1.7 on Windows with the new installer Yes I did. it will automatically use InnoDB tables as the default Ah ha. Thanks. :) That just leaves this: > So now my question "Where does InnoDB data get stored?" Cheers, Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | +===+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
slashes in update statement
I'm trying to get a slash in a variable into my database and am having some trouble. If the variable = "1 1/2" it echoes to the screen correctly but it seems to strip the 1/2 off the variable when updating the value to the database. I'm using php and a form select list to get this value from a previous page. Any ideas? Thanks, Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: MySQL and partitions
Thanks for the reply, Is there any information on the mysql.com website on how to store data on 2 separate partitions? I'll be doing a bit of research on this soon... Thanks again, Yves On Wed, 3 Nov 2004 13:21:59 + (GMT), andy thomas <[EMAIL PROTECTED]> wrote: > On Wed, 3 Nov 2004, Yves Arsenault wrote: > > > Hello all, > > > > I have MySQL installed on a Mandrake Linux system, it is installed on > > the /usr partition. > > > > I was wondering, is it possible to store some databases on the /var > > partition while MySQL is installed on the /usr partition? > > Yes. In fact, somewhere under the /var tree is the usual place for mysql > databases to reside in many installations. > > > And, if it is possible, can you store DB_A on /usr and DB_B on /var > > (or at least 2 different partitions). > > You can although current thinking in the UNIX/Linux world is that the > /usr filesystem should be read-only, which means files & directories that > change all the time shouldn't be under /usr. But older UNIXes and Linuxes > commonly use /usr/var, /usr/tmp and /usr/var/tmp for holding changing data > so it's really up to you. If the databases are big and/or heavily used, I > tend to put them on their own /mysql partition or even on their own fast > disk. /home/mysql or /export/home/mysql is another possibility. > > Andy > > -- Yves Arsenault -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: .MYD, .MYI files don't exist... but queries WORK??????
If you installed MySQL 4.1.7 on Windows with the new installer, it will automatically use InnoDB tables as the default unless you specify different. (This is different from earlier versions), so the error was probably not in the Query Browser, but in the server settings in this case. On Wed, 3 Nov 2004, Anders Green wrote: > Sequence of events: > -had an MS Access db > -converted it to MySQL 4.1.7 with a utility > -everything worked > -using MySQL Query Browser 1.0.1, added three tables > -everything worked > -comes time to deploy to another machine for testing, > copy directory of database over to other machine > -any queries involving the three new tables fail: > mysql> select * from admin; > ERROR 1016 (HY000): Can't open file: 'admin.InnoDB' (errno: 1) > > Now, the first thing to do is go looking for files. > What I find shocks and amazes me! There are missing > files! *grin* > > For each of the three new tables, there is a .frm > file, but no .myd or myi file. Okay. transfer > aborted or something I'll go back to the first > development machine and copy them over. > > WAIT A SECOND! They don't exist on the first > development machine either! And yet, queries > on the first development machine are working, > and those files are nowhere to be found on the > entire drive. > > Ok, I was about to add some info about the > table types... and with the query browser > on the first machine, I saw that they were > all InnoDB instead of MyISAM. Changing those > to MyISAM created the files. Copied those > over to the other machine, restarted the > server there, and they work. > > So now my question (which might be "Why does > the query browser not select MyISAM as the > table type since it describes it as "default">", > or might be "why is my junk not working?") > is "Where does InnoDB data get stored?" > > That is, in what file and what location? > Cause now I'm curious. :) > > Cheers, > Anders > +===+ > |Anders Green Email: [EMAIL PROTECTED] | > | Home: 919.303.0218 | > |Off Road Rally Racing Team: http://LinaRacing.com/ | > +===+ > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fulltext search Strategy - Need Help
Hello, I'm doing fairly straight forward fulltext searches, but I want to nest them - basically do a keyword search on 'phrase 1' and then search the results this returns for 'phrase 2', for example if phrase 1 is 'ford' and phrase 2 is 'focus' - I search once for 'ford' and then go through the record-set this returns for 'focus'. My first thought is use a temporary table - but is there a way of doing this with one query? Cheers, lee -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL and partitions
On Wed, 3 Nov 2004, Yves Arsenault wrote: > Hello all, > > I have MySQL installed on a Mandrake Linux system, it is installed on > the /usr partition. > > I was wondering, is it possible to store some databases on the /var > partition while MySQL is installed on the /usr partition? Yes. In fact, somewhere under the /var tree is the usual place for mysql databases to reside in many installations. > And, if it is possible, can you store DB_A on /usr and DB_B on /var > (or at least 2 different partitions). You can although current thinking in the UNIX/Linux world is that the /usr filesystem should be read-only, which means files & directories that change all the time shouldn't be under /usr. But older UNIXes and Linuxes commonly use /usr/var, /usr/tmp and /usr/var/tmp for holding changing data so it's really up to you. If the databases are big and/or heavily used, I tend to put them on their own /mysql partition or even on their own fast disk. /home/mysql or /export/home/mysql is another possibility. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL and partitions
Hello all, I have MySQL installed on a Mandrake Linux system, it is installed on the /usr partition. I was wondering, is it possible to store some databases on the /var partition while MySQL is installed on the /usr partition? And, if it is possible, can you store DB_A on /usr and DB_B on /var (or at least 2 different partitions). Thanks, -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Works with MySQL Logo
On Tue, Nov 02, 2004 at 11:57:35PM -0800, Karam Chand wrote: > I had checked google before posting. As you can see > none of the images are original and the clarity is not > good. They dont look good in my app. > > Can I get an original one from MySQL AB? The official MySQL logos can be downloaded from http://dev.mysql.com/downloads/logos.html There is no official 'Works with MySQL' logo (and I don't think there ever has been). Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYI files not found
hi i have a PHP/MYSQL site in witch i have some scripts creating some tables. my host crashed several times this week and then many of my already created databases corrupted.the error is can't find file MYDB.MYI i can't repair them by REPAIR TABLE script and i do not have ACCESS to SHELL in order to run MYISAMCHK command. please tell me whether the error is from my file or help me to repair my tables. thanks -- Abaghan Ghahraman www.abaghan.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.MYD, .MYI files don't exist... but queries WORK??????
Sequence of events: -had an MS Access db -converted it to MySQL 4.1.7 with a utility -everything worked -using MySQL Query Browser 1.0.1, added three tables -everything worked -comes time to deploy to another machine for testing, copy directory of database over to other machine -any queries involving the three new tables fail: mysql> select * from admin; ERROR 1016 (HY000): Can't open file: 'admin.InnoDB' (errno: 1) Now, the first thing to do is go looking for files. What I find shocks and amazes me! There are missing files! *grin* For each of the three new tables, there is a .frm file, but no .myd or myi file. Okay. transfer aborted or something I'll go back to the first development machine and copy them over. WAIT A SECOND! They don't exist on the first development machine either! And yet, queries on the first development machine are working, and those files are nowhere to be found on the entire drive. Ok, I was about to add some info about the table types... and with the query browser on the first machine, I saw that they were all InnoDB instead of MyISAM. Changing those to MyISAM created the files. Copied those over to the other machine, restarted the server there, and they work. So now my question (which might be "Why does the query browser not select MyISAM as the table type since it describes it as "default">", or might be "why is my junk not working?") is "Where does InnoDB data get stored?" That is, in what file and what location? Cause now I'm curious. :) Cheers, Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | +===+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: nebiew migrate access tables to mysql
I see 4.1.1 is new im downloading 4.1.7 now... On Wed, 03 Nov 2004 09:23:53 +0200, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hi. > > What version of MySQL do you use? > > To make it easier to reload dump files for tables that have foreign key > > relationships, mysqldump automatically includes a statement in the dump > > output to set FOREIGN_KEY_CHECKS to 0 as of MySQL 4.1.1. > > > > > spiv007 <[EMAIL PROTECTED]> wrote: > > > I just dumped my access tables into mysql via mysql dump script. > > > > > > But now when i del my ables in access then do an import it does not > > > save the primary key info nor the tables relationships. Is there > > > something I need to do to save this info before i remove the old > > > tables and insert the links. Because everything things works fine > > > until i del the tables. > > > > > > > > > Thanks for any ideals... > > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ><___/ www.mysql.com > > -- > 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: How to read TINYBLOB fields from the database
From: "Gleb Paharenko" <[EMAIL PROTECTED]> > Send us versions of software you use, and output of The MySQL server is hosted on a windows machine. No remote access to that. just an read only account to the database. > show create table 'table'. Table Create Table users CREATE TABLE `users` ( `name` varchar(65) binary default NULL, `a` varchar(129) NOT NULL default '', `b` varchar(255) NOT NULL default '', `c` varchar(255) NOT NULL default '', `d` varchar(33) NOT NULL default '', `e` tinyblob NOT NULL, `f` tinyblob NOT NULL, `g` tinyblob NOT NULL, `h` tinyblob NOT NULL, `i` tinyblob NOT NULL, `j` tinyblob NOT NULL, `k` tinyblob NOT NULL, `l` tinyblob NOT NULL, `m` tinyblob NOT NULL, `n` tinyblob NOT NULL, `o` tinyblob NOT NULL, `p` tinyblob NOT NULL, `locked` tinyint(3) unsigned NOT NULL default '0', `extra` varchar(65) binary default NULL, `time` timestamp(14) NOT NULL, KEY `name` (`name`) ) TYPE=MyISAM > Can you read non-blob field from this table (or others)? yes the non-blob fields works just fine And if i do the same way on blob fields i see just garbage like "&*(^yuhg789" But i know that fields holds a number or word. So i think its something to do with converting binary-format to ?. Danny Terweij. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Foreign Key
> Hi all, I whould like to know if there is a > way to create Foreign Key╢s between Parent and Child table, I realy dont > know if is it possible to do it and if OK, how will be a simple SQL code > of it. Only for InnoDB tables - see: http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: nebiew migrate access tables to mysql
sorry I should over put my verision number in. 4.0.21-standard On Wed, 03 Nov 2004 09:23:53 +0200, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hi. > > What version of MySQL do you use? > > To make it easier to reload dump files for tables that have foreign key > > relationships, mysqldump automatically includes a statement in the dump > > output to set FOREIGN_KEY_CHECKS to 0 as of MySQL 4.1.1. > > > > > spiv007 <[EMAIL PROTECTED]> wrote: > > > I just dumped my access tables into mysql via mysql dump script. > > > > > > But now when i del my ables in access then do an import it does not > > > save the primary key info nor the tables relationships. Is there > > > something I need to do to save this info before i remove the old > > > tables and insert the links. Because everything things works fine > > > until i del the tables. > > > > > > > > > Thanks for any ideals... > > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ><___/ www.mysql.com > > -- > 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]
Foreign Key
Hi all, I whould like to know if there is a way to create Foreign Key╢s between Parent and Child table, I realy dont know if is it possible to do it and if OK, how will be a simple SQL code of it. --- Christopher Chamber http://gem-hs.org/c.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL Batch Scripting
Hi.
Remove ';' from the end of the line.
[EMAIL PROTECTED] wrote:
> [-- text/plain, encoding 8bit, charset: US-ASCII, 22 lines --]
>
> I am trying to utilize MySQL's batch execution functionality by using build scripts
> to create tables in my database (ref:
> http://dev.mysql.com/doc/mysql/en/Batch_Commands.html )
>
> Is it possible to execute additional source files from within a source file from the
> MySQL command line?
>
> Ex:
>
> mysql> \. c:\file1.sql ## execute the first sql batch file
>
>
>
>
> create table employees{...};
> \. c:\file2.sql; ## execute the second sql batch file
>
>
>
>
> create table customers{...};
>
>
>
> I 've tried this and get an error: "failed to open file 'c:\file2.sql;', error 2
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL Batch Scripting
Hi.
System error: 2 = No such file or directory
Check if file exists. Do you have permissions to read this file?
[EMAIL PROTECTED] wrote:
> [-- text/plain, encoding 8bit, charset: US-ASCII, 22 lines --]
>
> I am trying to utilize MySQL's batch execution functionality by using build scripts
> to create tables in my database (ref:
> http://dev.mysql.com/doc/mysql/en/Batch_Commands.html )
>
> Is it possible to execute additional source files from within a source file from the
> MySQL command line?
>
> Ex:
>
> mysql> \. c:\file1.sql ## execute the first sql batch file
>
>
>
>
> create table employees{...};
> \. c:\file2.sql; ## execute the second sql batch file
>
>
>
>
> create table customers{...};
>
>
>
> I 've tried this and get an error: "failed to open file 'c:\file2.sql;', error 2
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to read TINYBLOB fields from the database
Hi. Send us versions of software you use, and output of show create table 'table'. Can you read non-blob field from this table (or others)? "Danny Terweij" <[EMAIL PROTECTED]> wrote: > Hello, > > Just hooked up to this list as last resort > Searched internet for some weeks now but still not found any > sollution/example. > > If you search about BLOB, you always get results of storing gifs, jpg's and > so on. > > I have (RO)access to an database and some tables have fields with TINYBLOB > types. They are not pictures or other binary kind of files stored in those > fields. They are just numbers and words. If i do a select * from table i do > only see some garbage as result. > Also i tried the select substring(field,0,255) from table but no result at > all. > I use the mysql commands in a TCL environment (with an tcl mysql library). > > So you feel my question... How to read human readable values from those > fields so i can process them furter with tcl ? > > Thank for any reply. > > Greetings, > Danny Terweij > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: inserting and displaying unicode characters
Hi. See: http://dev.mysql.com/doc/mysql/en/Charset.html http://dev.mysql.com/doc/mysql/en/Charset-connection.html Eben <[EMAIL PROTECTED]> wrote: > I'm running mysql 4.1.7 on linux. I recently made the upgrade from 4.0.1 > to 4.1.7 to get the additional character sets support. I have data > getting inserted that has various unicode characters embedded such as > the Registered Trademark symbol, and various foreign language characters. > > my tables are innodb and I set them to use utf-8, macroman and macce > character sets, and the unicode characters still display in the browser > as the incorrect symbols, such as: ? ?. If I set the browser to > unicode character encoding, then most of the characters display as black > diamonds with question marks in them. > > I am pretty new to this unicode situation and any suggestions/advice > would be greatly appreciated. > > thanks, > Eben > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication basics
Hi. You should really read the FAQ: http://mysql.ensita.net/doc/mysql/en/Replication_FAQ.html In case you want us to fine-tune replication for you, you may want to order commercial support, go to: https://order.mysql.com/?ref=ensita. ian douglas <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I've been browsing the online archives for a while and haven't found as > much data as I'd like to feel really comfortable about replication. I've > been a pretty busy developer in terms of using MySQL, but never so much > in the way of administration. Also, I've only ever had to deal with a > single machine until about a month ago when I was asked to extend our > database to multiple machines for security and redundancy. > > As it stands right now, I have 3 machines running MySQL, set up as hosts > db1, db2 and db3. > > db1 is a master > db2 and db3 are set as slaves, and replicate data just fine with the > premise that we'd like to add numerous slave machines at any time. > > Problems I'm having: > > 1. If a new database is created on db1, this is not replicated on db2 > and db3. Should my permissions be "GRANT FILE on *.* ..." or is there a > better way to automate duplicating this database on the slaves? > > 2. If a database exists on all three machines already and I create a > table on db1, this is also not replicated on db2 or db3. > > 3. I haven't checked yet whether "ALTER TABLE ..." commands have worked > across the replication. > > 4. Darn RedHat and their logrotate utility: db1 was having MySQL restart > once a week, which created db1.001, db1.002, db1.003, etc., every time > it restarted, yet db2 and db3 also running logrotate and having MySQL > restart because of it, were not updating their "master.info" files to > point at the ".002" or ".003" or ".004" files whenever db1 was > restarted. This also happens if db1 reboots. > > 5. In the event of power failure, or system failure, if db1 is offline, > how can I set the systems so either db2 or db3 becomes a master? And if > db1 comes back online later, could I set it as a slave to whichever > other machine became a master? Can this be automated, or will it always > require manual intervention? > > 6a. I rewrote my Perl applications to connect to db1 and return a handle > I call $dbh_w for any SELECT/INSERT/UPDATE/DELETE queries, and to > connect to any of db1/db2/db3 for any SELECT queries as $dbh_r. However, > we want to use some third-party software that contains a few MB of PHP > code, and only connects to the database one time - I'm not sure how much > time to allocate (to tell my CTO/CEO) to rewrite the entire application > the same way I did my Perl applications. Any advice? > 6b. My Perl scripts are 90% reading data back from the database, the PHP > scripts are more like 80% writing to the database so being able to > load-balance the writing to the database farm is ideal. In my current > scenario, the PHP application can only write to db1, which will > ultimately cap out the machine. Surely there's a better way than making > two connections ($dbh_w/$dbh_r) to the database for each copy of my Perl > or PHP processes running? > > 7. Finally, would 'fake replication' work if the MySQL database files > were on a RAID system and mounted via NFS to multiple machines to > actually run the MySQL engine? The tables we use have a lot of > auto_increment fields, and I'd be worried about data being corrupted or > lost. > > Thanks, > Ian Douglas > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: nebiew migrate access tables to mysql
Hi. What version of MySQL do you use? To make it easier to reload dump files for tables that have foreign key relationships, mysqldump automatically includes a statement in the dump output to set FOREIGN_KEY_CHECKS to 0 as of MySQL 4.1.1. spiv007 <[EMAIL PROTECTED]> wrote: > I just dumped my access tables into mysql via mysql dump script. > > But now when i del my ables in access then do an import it does not > save the primary key info nor the tables relationships. Is there > something I need to do to save this info before i remove the old > tables and insert the links. Because everything things works fine > until i del the tables. > > > Thanks for any ideals... > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Out of my depth.
Hi. It looks very strange. So give us the information about version of MySQL and operating system. If you use MySQL compiled manually, it will be helpful to use official binaries of the latest release. John Smith <[EMAIL PROTECTED]> wrote: > Hi All, > > I have built a search application in php/libcurl and I store its results in MySQL. > > The problem is that I am not used to dealing with the sizes of tables my search > application produces, roughly around 400,000 rows in a table the last time I got ran > it correctly. > > Right to my problem. > > I fork 20 versions of my spider at a time, these forks all have a connection to the > database and do selects, inserts and updates on the same table at once. When its > going at full steam I can be inserts 1000s of rows a minute. > > I am using MyISAM as I need its fulltext search cabablities. I remove the fulltext > index before I start any changes to the table. > > I am finding that my php script is not being able to select from the database at > random points, I have tracked this down to a 127 erros, the table it corrupt. > > Before I start my spiders (before it forks) I run myisamck -r on my .MYI file but it > corrupts during the scripts execution time and this means it is no longer able to > select from the DB (Curcial to know if its needing updated or inserted as a new > record) > > Any hints, any more information needed from me etc would be great. > > My table struture is: > > CREATE TABLE thetable ( > id int(11) NOT NULL auto_increment, > sid int(11) NOT NULL default '1', > pid varchar(14) NOT NULL default '0', > tid varchar(255) NOT NULL default '', > cid varchar(255) NOT NULL default '', > location text NOT NULL, > number int(14) NOT NULL default '0', > image text NOT NULL, > description text NOT NULL, > link text NOT NULL, > uo tinyint(1) NOT NULL default '0', > sd tinyint(1) NOT NULL default '0', > added int(14) NOT NULL default '0', > new tinyint(4) NOT NULL default '1', > old tinyint(4) NOT NULL default '0', > PRIMARY KEY (id), > KEY sid (sid), > KEY old (old), > KEY new (new), > KEY sd (sd), > KEY uo (uo), > KEY pid (pid), > KEY tid (tid), > KEY cid (cid) > ) > > Ta, > John > > ___ > Have your own email and web address for life. > > http://www.homemaster.net - Homemaster. Come Together. Online. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fastest Results
Hi. COUNT(*) is optimised to return the result very quickly for MyISAM tables, as the quantity of rows is stored and updated separately. (Not true for other table types, though). So in most cases use it. Rob Best <[EMAIL PROTECTED]> wrote: > I have a database that contains a cable of 'customers'. 'Customers' > does not change on a regular basis but is queried frequently so I have > setup a 'customers_cache' table, which is exactly the same as > 'customers', except 'customers_cache' is a memory based table. Before > doing a query on 'customers_cache' I always do a: SELECT COUNT (*) > from customers_cache > > If I get a result > 0, then I assume the customers_cache table is > valid. If it is not, I copy all of the data from 'customers' into > 'customers_cache' and then start over. > > I've had this help quite a bit, but of course I'm doing the query... > SELECT COUNT (*) from customers_cache > > a lot. Of course the query is fast but since I do it SO much, I was > wondering if anyone had a suggestion of a FASTER method of checking to > see if a table has any records in it. > > mysql version 4.0.22 (soon to move to 4.1.x) > MacOS X Server 10.3.5 > accessing via php 4.x & apache 1.3.x > > > Thanks! > > > Robert C. Best III- [EMAIL PROTECTED] > District Technology Coordinator > for N.E.R.I.C. at Potsdam Central School > Phone: (315) 265-2000 x266 > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication Problem: I/O Thread exits every night randomly
Hi all We have the following setup: - Master mySQL Server 4.0.11-gamma (sun-solaris2.9-sparc-64bit) - Slave mySQL Server 4.1.7 (sun-solaris2.9-sparc-64bit) Everything worked fine with both servers having the same Version (4.0.11-gamma). As a first step in updating to Rel. 4.1 we migrated the replika. Since then, we encounter the following problem: Every night replication stops. To be more precise: the I/O thread on Slave stops: mysql> SHOW SLAVE STATUS\G *** 1. row *** Slave_IO_State: Master_Host: spas.mysql.prod.glue.ch Master_User: replica Master_Port: 26001 Connect_Retry: 60 Master_Log_File: appl02-bin.628 Read_Master_Log_Pos: 30621 Relay_Log_File: appl01-relay-bin.24 Relay_Log_Pos: 412019 Relay_Master_Log_File: appl02-bin.628 Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 30621 Relay_Log_Space: 412019 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 18563 1 row in set (0.00 sec) The error log on replika says: 041103 3:37:50 [ERROR] While trying to obtain the list of slaves from the master 'spas.mysql.prod.glue.ch:26001', user 'replica' got the following error: 'Lost connection to MySQL server during query' 041103 3:37:50 [ERROR] Slave I/O thread exiting, read up to log 'appl02-bin.628', position 30621 Doing a mysqlbinlog on both relay log and master log do not show any problems. After a START SLAVE the slave does not recover operation completely. It looks, like the relay log file is filled, but the statements are not executed and the Seconds_Behind_Master are not decreased. Only after a complete restart of mysql (replica) the replica recovers. Any idea? Thanks for any help! Stephan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
