When starting mysqld, I got the err message (in file)
051005 05:26:47 mysqld started
051005 5:26:47 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence num
On Wed, Oct 05, 2005 at 09:36:51AM +1000, Ligaya Turmelle wrote:
> >Having asked that, another question arises...do my field names in different
> >tables within the same database have to overlap (same field name) in order
> >for joins to work? I'm currently naming fields in such a manner:
No, name
bit simplistic but http://sqlcourse2.com/joins.html
Rich wrote:
Hi folks. Any chance on a tutorial from joins? I find them totally
confusing and I know there's some power in them, so I need to learn them.
Having asked that, another question arises...do my field names in different
tables with
Roy,
>How do I set up a query whose output would look like this:
Tolerance PartA PartB PartC
1 10 12 6
2 11 14 7
3 13 16 7
4 15 16 8
5 18 17 10
One
ah hah you are righht about the installationmysql -V shows 4.1
but the SHOW VARIABLES shows 3.something so something went wrong with
thhe update.
thanks for that.
Now if I encrypt using AES_ENCRYPT if I expect somebody else to decrypt
outside of mySQL I will need to provide the 'pass
Hello All,
I was building mysql after checking out from the bk repository. In that
process, while executing mysql tests I executed them in the environment
of Valgrind with the output in xml.
After each test case Valgrind thinks output is completed so it completes
its xml outputfile, but when the
Kishore Jalleda wrote:
Could you kindly advice if this query can be made to run faster
SELECT title, template
FROM template
WHERE templateid IN
(608,2072,2073,1888,1898,1895,1897,1894,1896,1901,1903,1889,1900,1890,1891,1902,1904,2104,624,625,2152,2212,1985,1996,614,1964,2103,2106,2113,1982,1983
Should have specified - all parts will have the same
tolerance numbers. Thanks for the quick, informative,
responses. I'll give them a whirl.
Roy
On Tue, 2005-10-04 at 15:59, Becla, Jacek wrote:
> Yes, agreed. The case you mentioned about missing tolerance is
> not in his example though - we c
Hi All,
Could you kindly advice if this query can be made to run faster
SELECT title, template
FROM template
WHERE templateid IN
(608,2072,2073,1888,1898,1895,1897,1894,1896,1901,1903,1889,1900,1890,1891,1902,1904,2104,624,625,2152,2212,1985,1996,614,1964,2103,2106,2113,1982,1983,1984,2074,623,21
Yes, agreed. The case you mentioned about missing tolerance is
not in his example though - we clearly need more input from Roy.
Jacek
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 04, 2005 12:56 PM
> To: Becla, Jacek
> Cc: Roy Harr
Jacek,
Your method would only work so long as each PartA, PartB, and PartC all
have the same tolerance numbers. if PartA and PartB had a tolerance of 20
but PartC didn't, your query would not show just the A and B tolerances.
In fact, it wouldn't show a line for Tolerance 20 at all.
The only
Roy Harrell <[EMAIL PROTECTED]> wrote on 10/04/2005
03:15:33 PM:
> Suppose I have a simple table as follows:
>
> PartName Tolerance Cycles
> A 1 10
> A 2 11
> A 3 13
> A 4 15
> A 5 18
> B 1 12
> B 2 14
> B 3 16
>
Hi,
One way of doing it would be:
select a.tolerance, a.Cycles as PartA, b.Cycles as PartB, c.Cycles as PartC
from t as a, t as b, t as c where a.tolerance=b.tolerance and
a.tolerance=c.tolerance and a.PartName='A' and b.PartName='B' and
c.PartName='C';
Jacek
> -Original Message-
>
Merlin,
Ouch, brain cramp, make that...
SELECT id
FROM table1
LEFT JOIN table2 ON table1.id=table2.table1_id
WHERE table2.table1_id IS NULL;
PB
-
Merlin wrote:
Hi there,
I just discovered, that I do have some old rows I do not need anymore.
A result from forgeting to empty the table b
Suppose you subscribe to a public email list that offers support on a
free open source database, and you see an email where someone doesn't
really provide nearly enough information to answer, what would you do?
What is the algorithm you are trying to implement to get the query-output?
Roy Har
Suppose I have a simple table as follows:
PartNameTolerance Cycles
A 1 10
A 2 11
A 3 13
A 4 15
A 5 18
B 1 12
B
Merlin,
>I just discovered, that I do have some old rows I do not need anymore.
>A result from forgeting to empty the table before starting to go into
production :-)
>However, I do try to find the rows which are not asociated with
another table in
>order to delete them. I have 2 tables: table1
Hello.
Are you have MySQL installed on Windows? Windows has a different
symbol for a line end. In what way have you perform a dump? Check
with mysql command line client and SELECT query if you field contains
\r at the end. HEX function might be helpful in this case.
[EMAIL PROTECTED] wrote
Hello.
>except for shared-compat, for which there is only a 4.1.13 version - is it
>acceptable that that RPM be a rev back from the rest?
In my opinion, this rpm contains only old libraries which don't change
with every new release of MySQL. However,I'm agree - it's a bit
confusing.
>o
Hello.
> Does MYSQL provide any other option to perform text based searches? Can
> someone suggest any tips for performance tuning the database in this
> scenario?
>
Use the same queries linked with UNION instead of a lot of ORs in WHERE
clause. For example this query can't use index (at
Thanks Shawn.
My naming convention (table_field) is more for my middleware development.
Much easier to see what to grab that way. It started when was doing
embedded inlines (pre-joins) and found the reference to 'id' was confusing.
Anyway, thanks for the join tutorial links, folks. Appreciate
Green,
Actaully i am dumping that data from oracle into .lst
file which will be in the mysql format. We are not getting any \n\r in
that case.
Thanks,
Narasimha
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 04, 2005 10:55 PM
Hi,
I noticed 1 bug with 5.0.13rc (win32 msi) :
when installing mysql in a custom location (eg c:\program
files\easyphp\mysql),
1) the service will not get installed properly
2) mysqld will complain about InnoDB engine not present.
Hope this helps.
Phil
--
MySQL General Mailing List
For list a
That's not dumping. That is loading. Dumping is when you put the data INTO
a file.
Does your source data contain the \r\n pair or not?
You seem to be using the default import parameters as you are not
specifying any values that could apply specifically to your data. Please
RTFM for LOAD DATA I
Did you try the pipe operator | ?
The command you wrote as an example uses output redirection, close but not
exactly the same.
To use the output of prog 2 as standard input (console input) to prog1,
you would say
prog1 < prog2
To sent the output of prog1 to a file or other device
prog1 >
>>You haven't physically looked at and compared the logs, have you
Actually that was the first thing I did. The mysqlbinlog rendered text
was roughly the same but the binary files much bigger. It's probably
something obscure and specific to my implementation and not something
that the group
Rich,
>Hi folks. Any chance on a tutorial from joins?
A few good ones are listed at
http://www.artfulsoftware.com/dbresources.html.
PB
-
Rich wrote:
Hi folks. Any chance on a tutorial from joins? I find them totally
confusing and I know there's some power in them, so I need to learn
My favorite SQL tutorial: http://sqlzoo.net/
Do your field names need to be globally unique: yes and no. Some design
philosophies require that every field on every table be uniquely
identified. The only uniqueness requirement you must obey is that no two
fields on the same table can have the s
Green,
Thank you very much for your reply. Yes, if i see in the
hex(), 0D 0A are coming at the end of each line.
While dumping data i am using just
LOAD DATAINFILE My.LST' INTO TABLE My_Table;
Please let me know what deleimiters i have to use to avoid '\n\r' at teh
end of line.
SELECT ID, title, date, left(content,40) FROM news ORDER BY date asc LIMIT
0,10
If you want the last 40, use right(), and if you want to choose a section,
use the mid() function.
HTH,
J.R.
-Original Message-
From: Dotan Cohen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 04, 2005 12:
You also forgot to mention how you are dumping
Do you see the trailing \r if you run a normal query on the field? Use the
HEX() function and look for the value 0D anywhere in the output.
Are you 100% certain that the \r is not part of your original data? If
you look at your source data wi
At 19:48 +0300 10/4/05, Dotan Cohen wrote:
I have this SQL statement:
SELECT ID, title, date, content FROM news ORDER BY date asc LIMIT 0,10
However, I only need the first 40 characters of the content field,
which in some cases is over 5000 characters long. Is there a way to
request only the fir
> Hi folks. Any chance on a tutorial from joins? I find them totally
> confusing and I know there's some power in them, so I need to learn them.
http://www.w3schools.com/sql/default.asp
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Se
I have this SQL statement:
SELECT ID, title, date, content FROM news ORDER BY date asc LIMIT 0,10
However, I only need the first 40 characters of the content field,
which in some cases is over 5000 characters long. Is there a way to
request only the first 40 characters of a field? Thanks in advanc
How do I pipe the Windows cmd output into mysql inserts?
i.e.
dir /w /o:n > mysql -u process (INSERT INTO TABLE)
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
Hi folks. Any chance on a tutorial from joins? I find them totally
confusing and I know there's some power in them, so I need to learn them.
Having asked that, another question arises...do my field names in different
tables within the same database have to overlap (same field name) in order
for
No matter what I set in the my.ini option file, when I type "show variables"
at the command line I get the following result:
character_set_client | latin1
character_set_connection | latin1
character_set_database | utf8
character_set_results| latin1
character_set_server | utf8
charact
The Mysql download page says I need to install these libraries if I
am using libc 2.3.x.
I have a couple of questions:
-- do I install them by just copying them to /usr/local/lib?
-- will they play that silly game of running unoptimized code on
AMD processors?
--
Christopher L. Everett
Chief
Sorry, I forgot to mention theat I am inserting into mysql using load
data infile.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 04, 2005 9:04 PM
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: Reg insertion of data
Hi,
We
Harini Raghavan <[EMAIL PROTECTED]> wrote on 10/04/2005
11:17:48 AM:
> Hi,
>
> I am using MYSQL 4.1 database in my J2ee application. I am facing
> performance issues with some queries that are being run on text fields.
> Since MYISAM storage engine does not support transactions(and my
> appli
Hi,
We are inserting the text data into mysql. But, when we see the
dump of that table, we are seeing '\r' at the end of the value of that
text. Actually we are not inserting the data with '\r'. Can any one of
you help me in removing that '\r', imean I donot want to see that '\r'
even in
Merlin <[EMAIL PROTECTED]> wrote on 10/04/2005 10:58:21 AM:
> [EMAIL PROTECTED] wrote:
>
> >
> >
> > Merlin <[EMAIL PROTECTED]> wrote on 10/04/2005 10:21:00 AM:
> >
> > > Hi there,
> > >
> > > I just discovered, that I do have some old rows I do not need
> > anymore. A
> > > result from forgetin
Hi,
I am using MYSQL 4.1 database in my J2ee application. I am facing
performance issues with some queries that are being run on text fields.
Since MYISAM storage engine does not support transactions(and my
application requires the database tables to support transaction), I have
not been able
Hello.
> Show us the query that fails, fulltext works ok here.
LIKE doesn't use fulltext.
>>
> Show us the query that fails, fulltext works ok here.
>
> SELECT id,txt,ch FROM fulltxt WHERE txt LIKE "%modem";
> id,txt,ch
> 0,DSL-modem,DSL-Modem
> 1,Cable-Modem,Cable-Modem
>
> SELE
I have a CentOS-3 (RHEL 3 equivalent) with MySQL 4.1.9 installed from the
MySQL site. The RPMs I'm using are:
MySQL-server-4.1.9-0
MySQL-client-4.1.9-0
MySQL-devel-4.1.9-0
MySQL-Max-4.1.9-0
MySQL-shared-compat-4.1.9-0
I see that 4.1.14 is the latest version. When I went to download the latest
RPM
Merlin <[EMAIL PROTECTED]> wrote on 10/04/2005 10:21:00 AM:
> Hi there,
>
> I just discovered, that I do have some old rows I do not need anymore. A
> result from forgeting to empty the table before starting to go into
> production :-)
> However, I do try to find the rows which are not asociat
[EMAIL PROTECTED] wrote:
Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 10:08:24 AM:
Hello,
[EMAIL PROTECTED] wrote:
Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 08:34:56
AM:
Hello,
I am trying to put together a single query from across 4 tables and
not having a
pro
Hi there,
I just discovered, that I do have some old rows I do not need anymore. A
result from forgeting to empty the table before starting to go into
production :-)
However, I do try to find the rows which are not asociated with another
table in order to delete them.
I have 2 tables:
table1
I agree that if you want to do the searches you describe, you will need
extra keys. But MySQL does *not* create these keys automatically - it
creates the keys you ask for *and no more*. You have asked, correctly, for
a primary key on ABCDEF. MySQL will create exactly that key and no others.
Thi
Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 10:08:24 AM:
> Hello,
>
>
> [EMAIL PROTECTED] wrote:
> > Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 08:34:56
AM:
> >
> >
> >>Hello,
> >>
> >>I am trying to put together a single query from across 4 tables and
> >>not having a
>
Hi Alec,
Thanks for your comment. Well, we disagree on a few points.
Suppose I have a table with columns CountryID, CompanyID, SectorID and
ProductID.
And let's say that all these columns are NOT NULL, but indexed as
non-unique.
I need to select on specific countries, specific products etc.
So
Thanks everyone for all of the replies! I have been banging my head against
this for a week now and I was never looking in the direction of the cron
script... Sometimes it helps having another set (or ten) of eyes looking at
the problem.
Thanks again!
On 10/3/05, Bastian Balthazar Bux <[EMAIL P
Hello,
[EMAIL PROTECTED] wrote:
Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 08:34:56 AM:
Hello,
I am trying to put together a single query from across 4 tables and
not having a
problem getting the results needed. table structure:
#
Mike Blezien <[EMAIL PROTECTED]> wrote on 10/04/2005 08:34:56 AM:
> Hello,
>
> I am trying to put together a single query from across 4 tables and
> not having a
> problem getting the results needed. table structure:
> ##
> CREATE TABLE IF NOT
Kevin Liu wrote:
This looks great! Is there anything like this for Mac OS X?
Kevin
On 10/2/05 10:39 PM, "Ligaya Turmelle" <[EMAIL PROTECTED]> wrote:
+1 - it is wonderful.
olinux wrote:
You will love this.
http://www.fabforce.net/dbdesigner4/
I know it's not 'running on OSX', but I do m
"Andrew Braithwaite" <[EMAIL PROTECTED]> wrote on 10/04/2005 05:39:59
AM:
> Hi all,
>
> I have just upgraded a master slave database system from 4.0 to 4.1.
> the replication binlogs are now growing at a vastly greater rate. The
> queries going through are the same. Did 4.0 use some kind of
>
"Jonathan Stockley" <[EMAIL PROTECTED]> wrote on 10/03/2005
08:55:17 PM:
> Hi,
>
> We're having a problem with "lock wait timeout exceeded" errors. We are
> exclusively using innodb tables apart from the mysql database. The
> problem seems to be with the way we are simulating sequences.
>
>
>
Merlin wrote:
Hi there,
I am facing problems with fulltext search on MySQL 4.0.18
Problem is, that words which are not seperated by space are not found.
Example:
A search for "dsl" will not find "DSL-Modem"
I looked it up on mysql.com help, but despite the fact that this is not
seperated by sp
Merlin wrote:
Hi there,
I am facing problems with fulltext search on MySQL 4.0.18
Problem is, that words which are not seperated by space are not found.
Example:
A search for "dsl" will not find "DSL-Modem"
I looked it up on mysql.com help, but despite the fact that this is not
seperated by sp
"C.R. Vegelin" <[EMAIL PROTECTED]> wrote on 04/10/2005 12:52:01:
> Hi List,
>
> Is anyone familiar with optimizing indices, including primary key ?
> I do have a large myisam table with 6 non-unique key fields, lets
> say named A, B, C, D, E and F.
> Each of these columns may have NOT NULL value
Hi there,
I am facing problems with fulltext search on MySQL 4.0.18
Problem is, that words which are not seperated by space are not found.
Example:
A search for "dsl" will not find "DSL-Modem"
I looked it up on mysql.com help, but despite the fact that this is not
seperated by space and only 3
Oops, I was obviously wrong about your example, please ignore it. :)
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Kevin, I also observed differences between query plans on InnoDB
and MyISAM tables. I had a complex query, which had two possible
plans, first plan included const and ref joins on bigger tables then
joins on smaller tables, and second one was to do range scan of
smaller table and then join all l
Hello,
I am trying to put together a single query from across 4 tables and not having a
problem getting the results needed. table structure:
##
CREATE TABLE IF NOT EXISTS job_posts (
jobid int(6) unsigned NOT NULL auto_increment,
job_vacan
prathima rao wrote:
i have a table slno and percentage
slno contains 1 to 15 when i say order by slno it always comes
1,10,11,12,13,14,15,2
i want it in the form 1,2,3,4,5,6,7,8,9,10,11
can u help
rao
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: 04/10/20
i have a table slno and percentage
slno contains 1 to 15 when i say order by slno it always comes
1,10,11,12,13,14,15,2
i want it in the form 1,2,3,4,5,6,7,8,9,10,11
can u help
rao
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: 04/10/2005 2:19 PM
Subject: Re:
Hi,
Is there a standard for field names / types for holding data on addresses in
the UK?
Thanks for your advice
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear develepment team,
i?d like to access the entries of an fulltext index directly. Is there
another, more conveniant possibility than exporting the entries with
"myisam_ftdump /var/db/mysql/cms/faq_data 2 -c" and importing the entries in
an extra table for querying?
This feature would be extrem
Hi List,
Is anyone familiar with optimizing indices, including primary key ?
I do have a large myisam table with 6 non-unique key fields, lets say named A,
B, C, D, E and F.
Each of these columns may have NOT NULL values from 0 to 999, and are defined
as SmallInt.
Requirement: each row must have
Hello.
> thing worked. I'm always stuck in some errors like *UNRESOLVED EXTERNAL
> REFENCE, *and amongst other errors which I don't seem to understand and
> decipher.
Usually UNRESOLVED errors mean that you have some libraries missing.
Send the code to the list and errors which which you'
Hello.
Please send the output of SHOW CREATE TABLE for each table.
> Note no index is used.
MEMORY tables usually uses HASH index which might be the source of the
problem. Change the index to B-Tree and check if the query plan have
changed.
Kevin Burton wrote:
> I was benchmarking a
Hello.
In my opinion, libmysqlclient should be compatible with previous
servers. It supports the old authentication protocol and mysql client
program from the 5.0 distribution is able to work with old servers.
If you want you may look through change sets to find out if something
dramatica
Hello.
>Any ideas where to go with this? How can I find out which session is
>holding the lock and what lock it is?
SHOW INNODB STATUS and, probably, SHOW PROCESSLIST can give you
some additional information about what's going on. Use:
show variables like 'tx_isolation';
to find out t
Hi all,
I have just upgraded a master slave database system from 4.0 to 4.1.
the replication binlogs are now growing at a vastly greater rate. The
queries going through are the same. Did 4.0 use some kind of
compression by default or something?
Does anyone have any idea what's going on with thi
Matthew Lenz wrote:
anyone using openoffice:base to design mysql db's? back when I tried it
earlier this year it wasn't able to define relationships which made it
pretty much useless as a time saving tool.
Hi Matt,
Although it's slightly OT here, there is still a lot of development
going on
--
Philippe Poelvoorde
COS Trading Ltd.
+44.(0)20.7376.2401
--- Begin Message ---
Hi,
Good day!
I read the forum in this link http://archives.neohapsis.com/archives/mysql/2005-q2/1532.html and somehow I guess you people had tried programming MySQL in C successfully. I just hope that I can f
2005/10/3, s. keeling <[EMAIL PROTECTED]>:
> I'd like to add a bit of history data to a table (who changed a record
> last, and when it was last changed). Is this the way to do it?
>
>alter table MEMBERS
>add CHG_BY varchar(3)
>
>alter table MEMBERS
>alter CHG_BY set defaul
77 matches
Mail list logo