Hi,
I have had same issue for very long time - but managed.
I see this as a bug / issue to be handled by MySQL - because the
logfile/replicationfile should not add more data then the orig SQL from program
- in this case is added the auto-increment, which is dealt with internal by
MySQL.
Best
Sorry, I didn't understand your replay.
Is not clear to me if you are talking about a mysql bug and there is some
solution available.
Please, Can you expand more on your answer.
Regards, Enzo
-Messaggio originale-
Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Inviato: giovedì 29
hi to all
i have mysql5.1 installed on fedoracore3
it was worked sucsessfully since yesterday.
but when i run mysql_safe script today, it prompt following error:
STOPPING server from pid file /usr/local/mysql/var/localhost.localdomain.pid
Hi,
Did you check your error log file?
Is there allready a pid file in the directory? You have to delete this
one first.
Hope this helps :-)
Danny
ali asghar torabi parizy wrote:
hi to all
i have mysql5.1 installed on fedoracore3
it was worked sucsessfully since yesterday.
but when i
Thanks for your kind words of opinion, if you feel you have a better
way please do go ahead , i am going to show you the sql i ended up
using which was a union to append the current summary at the end, i
then had to use php afterwards to add up the totals as i was getting
unexpected results
On 28/12/2005, [EMAIL PROTECTED] wrote:
I don't think there is any way with plain-old SQL (extended or
otherwise) to do it in a single statement (unless you are doing it
iteratively - that is: in a stored procedure and row-by-row).
USE test;
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (
i
An error is only thown during an INSERT or UPDATE statement, otherwise
you just get a warning.
- ERROR_FOR_DIVISION_BY_ZERO
Produce an error in strict mode (otherwise a warning) when we encounter
a division by zero (or MOD(X,0)) during an INSERT or UPDATE. If this
mode is not given, MySQL
Dan Rossi [EMAIL PROTECTED] wrote on 12/29/2005 07:19:13 AM:
Thanks for your kind words of opinion, if you feel you have a better
way please do go ahead , i am going to show you the sql i ended up
using which was a union to append the current summary at the end, i
then had to use php
Thanks for the advice David. I opted for your method 2 and symlinked to
my database files which now reside on a FAT32 partition.
Unfortunately, I've hit a slight issue which I'd like to run past you,
but I do think this could turn out to be a FAT32 problem rather than a
MySQL one.
Hi James, all!
James Brown wrote:
Thanks for the advice David. I opted for your method 2 and symlinked to
my database files which now reside on a FAT32 partition.
Unfortunately, I've hit a slight issue which I'd like to run past you,
but I do think this could turn out to be a FAT32 problem
Mr Ikar of Core Team Lam give me a different answer ( see belowe ):
This is MySQL server bug - it specifies wrong length for fields from SHOW
statements. We avoided this bug in MyDAC 4 code.
Can someone confirm me such bug with mysql, and when it sould be solved ?
Mr Paharenko, I route your
Hi Dan, all!
Dan Rossi wrote:
Hi, im having some issues with a sub query in mysql5 , i have a field
which is storing a static comma seperate list of primary keys ie 1,2,3,4
Call me pedantic, but I get suspicious:
Is that a list of the four values 1, 2, 3, 4, or is it rather a
single
Less optimal solution:
Create a DNS round-robin alias, say
mydatabase.myinternaldomain.com, that point to S2-4.
Optimal solution:
Set up a real load balancer, hardware based or software based
(http://www.linuxvirtualserver.org/), and have it configured to distribute
your
Trying to help you with your replication problems is pretty much
impossible without more information, such as: mysql versions and a more
detailed explanation of your replication setup.
I manage setups ranging from 1-14 replication slaves transmitting up to 2
gigabytes of data per day, and none of
Hi James,
Check the whole /mnt filesystem hasn't been mounted read-only.
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/*
I've got a MySQL table that I'd like to have the current date,
CURDATE(), as the default in a column. I'm using knoda to worj with this
table. How do I use knoda to get this done? I can enter CURDATE() in the
default using the GridColumns button, but all that does is insert the
phrase CURDATE().
Hello.
but the problem is the same and the command 'show slave status' report
a skip_counter filed equals 0.
Where I am wrong , some can help me ?
This variable is the number of events from the master that a slave
server should skip. sql_slave_skip_counter decrements each time the
Hello.
there, in fact, anything important in that ibdata1 file, or can I just
shut down mySQL, move that file somewhere else, and then re-start mySQL?
Yes, this file contains important information.
Is this possible, or am I stuck having my database server off-line for
hours while the
Hello.
For auto_increment columns MySQL sets in the binary logs INSERT_ID
variable, research binary and relay logs and check if it is set to
the same value. Is it possible that you forgot to change the
master_log_pos and master_log_file after copying the data to the slave?
Hello.
Is there any good idea to load balance for our mysql servers?
I'm not sure, but have a look at High Performance MySQL by
Jeremy D. Zawodny. This is a snip from it's publically available
chapter.
###
Real-time data
Hello.
From the manual:
ANSI
Equivalent to REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE.
Before MySQL 5.0.3, ANSI also includes ONLY_FULL_GROUP_BY. See Section
1.8.3, âRunning MySQL in ANSI Modeâ.
wangxu wrote:
I set my sql_mode =
thanks
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Thursday, December 29, 2005 10:38 PM
Subject: (ÈðÐÇÌáʾ-´ËÓʼþ¿ÉÄÜÊÇÀ¬»øÓʼþ)RE: set sql mode
An error is only thown during an INSERT or UPDATE statement, otherwise
you just get a
On 12/28/05, Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
#1054 - Unknown column 'CommentsIDX' in 'where clause'
My table structure contains:FULLTEXT KEY `CommentsIDX` (`Comments`)
You should use column names not index names in your queries. Please,
provide CREATE statement for your
Yes,I already read this section.
But, maybe there are haven't relation to my question.
Are the effect of setting IGNORE_SPACE in sql mode allowing add space between
function name and (?
If my attitude is right,then if i haven't setting IGNORE_SPACE in sql mode,I
shouldn't add space between
I forgot to mention - I'm running MySQL 4.0.14 on Linux. And I'm not very
knowledgeable on databases. I just use MySQL with Knoda to get the job done.
==
I've got a MySQL table that I'd like to have the current date,
CURDATE(), as the default in a column. I'm using knoda
AS 1.7.3. Running MySQL in ANSI Mode explain:
--
Running the server in ANSI mode is the same as starting it with these options
(specify the --sql_mode value on a single line):
--transaction-isolation=SERIALIZABLE
[in reply to [EMAIL PROTECTED], 28-12-2005]
Hi,
MySQL 4.1.10a on FreeBSD 5.4-RELEASE-p6
ERROR 1030 (HY000): Got error 12 from storage engine
Strangely, this problem does not appear when mysqld is restarted and I
retry the query. When I wait a day, the error starts to appear again.
It seems
At 11:50 +0800 12/30/05, wangxu wrote:
AS 1.7.3. Running MySQL in ANSI Mode explain:
--
Running the server in ANSI mode is the same as starting it with
these options (specify the --sql_mode value on a single line):
Is there a simple way of checking whether all the columns in a SELECT
are NULL? I know I can do the following:
SELECT c1, c2, c3 FROM t WHERE COALESCE(c1, c2, c3) IS NOT NULL
but this relies on specifying every column I've selected (which in my
actual code is a lot of columns that may change
other than what Gleb says,
you can avoid the error using 'insert ignore into' or better yet
'replace into'
for every insert statement
AESYS S.p.A. [Enzo Arlati] wrote:
I'm trying to use teh parameter sql_slave_skip_counter at run-time to
restore slave replication.
When a slave replication
30 matches
Mail list logo
