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,
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]
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
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
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
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
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
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
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
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
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
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,
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 email
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
--
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
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
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
running and
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 with
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
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
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
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 did
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
Schnee,
- Alkuperäinen viesti -
Lähettäjä: Schneelocke [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Kopio: mysql@lists.mysql.com
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
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
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
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
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
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
LEFT
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,
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
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
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
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
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
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
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:
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
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
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
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
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, Not
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),
(testing, 21, 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
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
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
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]
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
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
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:
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
[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
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 numbers
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.
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
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
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
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
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-
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.
--
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 like this,
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]
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
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
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, which
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
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.1.3 or
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
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?
--
-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 what the
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
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 newer
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',
** 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]
74 matches
Mail list logo