On Fri, 2002-10-25 at 00:14, Lewis Watson wrote:
>
> - Original Message -
> From: "Mark Matthews" <[EMAIL PROTECTED]>
> To: "Lewis Watson" <[EMAIL PROTECTED]>
> Sent: Thursday, October 24, 2002 8:40 PM
> Subject: Re: Lost Connection
>
>
> > Lewis Watson wrote:
> > >
> > >>>I am getting t
- Original Message -
From: "Mark Matthews" <[EMAIL PROTECTED]>
To: "Lewis Watson" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 8:40 PM
Subject: Re: Lost Connection
> Lewis Watson wrote:
> >
> >>>I am getting this same error. I have tried reseting, flushing,
rebooting
> >
> > the
At 18:26 -0800 10/24/02, Lists @ Apted Technologies Inc. wrote:
i am going to be setting up four mysql servers, three of which will
replicate data off of the primary. i know that in more recent versions of
mysql client/server communciations can be encrypted internally. but is
there any way to enc
I have seen a solution from a book how to display image queryed by php from db
step 1. at first like you ,create a php using Header("Content-type: image/gif")
to display the mesage queried from my sql. This displays the image .for example this
file named "image.php?imageID = ???"
step 2 . in p
i am going to be setting up four mysql servers, three of which will
replicate data off of the primary. i know that in more recent versions of
mysql client/server communciations can be encrypted internally. but is
there any way to encrypt replication communcations between these mysql
servers intern
Hello, every one.
I Found a bug about CASE .. WHEN .. THEN..
mysql> SELECT VERSION() ;
++
| VERSION() |
++
| 4.0.3-beta |
++
1 row in set (0.00 sec)
mysql> select CASE NULL WHEN NULL THEN 0 ELSE 1 END AS RESULT ;
++
| RESULT |
++
| 1 |
+
Do you have the date field keyed in the table definition?
I assume you have numbers after the date, or text, otherwise
you should be doing an = without the %...
Really to speed it up you should have a date field you query on,
which is keyed, and whatever is in the record after the date sho
Hello
I have server Intel P-4 2,8Ghz 2Gb RAM
so
and
I hve INNODB
and table with 145000 records
and when Im trying to query
select * from bla where date like "20021025%" order by date DESC limit 20
searhc time is 2,4 to 3,2 seconds
what a hell is going on?
What can I do to fast up these quesry
Hi,
I'm running MySQL 3.23.51 on a Debian Linux server, and I've got a
performance question.
I have a perl application which builds up data in memory (in a hash) and
every 30 seconds forks and writes the data to a database. When both perl
script and MySQL server are on the same machine, the scrip
Has anyone gotten this to work?
I tried to compile and install the Berkeley DB that comes with
mysql, but it has at least 2 errors, the second of which I cannot get
past.
The first error I got by by creating a symbolic in rpc_server
to ../include/db_server.h.
The
spiros wrote:
Any tips for optimization?(I assume this should not be done with pure sql
statements).
It almost sounds like you might not have a very good table design to
work with, depending on what your data is. Can you describe in some
more detail what is being dealt with here?
--
Micha
Howdy,
I've used MySQL before, a few years ago, under Slackware. I never could get it to
compile (despite
lots of help from folks here), but a pre-rolled binary did just fine for what I needed
at the time.
That system is no longer hooked up.
I've recently installed a newer version of Slac
We had a similar problem, we could connect through a socket (localhost), but
not TCP/IP.
Check your hosts.allow and hosts files. It is most likely that either
hosts.allow isn't set up to allow connections or the server connecting isn't
in the hosts file. This only applies when the 2013 happens du
At 03:38 PM 10/24/2002, you wrote:
Does anyone have any good maintenance tips for MySQL that should be done on
a regular basis?
I know table optimization is good to do from time to time but I would like
to know of there is anything else I can do to help keep MySQL stable and
running smoothly.
Tha
> >
> > I am getting this same error. I have tried reseting, flushing, rebooting
the
> > server. Please let me know if you find anything on this...
> > Thanks.
> > Lewis
>
> This is RedHat GLIBC upgrade badnessSearch the mailing list over the
> last 4 weeks, you'll see what I mean.
>
> For no
Hi,
There is a CPAN module that formats queries just like the mysql monitor does.
I want this so that I can send some query results in emails without having
to format them myself.
But horror of horrors I can't find the module that I know is there which I
noticed while browsing a short while ago
I have v.4.0.4b max nt, and I have the same result, even more:
mysql> INSERT INTO settest SET chain="A,C";
ERROR 1062: Duplicate entry 'A,C' for key 1
mysql> INSERT INTO settest SET chain="C,A";
ERROR 1062: Duplicate entry 'A,C' for key 1
mysql>
but
mysql> SELECT * FROM settest WHERE FIND_IN_SET
Mauro:
I was experencing the same problem in two different mysql setups
the first one is runing 3.23.36. the problem started after an up2date
with red hat.
Then i seted up a nother machine runing red hat 8 with mysql 5.23.53..
and the i found the same problemm..
Early this morning
Lewis Watson wrote:
- Original Message -
From: "Mauro Romano Trajber" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 4:09 PM
Subject: Lost Connection
Hi
Im trying to connect to a remote mysql server
(/usr/local/mysql/bin/mysql -u
root -h myhost -p )
an
Jeff,
- Original Message -
From: "Jeff Mathis" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, October 23, 2002 10:50 PM
Subject: show version problem
> hello,
>
> I'm running version 4.0.3-beta-max-log on SunOS 5.8 (Generic_108528-15
> sun4u sparc SUNW,Sun-Fire-2
- Original Message -
From: "Mauro Romano Trajber" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 4:09 PM
Subject: Lost Connection
> Hi
> Im trying to connect to a remote mysql server
(/usr/local/mysql/bin/mysql -u
> root -h myhost -p )
> and i get the follow
Gurus
I'm having trouble understanding the column type SET.
To explain my problem, I'll create a table, populate
it, and do selects.
mysql> CREATE TABLE settest( chain SET( "A", "B", "C" ) NOT NULL,
UNIQUE INDEX ichain( chain ) );
mysql> INSERT INTO settest SET chain="A,C
Hi
Im trying to connect to a remote mysql server (/usr/local/mysql/bin/mysql -u
root -h myhost -p )
and i get the following answers.
on the server :
/usr/local/mysql/bin/safe_mysqld: line 273: 31252 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD
$defaults --basedir=$MY_BASEDIR_VERSION --datadir
I want to change my option to subscribe to this list as a digest, is the
following command below correct, or is this
list not setup has a digest?
subscribe mysql-digest EMAILADDRESS
END
--
Kory Wheatley
Academic Computing Analyst Sr.
Phone 282-3874
#
Everyt
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed
automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [i'm no sure if i installed it corectly. is there
anyone who can tell me if it looks ok,
Yes, removing those disconnects on the second dbi call has fixed it. Looks like I was
running out of ports due to the TIME_WAIT on all the previously established ports.
Thanks,
Dallas
> -Original Message-
> From: Artem Koltsov [mailto:Artem.Koltsov@;wfinet.com]
> Sent: Thursday, Octobe
Do you connect/disconnect before/after every insert?
-Original Message-
From: Dallas Engelken [mailto:dallase@;nmgi.com]
Sent: Thursday, October 24, 2002 9:52 AM
To: [EMAIL PROTECTED]
Subject: DBI Connect Fails after 20,000 record inserts/updates
I am trying to parse an email log databas
>Description:
"mysqladmin -f -u bugs drop gdr_bugs" fails with
"error: 'Access denied for user: '@localhost' to database 'gdr_bugs''
even though user "bugs" has access. Omitting the "-f" option makes it
work. Somehow, the "-f" option is making mysqladmin forget t
Description:
Probably it's variation of recent bug with null joins, but just in case I want to post
it here because result depends on values inserted into tables, even if these values
are not participating in join.
After data insert with nulls the same query will produce different result after ad
Greetings...
I have a table in database ch whose create statement is as follows -
CREATE TABLE `chn1` (
`id` int(10) NOT NULL auto_increment,
`chn` varchar(10) NOT NULL default 'Pagal',
`name ` varchar(50) default '',
`chn3` text,
PRIMARY KEY (`id`)
TYPE=ISAM ;
Now when I giving a insert stateme
I'm writing an application that maintains its own
database using the mysqld lib. I can use
"mysql_real_connect" to connect to the "internal"
server fine, but I also want to be able to connect to
an external (or remote) server as well. When using
"mysql_real_connect" to try to connect to a remote
Why do you use the single quotes around your field names. I have never used
them when I build my schemas. That way you don't have to worry about
spaces.
HTH
-Original Message-
From: Insanely Great [mailto:insanely420@;PunkAss.com]
Sent: Thursday, October 24, 2002 8:59 AM
To: MySQL List
The column's name is 'name ' not 'name' run an alter to get rid of the space
at the end.
> -Original Message-
> From: Insanely Great [mailto:insanely420@;PunkAss.com]
> Sent: Thursday, October 24, 2002 8:59 AM
> To: MySQL List
> Subject: Insert Error
>
>
> Greetings...
>
> I have a table i
We are trying to track the software we are using..
Could anyone supply the release dates of the following versions of MySQL ( will assume
server and client are the same )
And perhaps a retired date ( which would probably be when the next actual release was
available )
3.23.32
3.23.36
3.23.49a
3
>From looking at http://www.mysql.com/doc/en/News.html
it looks like
3.23.32 22 Jan 2001
3.23.36 27 Mar 2001
3.23.49 ?
3.23.52 14 Aug 2002
3.23.53a ?
Or maybe that is when the change log was released? I'd look around the site
if I were you.
> -Original Message-
> From: Luc Foisy [mailto:
In case anyone has done this before, I'd appreciate any tips for
optimizing a link analysis application , e.g in its simplest form if we have
one or more tables of the form
AB
===
a1 b1
a2 b1
a3 b2
a1 b4
a4 b1
a5 b3
a6 b2
b1 b3
b3 a2
are there any tips f
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thursday 24 October 2002 21:05, Jennifer Goodie wrote:
> From looking at http://www.mysql.com/doc/en/News.html
> it looks like
> 3.23.32 22 Jan 2001
> 3.23.36 27 Mar 2001
> 3.23.49 ?
Unfortunately we forgot to tag this release in the BK tree.
Great thanks!
hmm I have 2002-10-17 for 3.23.53a taken from the post date of Lenz Grimmer's mail
I'd like to correct 3.23.49 to be 3.23.49a, does anyone know what the release date is
for this version?
---
Thats weird "D.2.1 Changes in release 3.23.54" ?? Somone sure is all geared up for the
> -Original Message-
> From: Lenz Grimmer [mailto:lenz@;mysql.com]
> Sent: Thursday, October 24, 2002 3:21 PM
> To: [EMAIL PROTECTED]
> Cc: Jennifer Goodie; Luc Foisy
> Subject: Re: MySQL Release Dates
> We usually note down the date when a release was tagged in
> the BK tree.
> The gene
Redhat Linux 2.4.5-beta4va3.17smp-piii
Dual Intel PIII/1GHz
2GB of memory
4x36GB SCSI HDDs in RAID5
mysql-3.23.52-pc-linux-gnu-i686
Experiencing 50% aborted connections (not aborted clients) over a small
private
network consisting of only 2 machines: the above mentioned machine and a web
server
Does anyone have any good maintenance tips for MySQL that should be done on
a regular basis?
I know table optimization is good to do from time to time but I would like
to know of there is anything else I can do to help keep MySQL stable and
running smoothly.
Thanks
Mark
Hello!
Is there any way to get rid of the database name in the path to the
reference of a foreign key. When using mysqldump to copy a database
the name of the source database is in the path of the foreign key
reference. In my case, that is not what I want.
An example:
mysql> use source_databa
It looks like you are using a network connection.
Perhaps you are running out of connections, as closed sessions may take
a while to be freed.
Try keeping the second connection open until you are done.
Dallas Engelken wrote:
I am trying to parse an email log database with about 900,000 records f
Hi all... I am attempting to play with the myisam
api to try to make loading hordes of data a little
simpler/faster, and so am trying out the myisam interface...
specifically, eventually to try an wrap it in a perl
module. Herein lies my problem...
I know enough C to get by, but am having s
I would like to know what is the difference between MySQL 4.0.4 MAX & PRO.
Thank you
JFernando
*** sql ***
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
select * from appointment a where a.adatetime < now() - interval 3 minute;
read user manual date/time functions. it's all there with examples.
-Original Message-
From: Prabu Subroto [mailto:prabusubroto@;yahoo.com]
Sent: Thursday, October 24, 2002 9:21 AM
To: [EMAIL PROTECTED]
Subjec
Hello Egor,
I am not sure how large the table is, since I cannot access it now. I
would guess that it has at least 1 million rows, and maybe more.
It is a MyISAM table type. I probably terminated the create index command
after about 1 hour. Afterwards, when I type 'use database_name' on that
The type of the tables are: MyIsam
The Query we use is:
select distinct a.afspraakid, Date_Format(Date_Sub(Concat_ws(' ',
'2000-01-01', a.begintijd), Interval a.reistijdvooraf Hour_Minute), '%H:%i')
As BeginTijd,
a.begintijd As OrgBegin, a.reistijdvooraf, Date_Format(Date_Add(Concat_ws('
', '2000
John,
Wednesday, October 23, 2002, 7:06:57 PM, you wrote:
>> $ perror 144
>> 144 = Table is crashed and last repair failed
>>
>> Your table is corrupted, try to repair it with REPAIR TABLE or
>> myisamchk:
>> http://www.mysql.com/doc/en/Repair.html
JP> Hmm. REPAIR TABLE gives
JP> | mydb
... can someone add InnoDB to the list of keywords?? SQL ... QUERY ...
Victoria Reznichenko wrote:
You can set up SET FOREIGN_KEY_CHECKS=0, in this case foreign key
constraints will not be checked. It's supported since 3.23.52 and
4.0.3
Out of curiousity, are the foreign key constraints check
Prabu,
Thursday, October 24, 2002, 4:25:02 PM, you wrote:
PS> I am using MySQL as database server. I still have problem now to select
PS> appointment time whose 3 minute difference (later) than now().
PS> I can not use "timestampdiff". Is there "TimeStampDiff " command in MySQL ?
PS> I tried th
Arthur,
Wednesday, October 23, 2002, 9:05:44 PM, you wrote:
AF> Perhaps what is confusing you is that you never explicitly define a
AF> relationship as such: there are no relationship objects. Rather, at the
AF> table leve you define a foreign key that references the primary key of
AF> another tab
David,
Wednesday, October 23, 2002, 7:48:25 PM, you wrote:
DK> Is it a save assumption that I need to create a section for every admin
DK> command that I want to use? i.e., create another section for mysqladmin and
DK> so on???
Yes and no.
Common options like user, password you can put in the
David,
Thursday, October 24, 2002, 11:27:30 AM, you wrote:
DC> I am using mySQL version 3.23.52 and I have tried to create an index on a
DC> large table. This was taking a very long time and so the command was
DC> terminated. Now the database seems to be corrupted, or at least
DC> inaccessible.
Hello Inamullah,
Thursday, October 24, 2002, 12:50:27 PM, you wrote:
First of all don't send me your questions, send them to the mailing
list. I don't privide private support.
IK>Well, I have just installed mysql on both wndows n
IK> Linux on the same machine and i wanted to ask how i
IK> can
I am trying to parse an email log database with about 900,000 records for records
older than 2 days (ie 600,000 records).
I make a dbi connection and select all records older than 2 days. It returns the rows.
Now I step through each row with a while loop, and if the entry is a virus, i open a
How stable is version 4.x? This database will be moved into production
fairly shortly and I need to make sure the version of mysql is extremely
stable. Thanks,
Joe
> From: Victor Pendleton <[EMAIL PROTECTED]>
> Date: Wed, 23 Oct 2002 14:40:58 -0500
> To: "'Joseph Koenig '" <[EMAIL PROTECTED]>, "'
On Thu, 24 Oct 2002, Peter Zuidema wrote:
> Please help,
> We have big performance problems.
> This is the situation:
>
> We haven an Windows NT server with a P355 processor and 256MB Ram. We have
> installed version 3.49 of mysql
> (we have also tried version 3.52).
>
> When we do a select on a t
David Churches wrote:
> Hi,
>
> I am using mySQL version 3.23.52 and I have tried to create an index on a
> large table. This was taking a very long time and so the command was
> terminated. Now the database seems to be corrupted, or at least
> inaccessible. Is there anything I can do?
>
> I have
Peter Zuidema wrote:
> Please help,
>
> We have big performance problems.
>
> This is the situation:
>
> We haven an Windows NT server with a P355 processor and 256MB Ram. We have
> installed version 3.49 of mysql
> (we have also tried version 3.52).
>
> When we do a select on a table which contai
Please help,
We have big performance problems.
This is the situation:
We haven an Windows NT server with a P355 processor and 256MB Ram. We have
installed version 3.49 of mysql
(we have also tried version 3.52).
When we do a select on a table which contains about 10.000 records, we have
for ab
Dear my friend,
I am using MySQL as database server. I still have
problem now to select appointment time whose 3 minute
difference (later) than now().
I can not use "timestampdiff". Is there "TimeStampDiff
" command in MySQL ?
I tried this command but it didn't work :
"
select * from appointment
Dear my friend,
I am using MySQL as database server. I still have problem now to select
appointment time whose 3 minute difference (later) than now().
I can not use "timestampdiff". Is there "TimeStampDiff " command in MySQL ?
I tried this command but it didn't work :
"
select * from appointmen
The reason it doesn't return NULL is NULL is never LIKE 'username'
CompMan86 wrote:
Two tables, groups and user_permissions.
Groups is indexed by groupid as primary key. User_permissions is indexed
by username and groupid.
For each user that's in a group, a row in user_permissions exists.
Dear my friend,
I am using MySQL as database server. I still have problem now to select
appointment time whose 3 minute difference (later) than now().
I can not use "timestampdiff". Is there "TimeStampDiff " command in MySQL ?
I tried this command but it didn't work :
"
select * from appointmen
> Hi Jorge
> I wonder if you could help me with the following:
> Look at my configuration - Linux Red Hat 7.2 with MySQL 4 running
smoothly
as ever and perl working throught its libmysqlclient.so
> Recently installed Kylix3 hoping to write Client Server API to edit my
mySQL bases from X Windows
> I
On Wed, 23 Oct 2002 19:15:59 +0300
"Andrey Hristov" <[EMAIL PROTECTED]> wrote:
> I am not an expert but I think that when there is not order by the
> output is sorted on the primary key.
> So : select * from log_answers_index limit 0,10 and select * from
> log_ansers_index where log_entry_id be
Natale,
Thursday, October 24, 2002, 10:57:00 AM, you wrote:
NB> Anyone knows how to backup innodb tables in the right
NB> sql order?
NB> ... i mean ... to allow restoring correctly
NB> without foreign key constraint violation (if in the
NB> backup file ddl code for the child table is before ddl
NB
I am the process of converting my companies applications from MS SQL to mySQL. It is
all going OK, however I am having trouble with the following
query:
SELECT Member.memberid, Member.mcname, Member.msname, UAGroup.groupname,
UAGroup.groupid, Member.buid FROM UAGroup
INNER JOIN UAMemberOfGrou
On Wed, Oct 23, 2002 at 10:19:26PM -0700, James Taylor wrote:
> So, apparently, you don't need to be a member of this list to send mail to
> it? What a great idea!
Actually, there are filters. Unfortunately, including the word mysql in the
body tends to flag the message as legitimate. Making it
I would like to announce the realease of MyProfiler , a tool to monitor you mysql and
log all the events occuring on your server .includes Index tuning wizard for your
mysql index optimization .
We hope you find it useful .
http://amr.activechannel.net/MyProfiler.htm
_
Sehr geehrte Damen und Herren,
seit Kurzem befasse ich mich mit MySQL und versuche ein eigens Programm
basierend auf der C-API zu entwickeln.
Die Entwicklung wird auf einem Red-Hat Linux Version 7.2 Rechner
durchgeführt. Hierbei wurden folgende bereits vorkompilierten MySQL-Pakete
verwendet.
MySQ
Sehr geehrte Damen und Herren,
seit Kurzem befasse ich mich mit MySQL und versuche ein eigens Programm
basierend auf der C-API zu entwickeln.
Die Entwicklung wird auf einem Red-Hat Linux Version 7.2 Rechner
durchgeführt. Hierbei wurden folgende bereits vorkompilierten MySQL-Pakete
verwendet.
MySQ
Hi,
I am using mySQL version 3.23.52 and I have tried to create an index on a
large table. This was taking a very long time and so the command was
terminated. Now the database seems to be corrupted, or at least
inaccessible. Is there anything I can do?
I have tried mysqlcheck but it seems to
Anyone knows how to backup innodb tables in the right
sql order?
... i mean ... to allow restoring correctly
without foreign key constraint violation (if in the
backup file ddl code for the child table is before ddl
code for the parent table i get an error).
Thanks in advance.
Natale Babbo
__
On Wed, 23 Oct 2002, Gelu Gogancea wrote:
> My dear friend,
Same to you
> TCP/IP is a protocol with KNOWLEDGE at ICMP level(see RFC792 ).
> The DNS server have a different purpose(see RFC 1034 or RFC 952 "HostNames
> table").
> Ping work at ICMP level.
Well well.. but it can't send ICMP echo pac
76 matches
Mail list logo
