r your sudo password you can background
the process by press Ctrl-Z and then entering the command "bg" to the
shell.
I hope this helps,
Kind Regards,
--
Lachlan Mulcahy, Support Engineer
MySQL AB, Melbourne, Australia
Are you MySQL certified? www.mysql.com/certification
Jonathan,
I'm going to assume you want to match the answer fields in the way those 2
query examples do and that the qid field refers to the Question number.
SELECT
userid
FROM
Answers a1 JOIN Answers a2 ON
a1.userid = a2.userid
WHERE
a1.qid = 5 AND
John,
As far as I'm aware there is no problem creating a multi-column unique index
on fields that have already been indexed seperately. The multi column index
will be used in situations where you are trying to find unique
_combinations_ of the two fields and the individual indexes in situations
wh
Lachlan
PS. Please remember to reply to the [EMAIL PROTECTED] address rather
than my direct address, this way everyone can keep track of the discussion.
-Original Message-
From: John Mistler [mailto:[EMAIL PROTECTED]
Sent: Thursday, 8 July 2004 1:24 PM
To: Lachlan Mulcahy
Subject: Re: INSERT
Louie,
Can you please clarify if you are wishing to change the structure of the
table so that a particular column no longer exists or if you are just
wanting to "delete" the data in a field (eg. set it to "" or NULL).
Can you give a more specific example?
Lachlan
-Original Message-
From:
Daniel,
I have a few things that you might want to check (in order of most likely):
1. What is the maximum number of file descriptors set?
If this is too low you will be running into problems. Here is a paste from
the MySQL manual that is very helpful:
For more information you can read the full m
Lee,
UPADTE table SET description = REPLACE(description, '\r\n', '');
should work...
REPLACE(str,from_str,to_str)
Returns the string str with all occurrences of the string from_str replaced
by the string to_str. mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
-> 'WwWwWw.mysql.com'
Th
Jonathan,
I'm not exactly sure what you want to do..
Do you want to identify the entries in the table where the email addresses
are the same as another entry but the name and address details differ...
or.. do you want to find entries where the name and address information is
the same but email a
t took many hours previously down to
sub second, adding more hardware in this situation is still going to leave
you with an undesirably high execution time.
While I understand where you're going with your comments, I think it's
important to make sure people know these things.
Kind Regards
Sergei, Thom..
I am interested in seeing this thread followed through. As developers at my
work have experienced similar performance issues between 3.23.x and 4. Our
database is also of similar size and a full optimize has been run.
Regards,
Lachlan
-Original Message-
From: Sergei Golub
Matt,
I think I might have missed the start of this thread, as I can't seem to
find it.
Could you please post the following info (I don't mind if you just mail it
directly to me to save the list):
MySQL Version:
Server OS:
Server Hardware configuration:
- Memory
- CPU(s)
- Disks (RAIDs and In
Roy,
MyISAM tables also support the FULLTEXT index type, which may be useful,
whereas InnoDB doesn't.
Lachlan
-Original Message-
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 20 July 2004 7:50 AM
To: Roy Harrell; [EMAIL PROTECTED]
Subject: RE: Relational Integrity
MyISAM
Kieran,
The InnoDB tablespace may span multiple files and may even be configured to
use raw devices, thus, the filesystem really doesn't limit the maximum
InnoDB tablespace size. The maximum InnoDB tablespace size is 64TB.
Eg. of multiple files/devices
innodb_data_file_path=ibdata1:4G;ibdata2:50
Oh I forgot to say, a full list of InnoDB restrictions is here:
http://mysql.megalink.com/doc/mysql/en/InnoDB_restrictions.html
-Original Message-
From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 20 July 2004 9:36 AM
To: [EMAIL PROTECTED]
Subject: RE: Relational
Aman,
I agree with Jeremy, it sounds like you don't have an index, but the chances
are with a table that large and only 1GB or RAM there could be some heavy
disk action happening.
Could you post the CREATE TABLE and your my.cnf..
Lachlan
-Original Message-
From: Aman Raheja [mailto:[EMA
Chris,
Have you checked your following server configurables:
sort_buffer_size:
- This is the size of the cache created by _each_ thread that requires
ORDER BY or GROUP BY in a query.
If you are doing a lot of large ordered queries you will need to increase
this value otherwise MySQL will use _d
d2,
By the looks of it the client machine you are trying to connect from can
resolve the hostname of your 'linuxready' machine perfecetly fine... and
your host (according to nmap) is running the MySQL server daemon listening
on TCP port 3306. I would suggest the problem lies at the network level.
Sorry guys, I forgot to post to the list as well..
-Original Message-
From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED]
Sent: Friday, 6 August 2004 5:42 PM
To: [EMAIL PROTECTED]
Subject: RE: Query problem
Hi Schalk,
I recommend using parenthesis to group your AND/OR logic more firmly
Sorry guys, I forgot to post to the list as well..
-Original Message-
From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED]
Sent: Friday, 6 August 2004 6:56 PM
To: Marvin Wright
Subject: RE: InnoDB Deletes / Swap Problem
Marvin,
Does the job run locally on this machine with MySQL?.. If so
Sorry guys, I forgot to post to the list as well..
-Original Message-
From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED]
Sent: Friday, 6 August 2004 9:27 AM
To: [EMAIL PROTECTED]
Subject: RE: Question
Hi there,
Can you please provide a sample of a query that is not working? Also if you
Sorry guys, I forgot to post to the list as well..
-Original Message-
From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED]
Sent: Friday, 6 August 2004 4:12 PM
To: [EMAIL PROTECTED]
Subject: RE: Table query and column overlap
Hi again,
To fix this wrapping you can use the \G command, this
Sorry guys, I forgot to post to the list as well..
-Original Message-
From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED]
Sent: Friday, 6 August 2004 6:45 PM
To: Xanana Gusmao
Subject: RE: Is my server not tuned properly ?
Hi Xanana,
The variables you are looking at, while giving you some
Shawn,
Thanks for posting about the command window sizes. It's been something that
I have frustratingly accepted in silence for a while now (especially having
a 20 inch monitor at work).. Hooray!! I can finally get some horizontal real
estate!!
..obviously the concept of two whole megabytes of b
Hi Bruce,
I haven't reconstructed your database to test for sure, but I think your
problem is stemming from the way your joins are working.
First of all, since you are left joining to the university_urlTBL, you will
also need to left join to any tables you join from that table. If you don't
do th
f the database
structure and content, assuming that this is just a small test database
without any sensitive information.
Regards,
Lachlan
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 10 August 2004 10:33 AM
To: 'Lachlan Mulcahy'; [EMAIL PROTECTED]
Su
Bruce,
What do you get when you do this:
SELECT
*
FROM
university_urlTBL
WHERE
universityID = 40;
Lachlan
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 10 August 2004 10:46 AM
To: 'Lachlan Mulcahy'
Subject: RE: left join iss
fields and slowly add them
until you have the lot..
This is a good technique to find where your joins are going wrong.
Regards,
Lachlan
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 10 August 2004 12:27 PM
To: 'Lachlan Mulcahy'
Subject: RE: left j
James,
I recommend you use the binary packages on the MySQL site. If anything
you're going to have a much more painful time attempting to compile MySQL
yourself getting all the options right and linking against the correct
things. The MySQL team makes exceptional packages and have done a lot of th
Manish,
What version of MySQL are you using?
The chances are subqueries are not supported in your version.
Try restructuring your query as a join like:
UPDATE
tbl1,
tbl2
SET
tbl1.col1=tbl1.col1+1
WHERE
tbl.ID = tbl2.ID
AND tbl2.status='Active'
http://dev.
Bruce,
I have reconstructed the database you have given me and used the following
query successfully (the one I originally gave you). I think there is
something wrong with your data.
SELECT
p2.statusID as parseStatus,
p2.action as parseAction,
u2.name,
p1.userID,
Bruce,
I'm getting the four rows with one correctly matching the userID for tom and
the others returning NULLs for the user info.
Lachlan
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 10 August 2004 5:13 PM
To: 'Lachlan Mulcahy'
Subject: RE: l
Just in addition,
The current pricing on the MySQL site is 440EUR for the Pro License and
220EUR for the Classic License. The difference is that classic excludes the
InnoDB storage engine.
People may argue over the strict legal line where licenses are required to
be purchased, especially when the
Scott,
This may work for you:
UPDATE
tableName
SET
bounce_count = bounce_count +1,
status = 'bounced_out'
WHERE
(bounce_count + 1) > 10;
UPDATE
tableName
SET
bounce_count = bounce_count + 1
WHERE
status <> 'bounced_out'
AND (bounce_
have a table, people, with firstname, surname and ph_num with a few
entries like..
firstname surname ph_num
Lachlan Mulcahy 222 1234 1234
James Mulcahy 222 1234 1234
RobertThompson04 1673 1777
You may wish to:
SELECT
Essentially the spirit of the license is, if a company builds a system of
some kind where the database facilities are provided by MySQL and wish to
sell that system as a whole without a GPL or other accepted open license
then they will be required to purchase a license for each copy of the server
t
Scott,
Don't know about a table exactly but the manual has a comprehensive
reference of all column types and their limitations/descriptions here:
http://dev.mysql.com/doc/mysql/en/Column_types.html
Lachlan
-Original Message-
From: Scott Hamm [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 11
dnesday, 11 August 2004 8:19 PM
To: [EMAIL PROTECTED]
Subject: R: On the licensing once again
What if I sell a web site built using mysql?
Do I need a license on my web server?
> -Messaggio originale-
> Da: Lachlan Mulcahy [mailto:[EMAIL PROTECTED]
> Inviato: mercoledi 11 agost
Hi Jeroen,
Have you tried creating a new table by selecting the data that you want and
then removing the old table and replacing it with the new one.
Eg.
CREATE TABLE new_g2d (
chr char(10) NOT NULL DEFAULT '',
start int NOT NULL DEFAULT 0,
stop int NOT NULL DEFA
You're overcomplicating things here..
MySQL is either one license or the other. If for any reason you're required
to have a licensed copy of the MySQL server on a particular machine and you
buy a licensed copy for it. It remains a licensed copy.. whether you use any
additional closed, open or othe
Hi there,
What you probably want is
UPDATE temp
SET
QE = CASE WHEN QE = 1 THEN 6 END
QF = CASE WHEN QF = 1 THEN 5 END
WHERE
QA = 1 AND (QE <> 6 OR QF <> 5)
http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html
Lachlan
-Original Message-
From: Mo Li [mailto:[EMA
40 matches
Mail list logo
