Is it possible, in single-line inserts, with on duplicate key clauses, to
get back a list of last insert id's for what was inserted?
I get strange results, just one single insert id, which makes sense from the
perspective of what was just inserted, however, I need to know what the
returned insert
I'm not sure why you say 30 or more inserts will take too long. As
long as you do a bulk insert, it's just a single command. 30
individual insert will take it's toll.
You are really looking for a logging system. Your not going to be
querying the table all that much, just a lot of inserts. S
We have MySQL 5.0.27 running on about 10 different RedHat EL4 boxes,
all from the same RPMs. Every night we run mysqladmin flush-logs from
crontab (as well as some other things) on most of these servers.
One on server, mysqld is dying with signal 11 every single night right
during the mysqladmin
Have a look at my, with an update way overdue but allthesame, myProcDbg
project at sourceforge. I think this might do what you are looking for.
/Karlsson
sol beach wrote:
Oracle provides a stored procedure called DBMS_OUTPUT which primarily is
used to write/print/display text string to Standard
I'm working on a Subversion interface to MediaWiki and am struggling
with the SQL to respond to Subversion's update-report:
http://www.mediawiki.org/wiki/WebDAV
MediaWiki's revision table contains unique revision ids and the
corresponding page id. The page table contains unique page ids and the
co
That probably means the optimizer is rejecting (part of) the index as
not selective enough to be efficient for the given query, depending on
storage engine index statistics.
Making sure your indexes are up to date can help on certain storage
engines (MyISAM). ANALYZE TABLE does this for you.
After spending half the night trying this same query on a
number of different datasets, it looks like sometimes MySQL
/will/ use all parts in certain cases, so I'm satisfied by
that. Thanks for responding!
Eamon Daly
- Original Me
Zack Wickes
VP Software Operations
Yummy Interactive Inc.
604-682-0471 Ext:232
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Eric Frazier wrote:
Daevid Vincent wrote:
This has been asked for many many times on this list, not sure why
mySQL AB
doesn't just release a command line tool like a 'mysql diff' and also a
'mysql lint'. The lint one should be totally trivial for them to do,
as they
already have a SQL parser!
Daevid Vincent wrote:
This has been asked for many many times on this list, not sure why mySQL AB
doesn't just release a command line tool like a 'mysql diff' and also a
'mysql lint'. The lint one should be totally trivial for them to do, as they
already have a SQL parser! I can't tell you how ma
Hi!
SQL Maestro Group announce the release of PHP Generator for MySQL 7.10,
freeware MySQL GUI frontend that allows you to generate high-quality MySQL
PHP scripts for the selected tables, views and queries for the further
working with these objects through the web.
http://www.sqlmaestro.com/prod
Ratheesh K J schrieb:
Thanks,
It helped me a lot. I wanted to know
1. what are the various scenarios where my replication setup can
fail? (considering even issues like network failure and server
reboot etc). What is the normal procedure to correct the failure
when somethi
Ratheesh K J schrieb:
Hello all,
What is the best possible values in my.cnf for a 8 processor (Quad core-2 cpu)
8 GB RAM machine dedicated for MySQL server only. No other application will run
on this machine.
the innodb_buffer_pool_size cannot accept values above 2000 MB due to 32 bit
machin
Hello all,
What is the best possible values in my.cnf for a 8 processor (Quad core-2 cpu)
8 GB RAM machine dedicated for MySQL server only. No other application will run
on this machine.
the innodb_buffer_pool_size cannot accept values above 2000 MB due to 32 bit
machine constraint. So what ot
Scott Haneda wrote:
Scott Haneda wrote:
I have an a table of objects, attached to those objects are keywords.
Users submit the keywords to the objects.
Currently, I chose to keep a hit count on the keywords, so if a duplicate
keyword is supplied, a counter is incremented.
I thought this was a
> Scott Haneda wrote:
>> I have an a table of objects, attached to those objects are keywords.
>> Users submit the keywords to the objects.
>>
>> Currently, I chose to keep a hit count on the keywords, so if a duplicate
>> keyword is supplied, a counter is incremented.
>>
>> I thought this was a
Scott Haneda wrote:
I have an a table of objects, attached to those objects are keywords.
Users submit the keywords to the objects.
Currently, I chose to keep a hit count on the keywords, so if a duplicate
keyword is supplied, a counter is incremented.
I thought this was a good idea, as it keep
I have an a table of objects, attached to those objects are keywords.
Users submit the keywords to the objects.
Currently, I chose to keep a hit count on the keywords, so if a duplicate
keyword is supplied, a counter is incremented.
I thought this was a good idea, as it keeps the number of rows i
On 9/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> I don't think you're gaining anything by doing this though, unless it is
> extremely expensive to do a lookup in item.
Thanks Baron,
I wanted to be sure I didn't miss a key feature.
As the lookup in item is not expensive at all, I will keep
19 matches
Mail list logo