checksum table incompatible change?
hi, I tried this in mysql 5.1.22: mysql create table t( value binary(16)) engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql insert into t values( NULL ); Query OK, 1 row affected (0.00 sec) mysql checksum table t; +---++ | Table | Checksum | +---++ | IM.t | 2777151533 | +---++ 1 row in set (0.00 sec) In mysql 5.1.32, however: mysql create table t( value binary(16)) engine=innodb; Query OK, 0 rows affected (0.01 sec) mysql insert into t values(NULL); Query OK, 1 row affected (0.00 sec) mysql checksum table t; +---++ | Table | Checksum | +---++ | IM.t | 3512059891 | +---++ 1 row in set (0.00 sec) Any ideas? Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Select field with multiple values using LIKE
AFAIK, repeated LIKEs. On Tue, Mar 24, 2009 at 6:24 AM, Yariv Omer yar...@jungo.com wrote: Hi when I am using a query for several field's values I am using the following query: Select field from table where in ('11', '22') I need to do a LIKE search (not exact match but like match) How can I do it Thanks, Yariv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be -- Celsius is based on water temperature. Fahrenheit is based on alcohol temperature. Ergo, Fahrenheit is better than Celsius. QED.
Repeatedly got signal 10 in Solaris
Hi, for 2 consecutive nights I got the following message in the log, followed by a restart: 090323 2:00:14 - mysqld got signal 10; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388600 read_buffer_size=131072 max_used_connections=81 max_connections=800 threads_connected=13 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1748985 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 090323 02:00:37 mysqld restarted 090323 2:00:43 InnoDB: Database was not shut down normally! ... The package I'm using is the 5.0.45-log bundled by Mysql for Solaris 10 - 64bit. If I'm not mistaken signal 10 is SIGBUS, something that in solaris happens as frequently as SIGSEGV. There are no coredumps to analyze. The number of active connections was average (81), so I don't expect that crash to have been caused by a lot of activity. Can anyone advise me what else to search? Thanks, Nico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: checksum table incompatible change?
hi, Now I know it, sorry for the interruption :( The two mysql are compiled with different default character set parameters... It's easy to get confused for having NULL in utf8 != NULL in gbk, though. Thank you 2009/3/24 Cui Shijun rancp...@gmail.com: hi, I tried this in mysql 5.1.22: mysql create table t( value binary(16)) engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql insert into t values( NULL ); Query OK, 1 row affected (0.00 sec) mysql checksum table t; +---++ | Table | Checksum | +---++ | IM.t | 2777151533 | +---++ 1 row in set (0.00 sec) In mysql 5.1.32, however: mysql create table t( value binary(16)) engine=innodb; Query OK, 0 rows affected (0.01 sec) mysql insert into t values(NULL); Query OK, 1 row affected (0.00 sec) mysql checksum table t; +---++ | Table | Checksum | +---++ | IM.t | 3512059891 | +---++ 1 row in set (0.00 sec) Any ideas? Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Database Import from Oracle
Hello @all. I`ve got the question how mysql will have to be set up, that it can handle round about 7.000.000 records most efficiently. What do you think about the the hard and software requirements in order to match the best combination? The data will come from oracle, so it would be interessting to, how I will have to import the data. Does this work once, or will I have to divide the data in several parts for import? Best Greetings, Frank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Upgrade large databases from 4.1 to 5.1
Hi All, I need to migrate a large (30G) database from 4.1 to 5.1 on a live system that cannot afford a large amount of downtime. The official method (copy files, run mysql_upgrade...etc) is looking like it will take forever, particularly since I need to move it 5.0 before 5.1. How do people normally manage this in a high availability environment? One idea being floated is to set up slave running 5.1 to replicate off 4.1 and then cut it over to being the master when we're ready to migrate... is this feasable or dangerous? Anyone else who's dealt with this kind of migration before have any other ideas? Thanks in advance. Craig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: if there're a tool which can replace mysql-proxy?
There are a couple of other proxies, including Dormando's proxy. But none of them is an official release. You should tell your customer that mysql-proxy is a core part of MySQL Enterprise. Its alpha status means that it is subject to change (as they develop MySQL Enterprise they may discover different features they don't foresee now). The alpha status doesn't mean it is unstable or poor quality, it is used in production in thousands of major installations. On Tue, Mar 24, 2009 at 4:26 AM, Moon's Father yueliangdao0...@gmail.com wrote: Hi. I want to know if there're a tool which can act as the same funciton as the mysql-proxy? Now we have a customer who want to use mysql-proxy, but he is afraid of its alpha version. So I want to know if there're another tool that can replace it? Any reply is appreciated. -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Upgrade large databases from 4.1 to 5.1
If you can't take downtime, I'd go the slave route. You should certainly test your application to make sure 5.1's differences (data types, syntax, etc) don't cause problems. Otherwise you're risking getting badly stuck and having to downgrade to 4.1 again in a crisis. If you dump and reload, you don't need to go to 5.0 first. That is only for in-place upgrades with mysql_upgrade, which I would not do anyway because of the file format changes. I would dump and reload. On Tue, Mar 24, 2009 at 7:44 AM, Craig Dunn li...@codenation.net wrote: Hi All, I need to migrate a large (30G) database from 4.1 to 5.1 on a live system that cannot afford a large amount of downtime. The official method (copy files, run mysql_upgrade...etc) is looking like it will take forever, particularly since I need to move it 5.0 before 5.1. How do people normally manage this in a high availability environment? One idea being floated is to set up slave running 5.1 to replicate off 4.1 and then cut it over to being the master when we're ready to migrate... is this feasable or dangerous? Anyone else who's dealt with this kind of migration before have any other ideas? Thanks in advance. Craig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=ba...@xaprb.com -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
perform on mysqlbug man page
The mysqlbug man page has the weird word perform at the end of this sentence: The script will place you in an editor with a copy of the report to be sent. Edit the lines near the beginning that indicate the nature of the problem. Then write the file to save your changes, quit the editor, and mysqlbug will send the report by email. perform. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
SHOW TABLE STATUS constantly wildly fluctuating
$ watch -d mysqlshow --status myDB #shows the count of rows is constantly fluctuating for some tables, even though the database is offline. There ought to be a note about it here and on HELP SHOW TABLE STATUS; Must use o --count Show the number of rows per table. (Which also should mention that it also shows number of columns.) Release: mysql-5.1.32-1 ((Debian)) C compiler:gcc (Debian 4.3.3-5) 4.3.3 C++ compiler: g++ (Debian 4.3.3-5) 4.3.3 Environment: System: Linux jidanni2 2.6.26-1-686 #1 SMP Sat Jan 10 18:29:31 UTC 2009 i686 GNU/Linux Some paths: /usr/bin/perl /usr/bin/make Compilation info (call): CC='gcc' CFLAGS='-O3 -DBIG_JOINS=1 ' CXX='g++' CXXFLAGS='-O3 -DBIG_JOINS=1 -felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS='' ASFLAGS='' Compilation info (used): CC='gcc' CFLAGS=' -O3 -DBIG_JOINS=1-DUNIV_LINUX' CXX='g++' CXXFLAGS=' -O3 -DBIG_JOINS=1 -felide-constructors -fno-exceptions -fno-rtti-fno-implicit-templates -fno-exceptions -fno-rtti' LDFLAGS=' -rdynamic ' ASFLAGS='' LIBC: lrwxrwxrwx 1 root root 11 2009-03-21 08:20 /lib/libc.so.6 - libc-2.9.so -rwxr-xr-x 1 root root 1310924 2009-03-19 02:16 /lib/libc-2.9.so Configure command: ./configure '--build=i486-linux-gnu' '--host=i486-linux-gnu' '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--with-server-suffix=-1' '--with-comment=(Debian)' '--with-system-type=debian-linux-gnu' '--enable-shared' '--enable-static' '--enable-thread-safe-client' '--enable-assembler' '--enable-local-infile' '--with-pstack' '--with-fast-mutexes' '--with-big-tables' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--with-libwrap' '--with-ssl' '--without-docs' '--with-extra-charsets=all' '--with-plugins=max' '--without-ndbcluster' '--with-embedded-server' '--with-embedded-privilege-control' 'build_alias=i486-linux-gnu' 'host_alias=i486-linux-gnu' 'CC=gcc' 'CFLAGS=-O3 -DBIG_JOINS=1 ' 'LDFLAGS=' 'CPPFLAGS=' 'CXX=g++' 'CXXFLAGS=-O3 -DBIG_JOINS=1 -felide-constructors -fno-exceptions -fno-rtti ' 'FFLAGS=-g -O2' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: if there're a tool which can replace mysql-proxy?
Question: my company tried the mysql-proxy about one year ago(may be more) but could not use it for not being multithreaded. They say they spoke to the 'mysql-proxy' developer. Is this still true? Are there any limitation on using mysql proxy on a high load production server? Will it be completely(almost) transparent? Thanks Claudio 2009/3/24 Baron Schwartz ba...@xaprb.com There are a couple of other proxies, including Dormando's proxy. But none of them is an official release. You should tell your customer that mysql-proxy is a core part of MySQL Enterprise. Its alpha status means that it is subject to change (as they develop MySQL Enterprise they may discover different features they don't foresee now). The alpha status doesn't mean it is unstable or poor quality, it is used in production in thousands of major installations. On Tue, Mar 24, 2009 at 4:26 AM, Moon's Father yueliangdao0...@gmail.com wrote: Hi. I want to know if there're a tool which can act as the same funciton as the mysql-proxy? Now we have a customer who want to use mysql-proxy, but he is afraid of its alpha version. So I want to know if there're another tool that can replace it? Any reply is appreciated. -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
Re: Repeatedly got signal 10 in Solaris
I can't help you directly, however I find the silence deafening, you'd expect a little more participation from the mysql devs - it's not exactly a high volume list. I recall getting a sigbus from postgres on netbsd a few months back and that turned out to be a bad build due to the combination of a linker error and specific piece of code. However that's a totally different scenario, in fact I'm not sure there's even a point to me writing it. Yeah, forget that entire paragraph. There are a few steps you can take to try and narrow down the problem listed here: http://dev.mysql.com/doc/refman/5.0/en/crashing.html Perhaps that's a start. --- On Tue, 24/3/09, Nico Sabbi nicola.sa...@poste.it wrote: From: Nico Sabbi nicola.sa...@poste.it Subject: Repeatedly got signal 10 in Solaris To: MySql mysql@lists.mysql.com Date: Tuesday, 24 March, 2009, 9:24 AM Hi, for 2 consecutive nights I got the following message in the log, followed by a restart: 090323 2:00:14 - mysqld got signal 10; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388600 read_buffer_size=131072 max_used_connections=81 max_connections=800 threads_connected=13 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1748985 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 090323 02:00:37 mysqld restarted 090323 2:00:43 InnoDB: Database was not shut down normally! ... The package I'm using is the 5.0.45-log bundled by Mysql for Solaris 10 - 64bit. If I'm not mistaken signal 10 is SIGBUS, something that in solaris happens as frequently as SIGSEGV. There are no coredumps to analyze. The number of active connections was average (81), so I don't expect that crash to have been caused by a lot of activity. Can anyone advise me what else to search? Thanks, Nico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=glynast...@yahoo.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Upgrade large databases from 4.1 to 5.1
Baron Schwartz wrote: If you can't take downtime, I'd go the slave route. You should certainly test your application to make sure 5.1's differences (data types, syntax, etc) don't cause problems. Otherwise you're risking getting badly stuck and having to downgrade to 4.1 again in a crisis. If you dump and reload, you don't need to go to 5.0 first. That is only for in-place upgrades with mysql_upgrade, which I would not do anyway because of the file format changes. I would dump and reload. Sorry I wasn't very clear there - testing will all be done in a QA environment before anything is cut over, what I'm after is a way of switching from 4.1 to 5.1 as quickly as possible when we come to do the live stuff. Looks like replication may work from what you are saying. Cheers Craig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: if there're a tool which can replace mysql-proxy?
On Mar 24, 2009, at 8:06 AM, Claudio Nanni wrote: Question: Hello Claudio, my company tried the mysql-proxy about one year ago(may be more) but could not use it for not being multithreaded. They say they spoke to the 'mysql-proxy' developer. Is this still true? Are there any limitation on using mysql proxy on a high load production server? It's still not multi-threaded, but work is progressing in this area, see: https://lists.launchpad.net/mysql-proxy-discuss/msg00041.html There are people using it on high-load production servers, for various flavors of high load. How much impact *any* proxy will have depends a lot on the type of workload you run through it, and what you do with the data while it's in the proxy itself, since what's going to hurt you performance-wise is directly related to latency, caused by the extra network hop, and anything else you do that delays the data being forwarded. Will it be completely(almost) transparent? Once again, that depends on what you do to the data flowing through it. The only major non-transparent part of the proxy is the permissions system, in that clients connecting through the proxy will always *appear* to be connecting *from* the proxy from mysqld's point of view, since there is no way to forward the client address to mysqld itself. For proxy-related questions, you'll probably get more detailed, quicker responses if you join the launchpad project's mailing list at: https://launchpad.net/~mysql-proxy-discuss If you're considering using mysql-proxy, I highly recommend tracking the project via the mailing list and staying in touch with the developers and the community, to both get a better idea if it's going to work for your situation in it's current (and always changing) state, and also to provide input into the direction of the developers. Best regards, -Mark -- Mark Matthews, Architect - Enterprise Tools MySQL @ Sun Microsystems, Inc., http://www.sun.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Database Import from Oracle
At 06:28 AM 3/24/2009, you wrote: Hello @all. I`ve got the question how mysql will have to be set up, that it can handle round about 7.000.000 records most efficiently. What do you think about the the hard and software requirements in order to match the best combination? The data will come from oracle, so it would be interessting to, how I will have to import the data. Does this work once, or will I have to divide the data in several parts for import? Best Greetings, Frank Frank, The fastest way to import data from Oracle would be as a CSV file and then use Load Data Infile to import the data into MySQL. 7 million records should load in a couple of minutes. Make sure you confirm the row counts are equal after you have imported the data. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Upgrade large databases from 4.1 to 5.1
Craig, It is both feasible and dangerous. Good to hear you plan to put it through a couple of QA cycles (you will need them), but this can be accomplished. With a planned downtime window of an hour, I migrated a couple of terabytes from 4.0 to 5.0 a couple years back while making numerous schema changes along the way using a similar slave-driven, process-as-much-as-you-can-in-advance plan. It was excruciating, but we pulled it off. - michael dykman On Tue, Mar 24, 2009 at 9:38 AM, Craig Dunn li...@codenation.net wrote: Baron Schwartz wrote: If you can't take downtime, I'd go the slave route. You should certainly test your application to make sure 5.1's differences (data types, syntax, etc) don't cause problems. Otherwise you're risking getting badly stuck and having to downgrade to 4.1 again in a crisis. If you dump and reload, you don't need to go to 5.0 first. That is only for in-place upgrades with mysql_upgrade, which I would not do anyway because of the file format changes. I would dump and reload. Sorry I wasn't very clear there - testing will all be done in a QA environment before anything is cut over, what I'm after is a way of switching from 4.1 to 5.1 as quickly as possible when we come to do the live stuff. Looks like replication may work from what you are saying. Cheers Craig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: if there're a tool which can replace mysql-proxy?
Hello, One additional note in regards to learning more about the current state of MySQL Proxy and connecting with Proxy developers... Check out the Simulating Workload with MySQL Proxy webinar on April 2, with Giuseppe Maxia, MySQL Community Lead and Diego Medina, Quality Assurance Engineer @ Sun who will be talking about Proxy in general, but also some advanced topics. Thanks, -- Jimmy Mark Matthews wrote: On Mar 24, 2009, at 8:06 AM, Claudio Nanni wrote: Question: Hello Claudio, my company tried the mysql-proxy about one year ago(may be more) but could not use it for not being multithreaded. They say they spoke to the 'mysql-proxy' developer. Is this still true? Are there any limitation on using mysql proxy on a high load production server? It's still not multi-threaded, but work is progressing in this area, see: https://lists.launchpad.net/mysql-proxy-discuss/msg00041.html There are people using it on high-load production servers, for various flavors of high load. How much impact *any* proxy will have depends a lot on the type of workload you run through it, and what you do with the data while it's in the proxy itself, since what's going to hurt you performance-wise is directly related to latency, caused by the extra network hop, and anything else you do that delays the data being forwarded. Will it be completely(almost) transparent? Once again, that depends on what you do to the data flowing through it. The only major non-transparent part of the proxy is the permissions system, in that clients connecting through the proxy will always *appear* to be connecting *from* the proxy from mysqld's point of view, since there is no way to forward the client address to mysqld itself. For proxy-related questions, you'll probably get more detailed, quicker responses if you join the launchpad project's mailing list at: https://launchpad.net/~mysql-proxy-discuss If you're considering using mysql-proxy, I highly recommend tracking the project via the mailing list and staying in touch with the developers and the community, to both get a better idea if it's going to work for your situation in it's current (and always changing) state, and also to provide input into the direction of the developers. Best regards, -Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: if there're a tool which can replace mysql-proxy?
Forgot to post the URL in the event you are interested: http://www.mysql.com/news-and-events/web-seminars/display-306.html -- Jimmy Jimmy Guerrero wrote: Hello, One additional note in regards to learning more about the current state of MySQL Proxy and connecting with Proxy developers... Check out the Simulating Workload with MySQL Proxy webinar on April 2, with Giuseppe Maxia, MySQL Community Lead and Diego Medina, Quality Assurance Engineer @ Sun who will be talking about Proxy in general, but also some advanced topics. Thanks, -- Jimmy Mark Matthews wrote: On Mar 24, 2009, at 8:06 AM, Claudio Nanni wrote: Question: Hello Claudio, my company tried the mysql-proxy about one year ago(may be more) but could not use it for not being multithreaded. They say they spoke to the 'mysql-proxy' developer. Is this still true? Are there any limitation on using mysql proxy on a high load production server? It's still not multi-threaded, but work is progressing in this area, see: https://lists.launchpad.net/mysql-proxy-discuss/msg00041.html There are people using it on high-load production servers, for various flavors of high load. How much impact *any* proxy will have depends a lot on the type of workload you run through it, and what you do with the data while it's in the proxy itself, since what's going to hurt you performance-wise is directly related to latency, caused by the extra network hop, and anything else you do that delays the data being forwarded. Will it be completely(almost) transparent? Once again, that depends on what you do to the data flowing through it. The only major non-transparent part of the proxy is the permissions system, in that clients connecting through the proxy will always *appear* to be connecting *from* the proxy from mysqld's point of view, since there is no way to forward the client address to mysqld itself. For proxy-related questions, you'll probably get more detailed, quicker responses if you join the launchpad project's mailing list at: https://launchpad.net/~mysql-proxy-discuss If you're considering using mysql-proxy, I highly recommend tracking the project via the mailing list and staying in touch with the developers and the community, to both get a better idea if it's going to work for your situation in it's current (and always changing) state, and also to provide input into the direction of the developers. Best regards, -Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: if there're a tool which can replace mysql-proxy?
Great, thanks guys, I think after subqueries,triggers , stored procs and views is the most awaited thingie now! Cheers Claudio 2009/3/24 Jimmy Guerrero jimmy.guerr...@sun.com Forgot to post the URL in the event you are interested: http://www.mysql.com/news-and-events/web-seminars/display-306.html -- Jimmy Jimmy Guerrero wrote: Hello, One additional note in regards to learning more about the current state of MySQL Proxy and connecting with Proxy developers... Check out the Simulating Workload with MySQL Proxy webinar on April 2, with Giuseppe Maxia, MySQL Community Lead and Diego Medina, Quality Assurance Engineer @ Sun who will be talking about Proxy in general, but also some advanced topics. Thanks, -- Jimmy Mark Matthews wrote: On Mar 24, 2009, at 8:06 AM, Claudio Nanni wrote: Question: Hello Claudio, my company tried the mysql-proxy about one year ago(may be more) but could not use it for not being multithreaded. They say they spoke to the 'mysql-proxy' developer. Is this still true? Are there any limitation on using mysql proxy on a high load production server? It's still not multi-threaded, but work is progressing in this area, see: https://lists.launchpad.net/mysql-proxy-discuss/msg00041.html There are people using it on high-load production servers, for various flavors of high load. How much impact *any* proxy will have depends a lot on the type of workload you run through it, and what you do with the data while it's in the proxy itself, since what's going to hurt you performance-wise is directly related to latency, caused by the extra network hop, and anything else you do that delays the data being forwarded. Will it be completely(almost) transparent? Once again, that depends on what you do to the data flowing through it. The only major non-transparent part of the proxy is the permissions system, in that clients connecting through the proxy will always *appear* to be connecting *from* the proxy from mysqld's point of view, since there is no way to forward the client address to mysqld itself. For proxy-related questions, you'll probably get more detailed, quicker responses if you join the launchpad project's mailing list at: https://launchpad.net/~mysql-proxy-discusshttps://launchpad.net/%7Emysql-proxy-discuss If you're considering using mysql-proxy, I highly recommend tracking the project via the mailing list and staying in touch with the developers and the community, to both get a better idea if it's going to work for your situation in it's current (and always changing) state, and also to provide input into the direction of the developers. Best regards, -Mark
MySQL server has gone away...
We are running MySQL Server version 5.0.67-community-nt-log on a WS03 server. It seems like every once in a while (sometimes once or twice a week, sometimes more), something will happen, then I'll start getting a lot of errors: [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]MySQL server has gone away This is driving me absolutely nuts. I don't see any errors in the Event Viewer, or the MySQL error log.Does anyone know of any reasons that this might happen? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Database Import from Oracle
Hi guys, the easiest is to use MySQL Migration Toolkit, I've sucessfuly used it with SQL Server (2000 and 2008) and Oracle 9i, all with simple structures and simple data, but worked VERY well... Regards, Bruno B. B. Magalhães Sócio-Diretor de Negócios e Tecnologia BLACKBEAN CONSULTORIA Rua Real Grandeza 193, Sala 210, Botafogo Rio de Janeiro, RJ, 22281-035, Brasil +55 (21) 9278-0082 +55 (21) 2266-0597 www.blackbean.com.br Esta mensagem pode conter informação confidencial e/ou privilegiada. Se você não for o destinatário ou a pessoa autorizada a receber esta mensagem, não pode usar, copiar ou divulgar as informações nela contidas ou tomar qualquer ação baseada nessas informações. Se você recebeu esta mensagem por engano, por favor avise imediatamente o remetente, respondendo o e-mail e em seguida apague-o. Agradecemos sua cooperação. This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. On Mar 24, 2009, at 11:21 AM, mos wrote: At 06:28 AM 3/24/2009, you wrote: Hello @all. I`ve got the question how mysql will have to be set up, that it can handle round about 7.000.000 records most efficiently. What do you think about the the hard and software requirements in order to match the best combination? The data will come from oracle, so it would be interessting to, how I will have to import the data. Does this work once, or will I have to divide the data in several parts for import? Best Greetings, Frank Frank, The fastest way to import data from Oracle would be as a CSV file and then use Load Data Infile to import the data into MySQL. 7 million records should load in a couple of minutes. Make sure you confirm the row counts are equal after you have imported the data. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=brunomagalh...@blackbean.com.br -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL server has gone away...
this means that your connection has timed out... there's a mysql_ping command you can use to reconnect.- Original Message -From: Jesse Date: Tuesday, March 24, 2009 11:44 amSubject: MySQL server has gone away...To: mysql@lists.mysql.com We are running MySQL Server version 5.0.67-community-nt-log on a WS03 server. It seems like every once in a while (sometimes once or twice a week, sometimes more), something will happen, then I'll start getting a lot of errors: [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]MySQL server has gone away This is driving me absolutely nuts. I don't see any errors in the Event Viewer, or the MySQL error log.Does anyone know of any reasons that this might happen? Jesse-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dryd...@optonline.net
Re: MySQL server has gone away...
Persistent connections that are dropped when the service is restarted OR the idle timeout has passed. if this is a connection pool and it hasn't been used in a long time the server can drop the connection but the pool will still thinkbits open and pass it out. Thus the server has gone away message. To my knowledge, the service was not re-started (That's usually logged in the Windows Event Log, and there is nothing there). If it were idle time issues, I could understand one or two, but when this happens, I usually get 20 or 30 errors at one time. This is a web app, and users are either connected at the time, or attempting to connect. Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
how can i determine default database within a stored procedure?
The database() function returns the default database, so: mysql use scratch; Database changed mysql select database(); ++ | database() | ++ | scratch| ++ mysql use mysql; Database changed mysql select database(); ++ | database() | ++ | mysql | ++ However, if the database function is invoked from within a stored procedure, it only returns the name of the database in which it exists: use scratch; delimiter $$ create procedure thisdb() begin select database(); end$$ delimiter ; use scratch; call scratch.thisdb(); scratch use mysql; call scratch.thisdb(); scratch use customer; call scratch.thisdb(); scratch This is documented behavior. Is there anyway for a stored procedure to determine what the deafault schema of the user invoking it is? We are trying to track down cross-schema invocations of sp's and this is the last piece I have to figure out. Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
Re: MySQL server has gone away...
Go into the my.cnf and increase the connection timeout and see if that fixes it. Remember. Connection pooling is about reuse and sometimes when the server is using less connections its using the same ones over and over again. Then you get a burst and then connections that haven't been used are then reissued and that's when the problem arrises. Personally I done use the odbc drive for mysql for similar reasons. I use the .net component with connection pooling disabled and manage them myself. (I have specific other reasons for this as well -- custom data cache classes) I normale use the .net connecter too, but this is a classic .asp application, so ODBC seemed to be my only choice. I'll try increasing the connection time out and see if that helps. Does the IIS memory pooling have anything to do with this, or is it a completely separate thing? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL server has gone away...
An update on this issue. It just happened again, and the first error was: [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]Lost connection to MySQL server during que Then, after that, I got a BUNCH of [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]MySQL server has gone away errors. I'm pretty sure that the 2nd errors were caused by the first error. Again, there is nothing strange in the IIS logs, or Windows Event log The database server is on the same machine as the web server, so the network should not be involved here. Why would it suddenly loose connection? Jesse - Original Message - From: Jesse j...@msdlg.com To: mysql@lists.mysql.com Sent: Tuesday, March 24, 2009 11:41 AM Subject: MySQL server has gone away... We are running MySQL Server version 5.0.67-community-nt-log on a WS03 server. It seems like every once in a while (sometimes once or twice a week, sometimes more), something will happen, then I'll start getting a lot of errors: [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]MySQL server has gone away This is driving me absolutely nuts. I don't see any errors in the Event Viewer, or the MySQL error log.Does anyone know of any reasons that this might happen? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub...@msdlg.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL server has gone away...
I thought that the # of connections might be a problem at some point too. The last time this happened, there were a lot of connections. Right now, there are 19 connections. How do I tell what the TTL is? I'm not too familiar with perfmon. How do I set it up to watch MySQL connections? Thanks, Jesse - Original Message - From: Gary Smith g...@primeexalia.com To: Jesse j...@msdlg.com; mysql@lists.mysql.com Sent: Tuesday, March 24, 2009 2:55 PM Subject: Re: MySQL server has gone away... Netstat -an. How many 3306 entries do you have in there. What's the TTL on them. Once the pool issues the bad connection multiple issuances of the same connection will probably result in the same error.if yoi birst to 20 connections then drop to 10 for the next 24 hours then burst to 11 that 11th might have been dropped. Next asp request gets 11. Next one gets 11. And so on until the active requests drop to the point where the connections are still active. Does this make sense? It doesn't round robin them (at least to the best of my knowledge) so some may go stayle. When testing the odbc connection some time ago I had connections stay in the pool for a day whereas my timeout was 120 minutes. Anyway. Watch the connection count with the windows perfmon and see if there is a corrolation. Sent via BlackBerry by ATT -Original Message- From: Jesse j...@msdlg.com Date: Tue, 24 Mar 2009 14:47:30 To: Jessej...@msdlg.com; mysql@lists.mysql.com Subject: Re: MySQL server has gone away... An update on this issue. It just happened again, and the first error was: [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]Lost connection to MySQL server during que Then, after that, I got a BUNCH of [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]MySQL server has gone away errors. I'm pretty sure that the 2nd errors were caused by the first error. Again, there is nothing strange in the IIS logs, or Windows Event log The database server is on the same machine as the web server, so the network should not be involved here. Why would it suddenly loose connection? Jesse - Original Message - From: Jesse j...@msdlg.com To: mysql@lists.mysql.com Sent: Tuesday, March 24, 2009 11:41 AM Subject: MySQL server has gone away... We are running MySQL Server version 5.0.67-community-nt-log on a WS03 server. It seems like every once in a while (sometimes once or twice a week, sometimes more), something will happen, then I'll start getting a lot of errors: [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]MySQL server has gone away This is driving me absolutely nuts. I don't see any errors in the Event Viewer, or the MySQL error log.Does anyone know of any reasons that this might happen? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub...@msdlg.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=g...@primeexalia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Installation Problems
I had MySQL 4.0. Today i downloaded the recent version, mysql5.12.32-Win32 installer. I deleted the older verison of mysql that i had. I didnt have any data there and thus no upgrade was needed as such. I used typical install option and after the install i used the standard configuration for the server configuration wizard. i typed the password required and the problems started. 1. It couldnot install mysql as a service, named MySQL, although there is no service with that name. i checked with the service option in control panel. 2. I went back and installed it with the service name MySQL5. This time, it installed the service, but could not apply the security setting and terminated with the error, saying root doesnot have the permission to log on from localhost. 3. I opened the command line clien from the start menu. It asked for the password, i typed it in and the interface disappeared. I uninstalled and then installed it again a couple of times, but one or the other erroe kept reccuring. I'm still havent been able to use MySQL. Please Help.
RE: Installation Problems
Ever since MySQL 5.0.27, I have never been able to install the MySQL Service either. I think this has something to do with the way Microsoft compiles its OS Services. I use the no installer version now. 1. Go to a DOS Window and create a directory called C:\ MySQL_5.1.32 2. Click Start, Run, and type Open : C:\ MySQL_5.1.32. This will open a Windows Explorer Window in that new empty Folder. 3. Download mysql-noinstall-5.1.32.zip to the Windows Desktop 4. Open the mysql-noinstall-5.1.32.zip and another Windows Explorer window opens up containing the folder 'mysql-noinstall-5.1.32-win32' 5. Double click that 'mysql-noinstall-5.1.32-win32' folder and another window shows the folders 'bin','data','Docs' and so forth. 6. Select all files and folders by hitting Ctrl-A 7. Drag and Drop those selected files and folders into the 'C:\ MySQL_5.1.32' Window 8. Right-click on 'My Computer', and click on 'Properties' 9. Click on the Advanced Tab 10. Click the Environment Variables button 11. Scroll the bottom listbox to the PATH variable 12. Double Click the PATH variable 13. Append ';C:\MySQL_5.1.32' to the PATH variable 14. Click OK 3 times 15. In the 'C:\MySQL_5.1.32' Window, copy 'my-small' to 'my' (In other words, copy mysql-small.ini to my.ini) If you do not do this, you will be starting mysqld with all server defaults 16. Create a DOS Batch File called start_mysqld.bat with the following lines @echo off set MYSQL_HOME=C:\MySQL_5.1.32 set MYSQL_BIN=%MYSQL_HOME%\bin echo %MYSQL_BIN% cd %MYSQL_BIN% pause (This line is optional) start mysqld 17. Create a DOS Batch File called stop_mysqld.bat with the following lines @echo off set MYSQL_HOME=C:\MySQL_5.1.32 set MYSQL_BIN=%MYSQL_HOME%\bin %MYSQL_BIN%\mysqladmin -uroot shutdown 18. Create a ShortCut for both batch files and place them on the Desktop 19. Double Click the ShortCut for start_mysqld.bat This should start up mysqld Open the task manager and look for 'mysqld.exe' 20. Goto a new DOS Window and type 'mysql -uroot' You should be mysql now. If you got to this point successfully, have fun from here !!! Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM : RolandoLogicWorx Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: Manish Gupta [mailto:manish.in@gmail.com] Sent: Tuesday, March 24, 2009 4:05 PM To: mysql@lists.mysql.com Subject: Installation Problems I had MySQL 4.0. Today i downloaded the recent version, mysql5.12.32-Win32 installer. I deleted the older verison of mysql that i had. I didnt have any data there and thus no upgrade was needed as such. I used typical install option and after the install i used the standard configuration for the server configuration wizard. i typed the password required and the problems started. 1. It couldnot install mysql as a service, named MySQL, although there is no service with that name. i checked with the service option in control panel. 2. I went back and installed it with the service name MySQL5. This time, it installed the service, but could not apply the security setting and terminated with the error, saying root doesnot have the permission to log on from localhost. 3. I opened the command line clien from the start menu. It asked for the password, i typed it in and the interface disappeared. I uninstalled and then installed it again a couple of times, but one or the other erroe kept reccuring. I'm still havent been able to use MySQL. Please Help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
learning mysql
hi, I'm looking for some advice where to learn mysql. Not being a DBA, I have basic knowledge of databases, and have administered them in the past. The docs on the mysql site aren't very good for this, just a few examples of commands, etc. Ideally, something that is suited for system administrators, not looking to be a DBA. Thanks..