** Be prepared, rate R **
http://hk.geocities.com/blood1213/fur.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Actually, I've done a test with this in the past, we could not find a limit.
But there is a magic number where the optimizer stops doing a good job of
optimizing the query and it starts to get really slow.
In our case we were using words, and phrases, so we would have something
like:
IN ('a', 'ap
On Wednesday 16 February 2005 08:52 pm, Hal Vaughan wrote:
> I'm not quite sure what search terms to use, otherwise I'm sure I could
> find this on Google.
>
> I have a working install of MySQL on an older computer, running the current
> version of my program. I am about to start developing a newe
On Wednesday 16 February 2005 09:48 pm, Logan, David (SST - Adelaide) wrote:
> You could start a second copy of the same server the way that I
> described below. Just start the second copy listening on a different
> port. You could use command line overrides to start it up with a
> different my.cnf
> -Original Message-
> From: Daevid Vincent
> Sent: Wednesday, February 16, 2005 20:59
> To: mysql@lists.mysql.com
> Subject: What is the max length of IN() function?
>
> I tried to find this function on the dev.mysql.com site, but good luck
> finding "in"... ;-)
>
> Can someone tell me
I tried to find this function on the dev.mysql.com site, but good luck
finding "in"... ;-)
Can someone tell me what the maximum length is for this function?
SELECT * FROM foo WHERE bar IN(1,2,3,4,. N);
How many entries can there be in between 1 and N ? Hundreds? Thousands?
Millions?
--
My
You could start a second copy of the same server the way that I
described below. Just start the second copy listening on a different
port. You could use command line overrides to start it up with a
different my.cnf file with the changed parameters. eg. different
datadir, different port etc. This wa
On Wednesday 16 February 2005 09:27 pm, Logan, David (SST - Adelaide) wrote:
> Ooops, sorry for the second time, I forgot to include the list.
>
> Yes, you can install the "normal" version of mysql (in my case 4.0.22)
> and leave everything default. You can then install a new version of
> mysql (4.
Ooops, sorry for the second time, I forgot to include the list.
Yes, you can install the "normal" version of mysql (in my case 4.0.22)
and leave everything default. You can then install a new version of
mysql (4.1.3 or something) and then set up the my.cnf so that it listens
on a different tcp por
On Wednesday 16 February 2005 09:04 pm, you wrote:
> Hi Hal,
>
> Do you mean using the same version but accessing 2 different sets of
> tables? I'm a little confused as to what your requirements are.
Or databases. Basically, I want it all on one system, but I don't want the
current databases, wh
Hi Hal,
Do you mean using the same version but accessing 2 different sets of
tables? I'm a little confused as to what your requirements are.
You could install both versions and use aliases to ensure that you can
access only one instance at a time by the method you described. You
would have new-my
I'm not quite sure what search terms to use, otherwise I'm sure I could find
this on Google.
I have a working install of MySQL on an older computer, running the current
version of my program. I am about to start developing a newer version of my
program on a new computer. I'd like to have both
Can I post a query to this list and ask for help optimizing it?
--
Ryan McCullough
mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
That did it.
Thanks for the quick response!
>>> <[EMAIL PROTECTED]> 2/16/05 11:19 AM >>>
"Ed Reed" < [EMAIL PROTECTED] > wrote on 02/16/2005 02:13:40 PM:
> Can anyone tell me the limit for the number of records that can be
> inserted in a single call?
>
> I'm trying to insert multiple records
> Daniel,
>
> It's really not clear to me exactly what you want. For example, what
> do you mean by file numbers? Perhaps if you could tell us a little
> more about your table, your query, and the result you want, we could
> provide a solution.
>
File number = Job Number , or Ticket Number.
A monitoring solution which can monitor mysql as well as pretty much any
service on nix and win platforms is zabbix (http://www.zabbix.com), its very
easy to setup and personally I think its excellent. It may be overkill if
you just want to check a db is up though
-Original Message-
F
Daniel,
It's really not clear to me exactly what you want. For example, what do you
mean by file numbers? Perhaps if you could tell us a little more about your
table, your query, and the result you want, we could provide a solution.
Michael
[EMAIL PROTECTED] wrote:
At 04:35 pm 2/16/2005, you w
You probably want a multiple column sequence. See pages 562
through 567 of the MySQL Cookbook by Paul DuBois, 1st. ed.
for an excellent and thorough description.
It's also briefly mentioned at:
http://dev.mysql.com/doc/mysql/en/example-auto-increment.html
___
Hi there,
I'll answer your questions below, but I should tell you that it looks like
even three or four "joins" seem to make this too slow. Theoretically, the
user could select up to 15 or so GoalNumber values, 12 for Grade, and
about 20 possibilities for Subject - clearly it wouldn't be use
> At 04:35 pm 2/16/2005, you wrote:
>>Hi there is there any way at all that with a special field type mysql
>>can generate file numbers like so AUD-01 then AUD-02
>>AUD-00010 etc ... Let me know.
> You can get the 01, etc via something like SeqItem int(6) unsigned
> zerofill auto_i
At 04:35 pm 2/16/2005, you wrote:
Hi there is there any way at all that with a special field type mysql can
generate file numbers like so AUD-01 then AUD-02 AUD-00010
etc ... Let me know.
You can get the 01, etc via something like SeqItem int(6) unsigned
zerofill auto_increment. T
I already use the autoinc or sequence number as part of the number like
AUD-05--1 where 1 is the record id, just wanted to know if it could
happen on the mysql end.
> [EMAIL PROTECTED] wrote:
>
>>Hi there is there any way at all that with a special field type mysql
>>can generate file number
[EMAIL PROTECTED] wrote:
Hi there is there any way at all that with a special field type mysql can
generate file numbers like so AUD-01 then AUD-02 AUD-00010
etc ... Let me know.
Use an auto_increment field, say an 'unsigned integer auto_increment
primary key'.
Then do the formatti
Hi there is there any way at all that with a special field type mysql can
generate file numbers like so AUD-01 then AUD-02 AUD-00010
etc ... Let me know.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
> Does anyone know where I can find in-depth, precise instructions to
> install MySQL on Mac OS X Panther client?
>
> - Asad
>
Just get the binary for OSX and follow the readme its simple.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
matt_lists wrote:
matt_lists wrote:
"One restriction is that currently you cannot modify a table and
select from the same table in a subquery. This applies to statements
such as |DELETE|, |INSERT|, |REPLACE|, and |UPDATE|."
Anyboyd know if this will be fixed?
Working around it with a join on its
Just download the install package from the mysql website. Instructions
for configuring it (i.e. setting root password) are the same for all
platforms.
But, if you really need handholding, head over to entropy.ch.
On Feb 16, 2005, at 3:43 PM, Asad Habib wrote:
Does anyone know where I can find in
Does anyone know where I can find in-depth, precise instructions to
install MySQL on Mac OS X Panther client?
- Asad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ben,
- Original Message -
From: "Ben Kutsch" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, February 15, 2005 1:55 AM
Subject: innodb error 995
Hi I'm running version MySQL 4.0.20a-debug
windows server 2003
on a dedicated database server with an external SCSI RAID
matt_lists wrote:
"One restriction is that currently you cannot modify a table and
select from the same table in a subquery. This applies to statements
such as |DELETE|, |INSERT|, |REPLACE|, and |UPDATE|."
Anyboyd know if this will be fixed?
Working around it with a join on itself, is there some
"One restriction is that currently you cannot modify a table and select
from the same table in a subquery. This applies to statements such as
|DELETE|, |INSERT|, |REPLACE|, and |UPDATE|."
Anyboyd know if this will be fixed?
Working around it with a join on itself, is there some reason updating a
"Ed Reed" <[EMAIL PROTECTED]> wrote on 02/16/2005 02:13:40 PM:
> Can anyone tell me the limit for the number of records that can be
> inserted in a single call?
>
> I'm trying to insert multiple records like this,
>
> INSERT INTO t1 (f1, f2, f3, f4) VALUES
> ("test", 1, "some data", "Done"),
> (
Can anyone tell me the limit for the number of records that can be
inserted in a single call?
I'm trying to insert multiple records like this,
INSERT INTO t1 (f1, f2, f3, f4) VALUES
("test", 1, "some data", "Done"),
("testing", 21, "some more data", "Still Done"),("tested", 50, "no more
data",
Good call... I should have figured that out my self. The old version
was 2.6:
/usr/bin/myisamchk (v2.6)
/usr/local/mysql-standard-4.1.8-apple-darwin7.6.0-powerpc/bin/myisamchk
(v2.7)
This is likely why I lost my data in the first place.
Dan T
On Feb 16, 2005, at 10:57 AM, Michael Stassen wrote
I've always figured that if your tablespaces are tight enough to
autoextend, you're going to take a performance hit. InnoDB uses the
tablespace for some transaction/rolebacks -- if you have a large
transaction going through it will be slowed down by an autoextend
operation. Plus, once you're there,
I have two questions:
1) I'm still having trouble getting mysql to run as user mysql. All the file
and folders have been changed to be owned by user mysql but phpadmin shows my
sql running as root. When I log on as root and look at the users, I do not
see a mysql user. Do I need to create this u
Dan Tappin wrote:
I have MySQL 4.1.8 installed on OS X 10.3.8 Server and I was in the
process of building a PHP / MySQL website. After numerous connection
issues with the MySQL server I decided to take a look at the status of
my tables to check for corruption.
After running myisamchk I managed
Is DELETE QUICK supported in MySQL version 3.22.32?
-- Jim
__
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql
I have MySQL 4.1.8 installed on OS X 10.3.8 Server and I was in the
process of building a PHP / MySQL website. After numerous connection
issues with the MySQL server I decided to take a look at the status of
my tables to check for corruption.
After running myisamchk I managed to loose all my d
Hi Michael, thanks for the info. I guess I will go ahead with my plan to
make something a little bit more robust that will check the avialability
of every table of every db on a box and send out notifications on an
interval until they are corrected. Seems like a nice little sourceforge
project
On Wed, 2005-02-16 at 10:35, Mathew Ray wrote:
> Has anyone used or built a db monitoring tool for MySQL?
>
> I have come across various system-level heartbeat tools, but I am
> specifically looking for a solution that will work on Win2K Server and
> RedHat boxes, as we have several servers that
Ben Clewett wrote:
Jeff,
Thanks for your idea. Deleting data x rows at a time would certainly
help, if AUTOCOMMIT=TRUE. But I have no idea how :) I have tried:
DELETE FROM very_large_table WHERE delete_flag=1 LIMIT 10;
But the LIMIT is not understood (4.1.8).
What do you mean? That appear
healthserv wrote:
Hi!
I am having a problem searching a fulltext field. I'm setting up a little code library program for
a few of us who work together. One field (TEXT) is "keywords" and it is indexed as well
as fulltext. I send a simple query via my form to the code below. The connection is
hi,
I am migrating a DB having a table with a UID not_null autoincrement
the original table starts at UID=0
I cannot migrate this table autmaticaly as the line for UID=0 is
automatically transformed into UID=1 and therefore I get an error
message for the next line (UID=1) as being already into t
AM Thomas wrote:
Guarded exclamations of success!
This seems to be working for me so far - thank you! Here's an actual
example of a working query on my database; the field names are a little
different (sorry, I was trying to make my earlier example more
readable). The main change, though, i
Jeremy Cole wrote:
Hi,
Thanks, but unless I'm missing something, that will return the same
as SUBJECT="English" and (GRADE="1" or GRADE="2"), which is resource
records 1,2,3, and 4 - too many matches. Am I missing something?
How about this:
SELECT resources.id, resources.title
FROM resources
Hi
I set ft_min_len_word = 3 and ft_stopword_file =
/etc/stopword.cnf in my.cnf file under the [mysqld]
section
I then restart the server and rebuild the indexes with
REPAIR TABLE ... QUICK
The ft_min_len_word=3 seems to work: I get the
expected results when quering for 3-letter words
Unfortuna
Has anyone used or built a db monitoring tool for MySQL?
I have come across various system-level heartbeat tools, but I am
specifically looking for a solution that will work on Win2K Server and
RedHat boxes, as we have several servers that each run different
instances of mysql.
No replication o
Hi Heikki,
> try to find the real ibdata file and edit my.cnf or my.ini accordingly.
There is only one ibdata file, though - data/ibdata1, plus two log
files (data/ib_logfile0 and data/ib_logfile1).
Moving the files out of the data directory worked for now, and as far
as I know, none of my appli
Problem: INSERT queries hang on amd64.
This looks a lot like Don MacAskill's bugreport in
http://bugs.mysql.com/bug.php?id=3483
I've just upgraded from 4.1.9 to 4.1.10 on a dual opteron with 8G ram,
running Debian 3.1. Also tried 4.0.23 last week, but that had the same
problems. Kernels I've tr
Schnee,
- Alkuperäinen viesti -
Lähettäjä: "Schneelocke" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio:
Lähetetty: Wednesday, February 16, 2005 5:07 PM
Aihe: Re: Server fails to start up after upgrade to 4.1.10
Hi Heikki,
you have probably mixed ibdata file
I have 2 dual proc opterons and also have not seen this using MyISAM
(4.1.9), however, I have been less than impressed with mysql on opteron
(using the x86-64 binary from their site). Performance is generally
less than that of our remaining old 32 bit dual proc xeon machines (all
our db machin
Hi Heikki,
> you have probably mixed ibdata files. It is trying to apply a log record to
> a page that is full of zeros.
*nods* What do I do about that?
> And, in an upgrade you should shut down mysqld gracefully. It is not a good
> sign if InnoDB has to do a crash recovery after an upgrade.
I
Jesper Andersson wrote:
[...]
created =VARCHAR(14)
[...]
select CREATED from SUBSCRIBER where date_sub(now(), interval 1 hour) <=
created;
What do I wrong??
The 'created' column is a normal string, the date_sub() function returns
a "time string", i.e. a string on the special format "-MM-DD
H
Found some help here:
http://forums.mysql.com/read.php?10,10572,11064#msg-11064
UPDATE Table1 SET Table1.Field1 = (
SELECT count(*) FROM Table2 WHERE Table2.Code2=Table1.Code1
)
and that query works for me, great!!
But I still don't understand why it updates properly without the WHERE
clause.
So i
Schnee,
you have probably mixed ibdata files. It is trying to apply a log record to
a page that is full of zeros.
And, in an upgrade you should shut down mysqld gracefully. It is not a good
sign if InnoDB has to do a crash recovery after an upgrade.
Regards,
Heikki
.
Hi,
I just
SELECT animal, pic from animal AS a, pic as p, animal_pic as ap
WHERE animal = 'penguin'
AND ap.animalid = a.id
and ap.picid = p.id
On Wed, 2005-02-16 at 03:32, Martin Rytz wrote:
> Hi SQL-Community
>
> I need once more your help, I have a tricky problem with my animal-db.
>
> I have a table w
On Wed, 2005-02-16 at 06:35, Gerd Pleyer wrote:
> Hi there!
>
> I use MySQL 4.1.9 on Mac OS X Server 10.3.8
>
> I use the mysql.server script (in support-files) to shutdown my MySQL Server
> at system shutdown.
> But the command kill `cat data/my.server.de.pid` fails, so the DB is still
> runni
I know this may be strange, but have you turned on innodb on the box? Even
if don't use it? I have 8 amd64 boxes and have never experienced this
problem you are talking about. They range from single proc to quad proc.
Never this problem but all of them have innodb turned on.
Turn it on and se
Hi,
I have one table tableNames ID,name, new_name. The columns ID and name are
populated. I would like to update the field new_name from an other table
tempName (ID,nameUpdated).
The ID between the 2 tables are the same, but I don't have the info for all
the ID. (so 568 rows in my first table on
On Wed, Feb 16, 2005 at 12:41:04PM +0100, Michel Buijsman wrote:
> My problem: INSERT queries hang on amd64.
Sorry about the multiple mails, mysql.com's mailinglist software
does annoying things with the wrong adresses...
--
Michel Buijsmantty.nl -- 2dehands.nl
--
On Wed, 2005-02-16 at 03:45, Jesper Andersson wrote:
> Hello again,
>
> I relly new with databases and writing sql-questions.
>
> But in my db want I to check what new rows have come the last hour.
>
> the db-table (table name is SUBSCRIBER) have the following columns as follows:
>
> ID em
Martin Rytz wrote:
[...]
With which join can I show the animals with all pics for this animal (even
if there are more than one pic for an animal)?
SELECT animal,pic
FROM animal_pic,animal,pic
WHERE
animal.id = animalid AND
pic.id = picid
This will list all animals which have pictures, w
Problem: INSERT queries hang on amd64.
This looks a lot like Don MacAskill's bugreport in
http://bugs.mysql.com/bug.php?id=3483
I've just upgraded from 4.1.9 to 4.1.10 on a dual opteron with 8G ram,
running Debian 3.1. Also tried 4.0.23 last week, but that had the same
problems. Kernels I've tr
My problem: INSERT queries hang on amd64.
This looks a lot like Don MacAskill's bugreport in
http://bugs.mysql.com/bug.php?id=3483
Which is listed as closed, but the bug is apparently still there
so maybe it should be reopened...
I've just upgraded from 4.1.9 to 4.1.10 (binary) on a dual optero
Hi,
I just upgraded my installation of MySQL 4.1.8 (on Windows XP) to
4.1.10, and the server fails to start up now. The following is a
relevant bit from the error logfile (I've removed the InnoDB page
dumps for readability - they're all 0's, FWIW):
050216 14:42:21 InnoDB: Database was not shut d
I expect the data size is no more then 1.5TB.
Why don't you like to let tablespace auto grow?
Is it performace issue or not?
If I create ten innodb_data_file and each size of innodb_data_file is 50G,
dose some issues must be take care?
Because the 50G is really very big for a file, I never do it
Hi there!
I use MySQL 4.1.9 on Mac OS X Server 10.3.8
I use the mysql.server script (in support-files) to shutdown my MySQL Server at
system shutdown.
But the command kill `cat data/my.server.de.pid` fails, so the DB is still
running and tables stay open at system shutdown.
With mysqladmin -ur
Hello there,
We have a problem with the LOAD INDEX INTO CACHE command which is
supposed to be fixed in version 4.1.10
It may be fixed, but then we don't get the way to make it work.
We want to load all the indexes of one of our big table into the main key cache.
This table is myISAM, and has all
Hi Dan,
Sorry for causing additional work to getting the test setup, I will take
your advice should I need to post these type of details again
With regards to your solution, it works perfectly!!! Great thanks for
putting the time and effort in to help sort this problem. Much appreciated.
I
Hi Lotte,
(B
(BMySQL's dual License policu is very simple. If you use the GPL license
(Bthan you have to show the source code (modified or not), and include the
(BCopyright info when passing the code on.
(B
(BIf you dont want to do this (or in other words if you want to keep your
(Bmodificat
Hello,
My understanding of the GPL license is that if you link your own software with
GPL-licensed software, then the GPL forces you to release the whole thing under
GPL. I am a bit confused that MySQL seems to require that even stand-alone
applications are released as open source.
Does MySQL
Hello again,
I relly new with databases and writing sql-questions.
But in my db want I to check what new rows have come the last hour.
the db-table (table name is SUBSCRIBER) have the following columns as follows:
ID email created updated
001 [EMAIL PROTECTED] 20
Hi SQL-Community
I need once more your help, I have a tricky problem with my animal-db.
I have a table with animals and a table with animal-pics. I have a third
table. In this table you can see, which pic belongs to which animal:
CREATE TABLE animal (
id int(11) NOT NULL auto_increment,
a
74 matches
Mail list logo