Judging by some of the comments posed on this list, I wonder whether the
following statements are true:
1. There is no point having an index on a field if that field can only have
a few values
2. A table should have at least ten entries, in order to prevent all the
table being scanned to find a mat
The query itself executes quite fast, but as it's one of the most frequently
executed queries in the entire program, I thought it important to make it as
fast as possible.
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 11:40 PM
To: mysql
Cc
Hi!
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, January 21, 2004 2:35 AM
Subject: how to access iblog file?
> Hi all,
>
> i have run mysql ver 8.21 distrib 3.23.43 for win. i use innodb
> architecture in my database. i have trouble
Alex,
diagram:
record1 'gap' record2
(User A holds a next-key lock on record2)
InnoDB can lock the non-existence of a row in the 'gap'. But it cannot
presently make another user B to wait before B acquires a lock on the gap.
The reason is that B's cursor has already passed the gap when B ends up
Keith,
please see my reply to Mikel in thread 'Too slow recovering mysqldump
files'.
Since you are running a 64-bit version, you can set innodb_buffer_pool_size
as high as 3 GB in your hardware. You can monitor the progress of the big
ALTER TABLE with
SHOW INNODB STATUS\G
Best regards,
Heikki
I am new so forgive me if i'm asking a stupid question. I did a reinstall (rpm) of my
mysql 3.23 running on SuSE8.0 when I tried to run msql after running msql_install_db I
get the error below. Just to give some bacground info. After getting connection errors
regarding permissions (see previous
Mikel,
it is apparently disk-bound.
I recommend setting innodb_buffer_pool_size as high as 1.4 GB during such
big import. Adjust innodb_log_file_size accordingly, and make key_buffer
smaller during the big import.
Help is coming: Marko Mäkelä is writing a compressed InnoDB table format,
which ca
- Original Message -
From: "Peter J Milanese"
Sent: Tuesday, January 20, 2004 1:37 PM
Subject: RE: Slow query times
>
> You may also want to try :
>
> count(1)
>
> instead of
>
> count(*)
>
>
> count(*) pulls back the data while count(1) does not.
Completely untrue...
Matt
--
Hi Balazs,
The likely answer is the one that nobody mentioned: it's an optimizer
bug in 4.0.16. If you look at the EXPLAIN output for the second query,
it's probably using a ref type on the sex column, instead of the more
restrictive id index. If so, that's the bug. From
http://www.mysql.com/do
Annie Law wrote:
> First, I went to the MySQL website to look up the section
> on Unix Post-installation Procedures. I then tried the
> following as root and got the following result:
>
> --
> -
I'm new to all of this, but I recently installed a
preconfigured package with Apache, PHP, MySQL and
PHPMyAdmin from "ApacheFriends" (XAMPP). I tried a
couple other packages, but they didn't work. XAMPP has
been wonderful so far, but I goofed when I tried to
connect MySQL with Dreamweaver.
I was r
Is there any way to disable replication of all temp tables using
replicate-ignore-table or some other means? The names of the temp tables
are generated randomly by a script. Thanks
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
I forgot to mention too that this is the 64bit MySQL 4.0.17
running on Solaris9.
>Hi all,
>I decided I needed another index in an InnoDB table that has about
>25 million rows (each 80 bytes long). As I've done dozens of times
>with MyISAM tables, I did a simple "alter table":
> alter table
Hi all,
I decided I needed another index in an InnoDB table that has about
25 million rows (each 80 bytes long). As I've done dozens of times
with MyISAM tables, I did a simple "alter table":
alter table WMH_CHK_a add key JoinTrans (TransID)
This has been running for 14 hours and I have
This is a new install of mysql 3.23 on a SuSE8.0 Box. I installd everythign via suse
rpms. I ran mysql_install_db when I to run the update root password I get the
following error. I'm logged into the server via ssh as root while exicuting the
commands. any ideas.
inglewood:/etc # mysqladmin
Lynch 'im!!!
:-)
On Wed, 21 Jan 2004 13:33, Jochem van Dieten wrote;
> Douglas Sims wrote:
> >
> > You should check out: http://onlamp.com/ L.A.M.P.
> > (Linux/Apache/MySQL/Perl(or PHP)
>
> Or Linux/Apache/Middleware/PostgreSQL ;-)
>
> Jochem
>
> --
> I don't get it
Hi all,
i have run mysql ver 8.21 distrib 3.23.43 for win. i use innodb
architecture in my database. i have trouble access iblog file. Anyone know
how to access iblog file ?
Thanks in advance.
-M. Amrin-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
Douglas Sims wrote:
You should check out: http://onlamp.com/ L.A.M.P.
(Linux/Apache/MySQL/Perl(or PHP)
Or Linux/Apache/Middleware/PostgreSQL ;-)
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Hi Ken,
I have compile MySQL with this param : -D SKIP_DNS_CHECK
As i have upgrade with portupgrade and forget to repass param, i have put
dns off on my.cnf
I will check if make -D SKIP_DNS_CHECK work. If yes, the problem is not dns
resolve.
I hope it's bad param pass to makefile :)
Thanks fo
I know that. I'm lookign for mysql function that will increment the value.
From: Tobias Asplund <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Mike Mapsnac <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: Increment value Date: Tue, 20 Jan 2004 23:36:22 +0100 (CET)
On Tue, 20 Jan 2004
On Tue, 20 Jan 2004, Mike Mapsnac wrote:
> In the table value login_count is int(4). For example if value login_count
> equal to 3 and each time user login I want to increment by one.
>
> update customer set login_count='how?" where id=12121212;
SET login_count = login_count + 1
--
MySQL Gene
Here we are my options:
set-variable = innodb_log_file_size=150M
set-variable = innodb_log_buffer_size=8M
I follow the example that came here:
"http://www.mysql.com/doc/en/InnoDB_start.html";
Greetings and best regards
Mikel
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sub
Thx's Fred...
as soon as I sent the email and re-read it again... I spotted the 'as' alias
table reference to the table, was actual a reserved word,..causing the error :)
thx's again.
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solu
In the table value login_count is int(4). For example if value login_count
equal to 3 and each time user login I want to increment by one.
update customer set login_count='how?" where id=12121212;
What function I should use in order to icrement the value?
__
Mike Blezien said:
>
> I've been looking at this SQL query a dozen times or more, but keep
> getting a syntax error message, Query:
>
> SELECT ai.affilid,ai.create_date,CONCAT(ai.fname,' ',ai.lname) AS
> name,aw.siteid,ai.email,as.username,as.status
> FROM affiliate_info ai,affiliate_signup as,aff
On Tue, Jan 20, 2004 at 04:10:44PM -0600, Mike Blezien wrote:
> I've been looking at this SQL query a dozen times or more, but keep getting
> a syntax error message, Query:
>
> SELECT ai.affilid,ai.create_date,CONCAT(ai.fname,' ',ai.lname) AS
> name,aw.siteid,ai.email,as.username,as.status
> FRO
Hello all,
I've been looking at this SQL query a dozen times or more, but keep getting a
syntax error message, Query:
SELECT ai.affilid,ai.create_date,CONCAT(ai.fname,' ',ai.lname) AS
name,aw.siteid,ai.email,as.username,as.status
FROM affiliate_info ai,affiliate_signup as,affiliate_website aw
W
At 02:54 PM 1/20/2004, you wrote:
In general, is it more efficient to do many queries or one "large" query
with many joins?
Good question. :)
I would break it down into smaller queries and use a loop because a large
query, would consume a huge amount of memory and a join needs to create a
tempor
At 11:52 AM 1/19/2004, you wrote:
While doing some benchmarks the other day, I saw surprisingly slow
query results on columns that were indexed.
It's because MySQL won't use the Sex_Index index because the value that you
are searching for (Namely "F" or "M") accounts for more than 30% of the
dat
hi all,
not sure if this is the appropriate place to post this -- so please
point me in the right direction if not here...
I have a G4 with os10.3.2 server, mysql v4.0.16, and MoveableType 2.6
I'm trying to initialise the moveabletype system by running mt-load.cgi
and am recieving the followin
Annie Law wrote:
>
> Hi,
>
> I would appreciate any help on the following. I have searched the mailing list for
> information But have not come up with a solution for my situation which has been
> frustrating. I think I need some things need to be clarified.
>
> The OS that is running is RedHa
Why not:
SELECT * FROM table1, table2 WHERE
table2.columnB = 'this' AND
FIND_IN_SET(table2.columnA, REPLACE(table1.columnA,';',',') ) > 0
Documented here: http://www.mysql.com/doc/en/String_functions.html
Ted Gifford
-Original Message-
From: Tobias Asplund [mailto:[EMAIL PROTECTED]
S
* Noamn
[...]
Please reply to the list. :)
> Adding the composite index doesn't make any difference as far as
> I can see.
> Isn't there a way of forcing a specific index to be used?
Yes. From mysql version 4.0.9 you can write FORCE INDEX, for earlier
versions you can try USE INDEX.
http://www.
On Tue, 20 Jan 2004, Chris Boget wrote:
> > > The data I'm working with looks like this:
> > > table1.columnA = '1;3;4;6;8;9;12;13;14;15';
> > > table2.columnA = '3';
> > > table2.columnB = 'this';
> > > I need to write a query that will do something along these lines:
> > > SELECT * FROM table1,
On Tue, Jan 20, 2004 at 03:02:45PM -0600, Chris Boget wrote:
> > > The data I'm working with looks like this:
> > > table1.columnA = '1;3;4;6;8;9;12;13;14;15';
> > > table2.columnA = '3';
> > > table2.columnB = 'this';
> > > I need to write a query that will do something along these lines:
> > > SE
Hi,
I would appreciate any help on the following. I have searched the mailing list for
information But have not come up with a solution for my situation which has been
frustrating. I think I need some things need to be clarified.
The OS that is running is RedHat V.9.0 linux. MySQL was installe
I will review the log files, I guess that I set the correct size of my
innodb log files, but I'll check it out again.
Best Regards
Mikel
P.S. How about of InnoDB Hot Backup? does it do much faster?
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: Too slow recover
> > The data I'm working with looks like this:
> > table1.columnA = '1;3;4;6;8;9;12;13;14;15';
> > table2.columnA = '3';
> > table2.columnB = 'this';
> > I need to write a query that will do something along these lines:
> > SELECT * FROM table1, table2 WHERE
> > table2.columnB = 'this'
> > AND
>
In general, is it more efficient to do many queries or one "large" query
with many joins?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ignore that silly equation. I tried to simplify and ended up with something
mathematically ridiculous. I'm sure someone can come up with a more
accurate simplification.
Matt
-Original Message-
From: Matt Griffin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 3:46 PM
To: 'Bal
On Tue, 20 Jan 2004, Chris Boget wrote:
> The data I'm working with looks like this:
>
> table1.columnA = '1;3;4;6;8;9;12;13;14;15';
>
> table2.columnA = '3';
> table2.columnB = 'this';
>
> I need to write a query that will do something along these lines:
>
> SELECT * FROM table1, table2 WHERE
>
I'm a java person and I'm happy to say you didn't rouse me. There are
many fine quality in lamp and java. I don't know PHP but I've seen some
really nice apps written in php. It looks like a nice clean language
and very nice for web development.
On Tuesday, January 20, 2004, at 03:34 PM, Doug
I couldn't say without some hard benchmarks. Just keep in mind that an
index still only breaks your data up into fairly large "compartments" which
must be scanned. It's like this:
rows scanned = # rows / (log2(# of options))
At some threshold of log2(# of options) it's faster to scan the whole ta
I hope the question is OK :)
The first 4 queries work fine, the last causes the error. I'm probably
missing something obvious, but this is complex for me.
TIA for any tips,
verdon
GODD
SELECT
volunteers.volunteer_id,volunteers.first,volunteers.middle,volunteers.last,v
olunteers.organi
Hi
You should check out: http://onlamp.com/ L.A.M.P.
(Linux/Apache/MySQL/Perl(or PHP) are becoming the de facto standards for
web-based applications, I think far eclipsing Java (JSP/Servlets) and
Microsoft ASP/VB.
Unlike Java (which is driven to a large degree by Sun's promotion) and
ASP (he
I'm working with data that has not been normalized. If it were
up to me and I had the time, I'd go in and change all the code
so that the data were normalized, but right now that's not an
option.
The data I'm working with looks like this:
table1.columnA = '1;3;4;6;8;9;12;13;14;15';
table2.colum
Ok, thanks for the info. As I said below I am using
Mac OSX version 10.1.5 which has been patched numerous times
from the apple web site. I don't need to speed anything up
on my ibook since the database I am going to create is not
going to be used by multiple users.
~~Nick
--- On Tue
In the last episode (Jan 20), Balazs Rauznitz said:
> On Tue, Jan 20, 2004 at 08:23:32PM +0100, Aleksandar Bradaric wrote:
>
> mysql> explain select count(*) from sex where id>459000 and id <=46 and sex =
> 'M';
> +---+--++---+-+---
I'm running on 10.2.8 just fine. I hear panther speeds up the ibooks.
But that is just what I read.
On Tuesday, January 20, 2004, at 03:16 PM, Nicholas wrote:
Hello Everyone,
I downloaded and installed the
mysql-standard-4.0.17-apple-darwin6.8-powerpc.dmg
file from the mysql web site to my ib
Hello Everyone,
I downloaded and installed the
mysql-standard-4.0.17-apple-darwin6.8-powerpc.dmg
file from the mysql web site to my ibook running
Mac OSX Version 10.1.5 on it.
I read the documentation on the mysql site and it
said to do the following next:
shell> cd /usr/local/mysql
shell> s
It sounds like you are looking for a quickie. Sorry, couldn't resist.
You should run optimize table to make sure your indexes are optimized.
Also, you should check which index is being used first. Your sex column
probably is split 50/50, so if MySQL is optimizing your query to use
the sex index
I have no problem combining MATCH with WHERE and HAVING. Are you sure
there is supposed to be matches? Also, you need to make sure that you
are formatting your date correctly (-mm-dd) for searching in MySQL
if it is a date field you are searching on.
On Jan 20, 2004, at 12:36 PM, Alex Bruck
Hi!
On Jan 20, rmck wrote:
> Help.
>
> I have a REPAIR table command that has been running since 1/15... I
> dont know if its hung or what? Should I kill it ? Top shows that it
> seems to be running?
No, it did not hang - "Repair with keycache" is slow, especially for 23G
file. You should c
Hi.
I use MySQL 4.0.17 from rpm.
When I want insert new row by perl script to one of my table I get such error :
DBD::mysql::st execute failed: Duplicate entry '- Modified the spec file provided by
...' for key 3
Table looks :
mysql> desc spak;
+--++--+-+-
Hardware is Dell PE2650/Dual Xeons (2G) 4G Ram
I have a raid10 array for data volumes.
Bottleneck would be Disk. That's the problem I had, so I went raid10 on
the box.
The most I push is about 10k, and it's not too bad. Complex queries may
suffer during insert times, but you can get around a lot
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On January 20, 2004 02:31 pm, Peter J Milanese wrote:
> It'll work.
>
> I do slight less on the way of inserts. What I do is dynamically generate
> the tables within my entry code, and merge tables based on the query. Good
> for large log parsers. Be
You are perfectly correct. Without the index on sex query times are
lightning fast.
I don't quite get you explanation why; where can I read up on how
queries are done with and without an index ?
Can one make a generalization that unless the number of different
values in a column is less than
-Forwarded by Peter J Milanese/MHT/Nypl on 01/20/2004 02:37PM -
To: <[EMAIL PROTECTED]>
From: Peter J Milanese/MHT/Nypl
Date: 01/20/2004 02:34PM
cc: <[EMAIL PROTECTED]>
Subject: RE: Slow query times
You may also want to try :
count(1)
instead of
count(*)
count(*) pulls back the d
-Forwarded by Peter J Milanese/MHT/Nypl on 01/20/2004 02:36PM -
To: "STE-MARIE, ERIC" <[EMAIL PROTECTED]>
From: Peter J Milanese/MHT/Nypl
Date: 01/20/2004 02:31PM
cc: [EMAIL PROTECTED]
Subject: Re: Advice needed for high volume of inserts
It'll work.
I do slight less on the way of in
I wouldn't imagine that creating an index on a column with only two possible
values could make things any faster. You only get a maximum 50% reduction
in row scans, rather than the normal log based reduction with a random value
distribution. In addition, you contend with the overhead of using the
Hello,
This is my first message on this list. So I take the occasion to salute every
one of you.
I'm looking to implement a database server wich will mostly insert data. The
data structure is not complexe. The data will be insterted in 1 table at
burst rates of 13000 insert/seconds and sust
On Tue, Jan 20, 2004 at 08:23:32PM +0100, Aleksandar Bradaric wrote:
> Hi,
>
> >> > Any way to make this faster ?
> >>
> >> Try to create an index on both fields:
> >>
> >> create index idsex_index on sex (id, sex)
>
> > Tried that; same results...
>
> Could you post the result of the EX
Hi,
>> > Any way to make this faster ?
>>
>> Try to create an index on both fields:
>>
>> create index idsex_index on sex (id, sex)
> Tried that; same results...
Could you post the result of the EXPLAIN command on that
query?
Take care,
Aleksandar
--
MySQL General Mailing List
For l
Hi Joe,
Thanks for your reply. Actually, in my experience (and according to the docs), if you
select 'for
update' or 'lock in share mode', you _can_ lock non-existence of a row for inserts.
In that case I
think the 'gap' where the row would be is locked, and attempts to insert the row from
an
Hi,
I'm new to this group.I would like to know which frontend tools be good tuned with
Mysql database like php,perl etc?
I want to develop one application on linux on mysql database which eventually would be
webbased.Please suggest what combination would be good.
thx
-Seena
--
hi,
Selecting a non-existent row won't acquire any locks that prevents
inserts from happening. One way to accomplish what you want is to
create a separate insert lock table consisting of a table name and a
lock counter. Add a row for each table that you want to have these
insert locks on, and be
Hi,
I'm new to this group.I would like to know which frontend tools be good tuned with
Mysql database like php,perl etc?
I want to develop one application on linux on mysql database which eventually would be
webbased.Please suggest what combination would be good.
thx
-Seena
---
While doing some benchmarks the other day, I saw surprisingly slow
query results on columns that were indexed.
Here's the table definition:
create table sex (
id integer,
sex char(1));
create index id_index on sex (id);
create index sex_index on sex (sex);
Then I loaded a million rows, id was
ps: 'optimize table' seems to have no effect. I was also able to
reproduce this on a different mysql server...
Balazs
On Mon, Jan 19, 2004 at 10:39:26AM -0500, Balazs Rauznitz wrote:
>
> While doing some benchmarks the other day, I saw surprisingly slow
> query results on columns that were in
I am with a problem in one query of simple DELETE.
#1205 - Lock wait timeout exceeded; Try restarting transaction
Why mysql LOCK this line and does not allow that I delete, if I did not
emit none stantment of LOCK?
Please, help me!
Bruno Rodrigues Silva
Brazil.
--
MySQL General Mailing List
F
Don't forget to run "optimize table" after you build
the combined index or make significant changes.
-- Greg
PS: Sorry to hear of MySQL's "gender issues" ;-)
On Mon, Jan 19, 2004 at 10:20:12AM -0500, Balazs Rauznitz wrote:
>
> I saw surprisingly slow query results on columns that were indexed.
While doing some benchmarks the other day, I saw surprisingly slow
query results on columns that were indexed.
Here's the table definition:
create table sex (
id integer,
sex char(1));
create index id_index on sex (id);
create index sex_index on sex (sex);
Then I loaded a million rows, id was
On Tue, Jan 20, 2004 at 07:09:46PM +0100, Aleksandar Bradaric wrote:
> Hi,
>
> > Any way to make this faster ?
>
> Try to create an index on both fields:
>
> create index idsex_index on sex (id, sex)
Tried that; same results...
Balazs
--
MySQL General Mailing List
For list archives: http:
Hi,
> Any way to make this faster ?
Try to create an index on both fields:
create index idsex_index on sex (id, sex)
Take care,
Aleksandar
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have a program which calls a function which has an all-inclusive MySQL
set of code (i.e. MySQL is initialized, used, and released within the
span of the single function). The first time the function is called it
function properly, but on subsequent calls, the function terminates with
a segme
Hello !
I'm trying to figure how to get how many queries are done by each
DB/user and not for the whole MySQL server.
How to know how many queries are done each done for each DB ? MySQL Server
load is heavy and I need to know from which websites...
--
Cedric - mailto:[EMAIL PROTECTED]
(DH/DSS)P
Hi Chris,
Thanks for the response and the suggestions. Doesn't SERIALIZABLE level just add
'LOCK IN SHARE
MODE' to your SELECTs, but other than that works just like the default REPEATABLE READ
level? I've
tried by example below using 'LOCK IN SHARE MODE' instead of 'FOR UPDATE', but the
resul
On Tue, Jan 20, 2004 at 01:25:34PM +0100, Tobias Asplund wrote:
> On Tue, 20 Jan 2004, Marco Paci wrote:
>
> > Since the process of inserting a new record and reading its PK field
> > value is a two step process implemented by:
> > 1) insert into tablename (columnnames) values()
> > 2) select
I saw surprisingly slow query results on columns that were indexed.
Here's the table definition:
create table sex (
id integer,
sex char(1));
create index id_index on sex (id);
create index sex_index on sex (sex);
Then I loaded a million rows, id was from 1 to 1_000_000, sex was
randomly 'F' o
On Tue, Jan 20, 2004 at 12:35:07PM +0100, Marco Paci wrote:
> Environment OS:windows 2003 server, PLATFORM:.NET framework 1.1,
> LANGUAGE:C#, .NET PROVIDER:MySQLDriverCS
>
> In an application I'm developing on top of mysql, I wanna use as primary
> key for tables an autoincrement field.
> Every t
While doing some benchmarks the other day, I saw surprisingly slow
query results on columns that were indexed.
Here's the table definition:
create table sex (
id integer,
sex char(1));
create index id_index on sex (id);
create index sex_index on sex (sex);
Then I loaded a million rows, id was
Help.
I have a REPAIR table command that has been running since 1/15... I dont know if its
hung or what? Should I kill it ? Top shows that it seems to be running?
mysql> show processlist;
++--+---+-+-++--+--
Hi There
i use a query:
SELECT * FROM volltexttabelle ft
LEFT JOIN suchtabelle s ON s.article_id = ft.article_id
WHERE MATCH (ft.index_text) AGAINST ('+"equator" ' IN BOOLEAN MODE )
which works fine
now i want to modify it ie add AND s.search_date>=1980 or other clauses
which
cant be handled b
At 1:25 +0800 1/21/04, mc wrote:
Hi all,
Perhaps this question is not appropriate to ask here, pls point me to the
right direction if I am posting to the wrong list..
I would like to hear from the people of this list, which of the below
notation do you prefer more and perhaps also in what situatio
Hi all,
Perhaps this question is not appropriate to ask here, pls point me to the
right direction if I am posting to the wrong list..
I would like to hear from the people of this list, which of the below
notation do you prefer more and perhaps also in what situation? And which
one is the "officia
The problem was solved: it was up to static variable features, not MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Stefan Traby <[EMAIL PROTECTED]> wrote:
> Hi !
>
> mysql 5.0 is _really_ cool.
>
> this bug should be reproducable:
Thank you for bug report! It was entered to the bug database as
http://bugs.mysql.com/2460
>
>
> ( cat table.sql ; ./populate.pl ; ./perfect_game.pl 32 ) | mysql test
>
Hi Arnaud,
I did not see an answer to this so; I think the info you need is
here http://jeremy.zawodny.com/blog/archives/000203.html and here
http://jeremy.zawodny.com/blog/archives/000697.html
But I think you want "skip-name-resolve" to be specified in my.cnf.
Ken
I have included the relevan
--- Roger Baklund <[EMAIL PROTECTED]> wrote: > * Arunachalam
> > Sent: Tuesday, January 13, 2004 10:39 PM
> > To: mySQL List
> > Subject: Re: mysql_init function issues :Connecting MySQL to COBOL
> >
> >
> > I have somehow managed to create the datatype in COBOL matching
> > to C datatype and pass
Well, this has been fixed, for your info, it was a problem from our
DNS's with the reverse name process.
Greets.
Javier Tacon
-Mensaje original-
De: Javier Tacón [mailto:[EMAIL PROTECTED]
Enviado el: martes, 20 de enero de 2004 11:23
Para: [EMAIL PROTECTED]
Asunto: unauthenticated use
I think I figured out the time problem. If I make s2 in the or s1 and
remove any instances of s2 it works very fast with the 'or'.
Joe
On Tuesday, January 20, 2004, at 09:50 AM, sulewski wrote:
Hello,
For my final solution I decided to use the inner join method. The
query is created dynamica
"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
> Hi group, I have discovered this morning a strange behaviour of MySQL 4.1.1
> When the SUB-SELECT contains more than one field, it does not work (this works very
> well with 4.1.0 )
>
> For example:
> SELECT field1 FROM Table1 WHERE (f
* Arunachalam
> Sent: Tuesday, January 13, 2004 10:39 PM
> To: mySQL List
> Subject: Re: mysql_init function issues :Connecting MySQL to COBOL
>
>
> I have somehow managed to create the datatype in COBOL matching
> to C datatype and passed as argument to mysql_init and
> mysql_real_connect.
>
> My
Hello,
For my final solution I decided to use the inner join method. The query
is created dynamically based upon a user interface component that
allows people to build queries using parenthesis, ands and or's. Plus
there is another field that I didn't include in the original question
so as to
Help.
I have a REPAIR table command that has been running since 1/15... I dont know if its
hung or what? Should I kill it ? Top shows that it seems to be running?
mysql> show processlist;
++--+---+-+-++--+--
* Noamn
[...]
> { What does the cardinality mean? There should be three values for matzav,
> three for sug and five for status. Is this zero based? }
It is the expected number of different values in this column. The number is
not accurate. You can run ANALYZE TABLE to update this information.
ht
Note: forwarded message attached.
Please take time to read the mail and
give me your valuable suggestion.
Thanks
Arun
Yahoo! India Mobile: Download the latest polyphonic ringtones.
Go to http://in.mobile.yahoo.com--- Beg
* Arunachalam
> what are all the situations, which raise this error?
> If any one got ideas regarding this pls let me know
> I haven't step ahead due to this error.
>
> Unknown MySQL Server Host '"Ì' (11001): QÌ(53)
Could you explain the context or show the statement that causes this erro
This is the unadulterated material, complete with Hebrew table names!
mysql> describe sochnim;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
|
hi all!
what are all the situations, which raise this error?
If any one got ideas regarding this pls let me know
I haven't step ahead due to this error.
Unknown MySQL Server Host '"Ì' (11001): QÌ(53)
thanks
Arun.
1 - 100 of 112 matches
Mail list logo
