 | | | MySQL General | | Hi
Configure my.cnf in such a way so that it uses 3.5 GB of physical memory.
Please check max_connecions. Out of memory problem also occur due to lots of
connections
Thanks
Krishna
On 9/27/07 AmaIs 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 sensI '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 aWe 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 servHave 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 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 unThat 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 indexeAfter 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 respon
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.mysqlEric 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 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 oHi!
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 qRatheesh 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 fRatheesh 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 onHello 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_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 > 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 keywordScott 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 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 suOn 9/26/07 Baron Schwartz <baron@(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
Hi Mathieu
I found that innodb_buffer pool value isn 't set..The whole innodb
settings are commented.
I found the below values from the my.cnf file
# Uncomment the following if you are usinIt is way past bed time so excuse me if I am way off...
What is the order of tables in the explain? What is shown as the select_type?
On 10/2/07 Eamon Daly <edaly@(protected) > wrote
> Hi 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 tHi all. I couldn 't find this mentioned in the docs or in
the archives so I 'd figure I 'd ask. I have a table with a
multipart index on three columns. When querying the table
alone using IN operators --
Rob Wultsch
(480)223-2566
wultsch@(protected) (email/google im)
wultsch (aim)
wultsch@(protected) (msn)
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscribeYes. Sorry I wasn 't verbose enough. I agree with you. And I also
agree that this part of the manual is kind of nonsensical. I have never
understood it fully. Part of what I was saying is "I woThanks for the quick reply Barron but doesn 't SET AUTOCOMMIT 0 disable AUTOCOMMIT ?
from http //dev.mysql.com/doc/refman/5.0/en/lock-tables.html
The correct way to use LOCK TABLEHi William
William Newton wrote
> Hello List
>
> I discovered an unusual problem with the way Innodb handles the AUTO_INC lock with a full table lock. I was wondering if this is a known issue orHello List
I discovered an unusual problem with the way Innodb handles the AUTO_INC lock with a full table lock. I was wondering if this is a known issue or I 'm doing something completely wrong. I 'On Mon 2007-10-01 at 12 56 -0700 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 ' an |
|
|
