Mauricio,
I believe in latin1, MySQL indeed identifies n-tilde with n.
Please test with the UTF-8 charset.
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
Csongor,
in InnoDB, it is better to use
SELECT ... FOR UPDATE
to lock the result set of a SELECT.
A plain SELECT in InnoDB is a consistent, non-locking read that reads a
snapshot of the database at an earlier time. It does not lock anything.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign
Pandu,
this may be the '4 billion bug'. Please upgrade to 4.0.21, and report if the
crashes persist.
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
Hi people
Due to MySQL does not support inner-selects, I generate a string (I
programm java-client) with the values I used in an IN-operator for an
update onto a mySQL database.
The statement looks like this:
UPDATE layer SET State=1
WHERE fpObjectID IN (1,3,4,5,20,34,56,24,56,11,45)
Now, the
Yes. I also tried that. Are there any other suggestions?
What's about the different sections in my.cnf?
Should these statements beeing written under [mysqld_safe], too?
Victor Pendleton wrote:
In the slave's my.cnf have you tried just expliciting statement what tables
to ignore?
* Oliver Hirschi [EMAIL PROTECTED] [09/13/04]:
Hi people
Due to MySQL does not support inner-selects, I generate a string (I
programm java-client) with the values I used in an IN-operator for an
update onto a mySQL database.
The statement looks like this:
UPDATE layer SET State=1
WHERE
I've been trying to contact MySQL AB using the contact us link. I
got a auto-response to the effect that I'd get a real reply in 2 days,
but that was a week ago. My question was about a login that seems to
also go into a black hole.
Has anyone else experienced similar?
--
___ Patrick
Hi,
I have had similar problems with do-table, but never succeded finalizing
my bug-report.
I have added (on master) ...
SET SQL_LOG_BIN = 0 as start of each action where not to replicate data
SET SQL_LOG_BIN = 1 as start of each action where to replicate data
Further I have had some issues
Hi !!
I am trying to install mysql without the server on fedora:
when I issue the command :
[EMAIL PROTECTED] snort-2.2.0]# cd ../mysql-3.23.52
[EMAIL PROTECTED] mysql-3.23.52]# ./configure --without-server
--prefix=/usr/local/mysql
everything is fine but after I issue the command make I
Hi Heikki,
Csongor,
in InnoDB, it is better to use
SELECT ... FOR UPDATE
to lock the result set of a SELECT.
Thank you, I think I will go with this one.
A plain SELECT in InnoDB is a consistent, non-locking read that reads a
snapshot of the database at an earlier time. It does not lock
Hi Ed,
Maybe MyISAM is still a better choice for this use...?
For MyISAM and BDB tables you can specify AUTO_INCREMENT on a secondary
column (or three columns in your case) in a multiple-column index. In
this case, the generated value for the AUTO_INCREMENT column is
calculated as
Csongor,
- Alkuperäinen viesti -
Lähettäjä: Fagyal Csongor [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Kopio: [EMAIL PROTECTED]
Lähetetty: Monday, September 13, 2004 3:36 PM
Aihe: Re: Dump question: transactions vs. locking
Hi Heikki,
Csongor,
in InnoDB, it is
I am generating a backup of a database using mysqldump and using that dumped file to
repopulate another database.
The dump and import process work just fine, BUT I am having some problems in my
application with some enconding issues.
For example, one of the rows that mysqldump outputs is the
perror 144 shows
Table crashed.
Run myisamchk on the host file if you can.
95% full is not good.
Mysql needs free space to do database repairs, schema changes, and index
changes.
If you don't have as much free space as your largest table+index you
have a problem.
diegon wrote:
Hello everybody,
Juan Fernandez wrote:
Hi !!
I am trying to install mysql without the server on fedora:
when I issue the command :
[EMAIL PROTECTED] snort-2.2.0]# cd ../mysql-3.23.52
[EMAIL PROTECTED] mysql-3.23.52]# ./configure --without-server
--prefix=/usr/local/mysql
everything is fine but after I issue the
Hello,
4.1 offers some interesting new features like more secure passwords and
subqueries. However, this release is still labeled a-gamma; on the
other hand it shall be used for future development. What's that a for
(usually for alpha) if it's also stated gamma? Is gamme the last step
until
I see 3 packges:
Mod_auto_mysql-20030510-3.i386.rpm
Mysql-3.23.58-4.i386.rpm
Php-mysql.
Which one to pick
Thanks !!
-Original Message-
From: Alex Greg [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 4:06 PM
To: Juan Fernandez
Cc: '[EMAIL PROTECTED]'
Subject: Re:
Hi Marten,
Hello,
4.1 offers some interesting new features like more secure passwords
and subqueries. However, this release is still labeled a-gamma; on
the other hand it shall be used for future development. What's that
a for (usually for alpha) if it's also stated gamma? Is gamme the
last
I read through the parts of the manual that applied
but I might be missing something here.
I have a table where I'm trying to query the date with
a conditional statement. As you'll see , if 3 was the
condition then the statement should result in a list
of any entries made = current date.
It
I believe that everyone is using the same words to mean different things.
Bruce, when you say grouped around what result would you like to see?
Make up some sample data, or use some of your real data, and demonstrate
what you expected from the database when you say grouped around. When we
Hi!
On Sep 13, Marten Lehmann wrote:
Hello,
4.1 offers some interesting new features like more secure passwords and
subqueries. However, this release is still labeled a-gamma; on the
other hand it shall be used for future development. What's that a for
(usually for alpha) if it's also
I will say it AGAIN :-(
The ODBC drivers (your client if you go through them to access the
database) ARE NOT 4.1+ CLIENTS. The most recent version shows that they
are 3.xx.xx drivers which means that you are using a pre-4.1 client to
access a post 4.1 server. The articles you read describe
Since you do not seem to have subqueries available to you (pre 4.1.x),
have you looked at modifying your queries to use JOINs, temp tables, or
both?
What is it you are trying to accomplish, we can help you to build the
appropriate statement(s). Optionally, you can upgrade to a version that
A whole lot of context would be very useful in helping us understand your
issue:
What is the purpose of the Entry_Table table?
What were you trying to accomplish with the CountBack_Table table?
What were the intended purpose and the expected results of the query that
you couldn't write?
How
Hi,
I have some questions. I need urgent solutions for these. Could you spare some
time for me for helping me. I hope you can.
1) Is MySQL 4.0 Classic version is free downlodable?. If so, can you give me the url
please?.
2) What will be the equivalent of Pro*C API's in MySql?. For
Ok, never mind . I guess a conditional loop is not
needed.
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have some questions. I need urgent solutions for these. Could you
spare some time for me for helping me. I hope you can.
1) Is MySQL 4.0 Classic version is free downlodable?. If so, can you give
me the url please?.
2) What will be the equivalent of Pro*C API's in MySql?. For
Were you able to solve you problem another way or just discouraged by my
response? I wasn't trying to make you feel bad, you just covered so much
ground in your original post that I really couldn't understand your issue.
Please, post again but with a little more background.
We all want to
Shawn, partially discourage but mostly confused about
what I really need to do.
Bear in mind for a moment, that I'm working in a
somewhat untradional manner. Meaning a) very new to
database and SQL b) (and i realize this list is not
for programming languages) using a RAD that allows me
to point,
Juan Fernandez wrote:
I see 3 packges:
Mod_auto_mysql-20030510-3.i386.rpm
Mysql-3.23.58-4.i386.rpm
Php-mysql.
Which one to pick
Thanks !!
Mysql-3.23.58-4.i386.rpm
-- Alex
-Original Message-
From: Alex Greg [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 4:06 PM
To: Juan
Howdy all,
I got this error while running a routine mysqldump
last night: Error 2013: Lost connection to MySQL
server during query when dumping table `contact_log`
at row: 41245
I didn't find any good information on this error at
mysql. Is there a page there that lists all error
codes? I found
Juan Fernandez [EMAIL PROTECTED] wrote:
I am trying to install mysql without the server on fedora:
Don't install Fedora packages.
Install binary packages downloaded from www.mysql.com in RPM format.
You will probably need MySQL-shared and MySQL-client if you don't want
the server.
--
Patrick Connolly [EMAIL PROTECTED] wrote:
I've been trying to contact MySQL AB using the contact us link. I
got a auto-response to the effect that I'd get a real reply in 2 days,
but that was a week ago. My question was about a login that seems to
also go into a black hole.
Has anyone
Marten Lehmann [EMAIL PROTECTED] wrote:
I'm experiencing a strange thing: When bind is running without
bind-address everything works fine. But when I'm doing a bind-address
= ... the clients get Lost connection to MySQL server during query. I
don't understand this, because ot worked once
Joel McConaughy [EMAIL PROTECTED] wrote:
I'm trying to implement a UDF that supports xpath evaluation on a column
using the gnome libxml2 library. The library is thread-safe EXCEPT for
the initialization and deinitialization routines which need to be called
on a pre-process basis. My
Haitao Jiang [EMAIL PROTECTED] wrote:
We are using following steps to re-load and re-build a table every day:
truncate the table
disable index
load data
enable index
What are the important parameters I should be watching out to make the
ebale index step faster? Out table is over
Dan Cumpian [EMAIL PROTECTED] wrote:
According to the documentation, when delay_key_write is active the index
keys aren=92t written to disk until the table(s) are closed. When is a =
table
closed? Is it only when a connection is closed?
When connection is closed, when FLUSH TABLES requested
I have forwareded your question to [EMAIL PROTECTED]
They will contact you soon.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
Mayuran Yogarajah [EMAIL PROTECTED] wrote:
Is there some way to trim the 50gb+ file down ?
Yes, dump the databases using mysqldump, then recreate the autoextend
InnoDB tablespace and then run the .sql script.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Just go to http://dbi.perl.org/
You will need to download DBI and DBD::Mysql. Then you could install it manually,
even no need to run the CPAN shell.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
Stuart,
I feel you pains. I think I can speak for most of us to say we've been
there, too
First, You want to try to keep your column values on the LEFT side of any
inequality. MySQL just goes faster that way.
SELECT
WHERE EntryDate = DATESUB(CurDate(), Interval 2 day )
At 19:41 +0300 9/13/04, Egor Egorov wrote:
Dan Cumpian [EMAIL PROTECTED] wrote:
According to the documentation, when delay_key_write is active the index
keys aren=92t written to disk until the table(s) are closed. When is a =
table
closed? Is it only when a connection is closed?
When
I have a table called issues and other table called users. Issues contains
two fields that are in effect userids that reference the users table. I
want to produce a report with a single query that grabs the names of both
users referenced in the issues table. Is this possible?
I knwo how to do
Hello All
V4.0.16 on Sun Sparc 5.8
Innodb_lock_wait_timeout = 50.
A application using jboss got this error a few days ago. The SQL being used, AFAIK,
was a simple delete from table where date = {date}.
I am trying to determine why this happened. Searching back in the MySQL lists
archives, I
Toro,
this might be a Linux kernel bug. What kernel are you using?
You have done very little processing, the log sequence number is only 400
MB.
Looks like a thread has been waiting for a disk read. The output shows that
the InnoDB 'event' it has waited for is already signaled. In Unix, an
Yes it is possible and you only need to use LEFT join if you need all of
the records from issues whether there are records in users that match or
not.
Just JOIN the users table TWICE and assign each one it's own alias, like
this:
SELECT
FROM issues i
INNER JOIN users u1
on u1.id
Hi,
I have a question about Mysql replication,
I wanted to know how can I replicate a part of a Table data between 2 databases
in mysql4, and not the all tables data.
I already set mysql replication between the databases, and its worked fine,
But I need to filter data to replicate based on
Hi there,
I used very likely statement last week to update one
table. My IN value is around 20. I checked the manual
and there is nothing about any limitation on IN
values.
However, when i was running it, it worked very well
sometimes, while sometimes, the query crashed in the
middle and i have to
IN is a fantastic operator, but there are some limitations especially memory
wise.
Check out this algorithm
Say you're using an Integer with an average of 8 digits, i.e. in the 100s
millions, now you send an in list of say 20 of these 8 digits numbers. Since
the data is passed to mysql as a
Basically the application can get this message because another process has a
lock on the rows that the delete needs to cover for a time period then your
lock_wait_timeout. Is there some cron process? Is the table index properly?
What your average query transaction?
Active your slow query log to
http://dev.mysql.com/doc/mysql/en/Error-handling.html
I would look at your wait_timeout settings, if the mysqldump slept for
greater then this setting then this could be the cause of your error.
Why would the connection sleep? It has to flush the buffer to disk or
STDOUT.
DVP
Dathan
Great explanison. I guest this is the point. after
each time the table crashed during such process, it
always followed a error message saying something about
the memory violation.
Thanks a lot. your idea also open my mind and deeper
my understanding about mysql.
Monet
--- Dathan Vance
DVP - Thanks...
I created a cron job to run show innodb status every minute and dump it to a file. In
additional I turned on innodb_lock_monitor. Hopefully, if this happens again, I will
have a snapshot of the situation.
It's still a bit frustrating not being able to see what was the cause
Hello
When I am connecting to mysql server with another
computer I have no problems. But connecting with a
microcontroller the mysql server is sending the
response very slow. And it is getting slower and
slower. Right now the only way I found is to enlage
the timeout of the microcontrollers so
Shawn - You answered the right question. Since a SQL
statement is closer to my grasp right now , today,
trying that approach.
I think this is something close to correct, though I'm
stuck on what to assign to @usrDays:=
SELECT DateEntry from Entry_Table,
WHERE DateEntry = DATE_SUB(CurDate(),
I'm wondering whether or not I should implement fulltext searching for 2 letter words
within a product database (HP, TV, G5, LG, etc)... My searchable text is currently
about 600Mb and a 3-letter fulltext index is consuming about 420Mb.
Is the trade-off for user convience vs. performance worth
Don't do an @usrDays, just stick the number in there so that the
statement you create looks exactly like the one you tested with.
If you get a number from a user from a form, just put that value into
the string. For instance if the user enters 43 into a field on the first
page, put 43 into
Well, it does not sound to be a problem with the MySQL server if you get
a good response from other computers but just not the microcontroller.
As far as improving the performance of MySQL is concerned, check the
MySQL docs and tons of info when you search google.
- Aman
Jonas Fischer wrote:
The problem is that before (like last friday) there
was no problem. The terminals (applications with
microcontrollers) were connecting rapidly to the
server. Today I checked and they will not connect
unless I increase the timeout for the response time of
the server inside the program code of the
Is the MySQL server 4.1 - default installed? Did you change any
parameters (variables) for it?
Have you checked the network performance otherwise?
I can't really think of anything that the MySQL server is causing,
though the Linux server could be having an issue, with hardware or
something.
i
The problem is solved.
The server has two network cards. One was not
connected. So I assume that the server was frequently
asking the card which was not connected for a
response. Therefore the performance of the server went
down and the response time for querys went up.
Thank you for your help
Thanks for the reply, much appreciated.
this might be a Linux kernel bug. What kernel are you using?
/proc/version
Linux version 2.4.26-ow1 ([EMAIL PROTECTED]) (gcc version 3.2.2 20030222 (Red
Hat Linux 3.2.2-5)) #3 Wed Apr 28 13:39:23 NZST 2004
The problem had been happening approximately once a
A friend of mine, who is not a member of the MySQL email aliases, is working toward
her Bachelors degree. She is currently taking a database design course. She mentioned
her current assignment to me and I suggested she allow me to forward this request to
this email alias. I understand this is
Hi
I have installed some software on aix5.2 .
the list of software:
apache-1.3.29-1.aix4.3.ppc.rpm
php-4.0.6-5.aix4.3.ppc.rpm
MySQL-3.23.47-3.aix4.3.ppc.rpm
MySQL-client-3.23.47-3.aix4.3.ppc.rpm
All of them was installed by using the command : rpm -i *.*
then
Apache and php can work
but
Hi
I have installed some software on aix5.2 .
the list of software:
apache-1.3.29-1.aix4.3.ppc.rpm
php-4.0.6-5.aix4.3.ppc.rpm
MySQL-3.23.47-3.aix4.3.ppc.rpm
MySQL-client-3.23.47-3.aix4.3.ppc.rpm
All of them was installed by using the command : rpm -i *.*
then
Apache and php can work
I am fairly new to MySQL and I have been trying to form a way to have select rows
numbers put back to 0, sort of like a reset in some rows of the table.
The table is ladder_1 and I am trying to have the fields
rank,lrank,wins,loss,games,percent,streak,points,kills on all the rows updated back
66 matches
Mail list logo
