Phil,
What happens if you drop the index when you do the update? Does it
run faster? If so then the index is slowing you down. Try increasing the
key_buffer_size to 756M. If there isn't much difference, try the update
without the "Order By" clause. If it runs considerably faster, then you
At 03:49 PM 2/7/2008, [EMAIL PROTECTED] wrote:
Thanks very much. The default mysql behavior is a little
unusual. What is the parameter in my.cnf to control the cache
size before forcing a flush. I waited for 2 mininutes second
before the output came out without the -q option. My server
is fast e
I'm trying to write an update which generates ranking data for a table.
Table is as follows
CREATE TABLE `A` ( `id` INT NOT NULL ,
`score` DOUBLE NOT NULL ,
`projrank` INT NOT NULL ,
`other` VARCHAR( 10 ) NOT NULL
) ENGINE = MYISAM
Real table actually contains 30 or so more fields but it gives a
> > Hello!
> >
> > I am looking for an easy solution for eliminate duplicates but on a row
> > level.
> >
> > I am having 2 tables. 1 destination for all not duplicated info (a)
> > and 1 for input table (b) which might have duplicates related to table
> > a. Now I am using this kind of insert:
>
From the download page:
Please note that at this point only the Windows Beta version is
available. Linux and OS X releases will be available in 2008.
It looks nice, I was looking for a similar tool 5 -6 years ago. It looks
like what I would have wanted at the time.
legolas wrote:
Is ther
Is there any plan to release the second link (workbench) for linux?
thanks
John Comerford-2 wrote:
>
> http://dev.mysql.com/downloads/gui-tools/5.0.html
> http://dev.mysql.com/workbench/
>
> legolas wrote:
>> Hi
>> thank you for reading my post
>> Is there a development workbench or developme
http://dev.mysql.com/downloads/gui-tools/5.0.html
http://dev.mysql.com/workbench/
legolas wrote:
Hi
thank you for reading my post
Is there a development workbench or development/ administration studio
available for linux?
Whether from MySQL AB itself or other 3rd party companies?
Thanks
-
Hi
thank you for reading my post
Is there a development workbench or development/ administration studio
available for linux?
Whether from MySQL AB itself or other 3rd party companies?
Thanks
--
View this message in context:
http://www.nabble.com/Is-there-any-workbench-or-development-studio-avai
Thanks very much. The default mysql behavior is a little
unusual. What is the parameter in my.cnf to control the cache
size before forcing a flush. I waited for 2 mininutes second
before the output came out without the -q option. My server
is fast enough to read in more than 2 GB data during this
Hi Magne
>...the query I actually want to use this in, is a 100 line query with
lots of arguments.
>I don't feel to good about creating it into a bunch of strings (16)
that I have to
>concatenate with the variables inbetween.
The only alternative I know for current versions of MySQL is to ass
In the last episode (Feb 07), [EMAIL PROTECTED] said:
> I just stumbled on this hard to explain problem. Below
>
> select * from BigTable (BigTable has 5 million rows)
>
> takes forever to even print out the first row. as you could see from
> the sql, it is supposed to print out some rows ri
Hello:
I just stumbled on this hard to explain problem. Below
select * from BigTable (BigTable has 5 million rows)
takes forever to even print out the first row. as you could see
from the sql, it is supposed to print out some rows right away
regardless of server config in my.cnf. What is
Hi,
Thanks a lot Peter, that was useful and it worked fine. The only problem
is that the query I actually want to use this in, is a 100 line query
with lots of arguments. I don't feel to good about creating it into a
bunch of strings (16) that I have to concatenate with the variables
inbetwee
Hi, all,
I had a server crash a few weeks ago and had to
restore my mySQL installation from backup after
reinstalling Fedora.
After the restore operation, I was no longer able to
log into mySQL, either as root or as myself. I believe
this may be because the UID in the recovered database
is now di
Magne,
Sorry, the server is down at the moment, here is the entry ...
To have an sproc accept a variable-length parameter list for an
|IN(...)| clause in a query, code the sproc to |PREPARE| the query
statement:
|
DROP PROCEDURE IF EXISTS passInParam;
DELIMITER |
CREATE PROCEDURE passInParam(
Magne,
>I want to create a stored procedure that runs a query using the "IN"
operator ...
See 'Variable-length argument for query IN() clause' at
http://www.artfulsoftware.com/queries.php
PB
-
Magne Westlie wrote:
Dear List,
I want to create a stored procedure that runs a query usin
Dear List,
I want to create a stored procedure that runs a query using the "IN"
operator (or is "IN" a function???) on values sent as argument. That is,
my procedure should be called with something like:
CALL get_users((1,2));
and I was hoping to implement something like this:
CREATE PROCED
Hi,
On Feb 6, 2008 4:47 PM, Olaf Stein <[EMAIL PROTECTED]> wrote:
> Hi All
>
> I am trying to run this query:
>
> update minpheno set TMP_ados_version='0' where ident=898;
> On below table:
>
> And get error 1136
> ERROR 1136 (21S01): Column count doesn't match value count at row 1
>
> How can tha
On 07.02.2008 03:52 CE(S)T, Chris wrote:
If you don't mind a mysql-specific "fix", and can get the data you want
from a select query you could:
insert into table (select goes here) on duplicate key update;
or maybe a replace into ?
INSERT/REPLACE ... SELECT will always overwrite the entire r
19 matches
Mail list logo