single line inserts with on duplicate key

2007-10-03 Thread Scott Haneda
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

Re: Design decision

2007-10-03 Thread Brent Baisley
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

MySQL crashing on flush-logs

2007-10-03 Thread Ofer Inbar
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

Re: What is MYSQL's equivalent to Oracle's DBMS_OUTPUT

2007-10-03 Thread Anders Karlsson
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

SQL for Subversion update-report

2007-10-03 Thread Jack Bates
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

Re: Multipart + IN comparison on the second part + JOIN does not use full index

2007-10-03 Thread Baron Schwartz
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.

Re: Multipart + IN comparison on the second part + JOIN does not use full index

2007-10-03 Thread Eamon Daly
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

allow me to post

2007-10-03 Thread Zack Wickes
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]

Re: DB Schema Comparison Utility ?

2007-10-03 Thread Baron Schwartz
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!

Re: DB Schema Comparison Utility ?

2007-10-03 Thread Eric Frazier
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

ANN: Freeware PHP Generator for MySQL 7.10 released

2007-10-03 Thread SQL Maestro Group
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

Re: [Replication] - urgent

2007-10-03 Thread Jan Kirchhoff
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

Re: MySQL Configuration for a powerful server?

2007-10-03 Thread Jan Kirchhoff
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

MySQL Configuration for a powerful server?

2007-10-03 Thread Ratheesh K J
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

Re: Design decision

2007-10-03 Thread Chris
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

Re: Design decision

2007-10-03 Thread Scott Haneda
> 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

Re: Design decision

2007-10-03 Thread Chris
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

Design decision

2007-10-03 Thread Scott Haneda
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

Re: How to use an hardcoded list of values

2007-10-03 Thread Manuel Vacelet
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