2011/1/25 Robinson, Eric :
>> your whole solution is crippled because why in the world are
>> you killing your salves and reinit them without any reason daily?
> There is a very good reason: it is the phenomenon of row drift. The
> master and slave can appear to be in good sync, but often it is not
Hi Brad,
2010/6/8 Brad Scott :
[...]
> Any line beginning with just a number (ie 9, 10, 16) causes a failure. What
> am I missing?
you should add backticks ( ` ) at both ends of the column name, e.g.
`7c` varchar(255) NOT NULL default '',
I think your export should have been done with the opt
2010/5/28 Manasi Save :
[...]
> Or am I doing something wrong?
probably;
you better send us another e-mail writing at least:
- mysql version you are using
- mysql Connector/J version you are using
- piece of java code you are using to call the stored procedure
- source of the stored procedure (or
AFAIR you can use LIMIT with replication only if you use row-based
replication (or mixed), that means that you must use mysql 5.1.
Greetings,
Mattia.
2010/4/28 Tom Worster :
> 16.3.1.9. Replication and LIMIT
> Replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT
> statements is
2010/3/11 Peter Chen :
[...]
> I am not sure whether do I need to modify something else? Like my application
> code.
as stated on the webpage you just posted here:
---
An application signals that it wants a transaction to be read-only by calling
Connection.setReadOnly(true), this replication-
2010/3/11 Peter Chen :
[...]
> Does someone have met this problem? How to implement the separation of
> read and write?
please, write us some more details about your application!
For example, if you use java with the Connector/j jdbc driver, you can
enjoy a really
nice feature already implemented
2009/12/27 Victor Subervi :
> mysql> select * from products;
[...]
> mysql> select last_insert_id() from products;
[...]
> Now, I was expecting 1, not 0! What up?
[...] LAST_INSERT_ID() (no arguments) returns the first
automatically generated value successfully inserted for
an AUTO_INCREMENT colum
2009/12/13 Victor Subervi :
[...]
> Please advise.
review your sql: you are inserting into
tem126072414516
and selecting from
tem126072385457
( Asterisk in Pinter Tibor's mail means "bold" )
Greetings,
Mattia Merzi.
--
MySQL General Mailing List
For l
here you are:
http://forge.mysql.com/wiki/Contributing
Greetings,
Mattia Merzi.
2009/5/27 mugisha moses :
> hi all
> am new to opensource. iam a finalist student doing computer science in
> East Africa. i would like to start contributing to the mysql project.
> can u guys give me
2009/5/13 Mauricio Tellez :
> Hi, I'm developed a trigger with mysql version 5.0.51(ubuntu), and when I
> tried to move this to a production server (version 5.0.22 fedora) I ran into
[...]
> but mysql say there is an error near EXISTS cfe_tg_calculas_consumos. Of
http://dev.mysql.com/doc/refman/5.
2009/3/14 :
[...]
> So instead of thinking that I am an idiot, try using your intelligence and
> try to understand what I am really talking about!
... instead, try to point us to a chapter of a book or take your time
and write a short paper, 'cause my (stupid) intelligence suggests
me that (maybe)
2009/3/13 :
>> I have a database logging weather data. When a station does not report a
>> temperature, it is set to NULL. It would be a very bad idea to set it to 0
>> as this would ruin the whole statistics.
>> NULL is a perfectly valid information in many cases.
> I'd use -9., I'd neve
even to Paul for the "really-tiny-but-really-appreciated"
answers to my questions!
Mattia Merzi.
2009/3/10 Jerry Schwartz :
[...]
> [JS] There is no free lunch, but sometimes you get a free appetizer. Within
> limits, you will get better throughput if you have multiple transactio
Hi everyone,
I've got some problems with deadlocks on InnoDB tables.
On paragraph 13.6.8.10. "How to Cope with Deadlocks"
of the mysql 5.1 version, the last sentence states:
--
Another way to serialize transactions is to create an auxiliary
“semaphore” table that contains just a single
x27;t know for certain that such an identifier
> exists or how I would show it via a select statement. Any suggestions?
DELETE FROM yourtable WHERE foo=bar LIMIT 1
should do the job.
Greetings,
Mattia Merzi.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
15 matches
Mail list logo
