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 |
+---++
|
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
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
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
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
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
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
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,
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
$ 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
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
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
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
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
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
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
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 @
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...
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:
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
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
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
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
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() |
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
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
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?
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
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,
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
30 matches
Mail list logo
