PRIMARY KEY (`FIELD_1`),
KEY `FIELD_1` (`FIELD_1`),
You don't need a second key on the column, as it is a duplicate of the
primary key.
but, i do query sintax, just simple select count(*) from TABLE_1
where
FIELD_1 = XXX_CC;
But i got the result very long timemore 10 minutes
Johannes,
which version of MySQL you are running?
From http://www.innodb.com/bugfixes.html :
November 17, 2001:
The insert buffer tree can get into an inconsistent state, causing a crash,
and also crashing the recovery. This bug may appear especially in large
table imports or
Message [EMAIL PROTECTED] from zarko.mocnik [EMAIL PROTECTED] (return
path: [EMAIL PROTECTED]) and sent to [EMAIL PROTECTED] was NOT DELIVERED because
at least one virus was found within an attachment to it. Details Follow:
-
eTrust EZ Antivirus Version 5.3.7.4
Started
- Original Message -
From: David Phillips [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 04, 2002 4:01 PM
Subject: Re: How to index Optimization on 20 million record
PRIMARY KEY (`FIELD_1`),
KEY `FIELD_1` (`FIELD_1`),
You don't need a second key on the
Hi Bruce
01.02.02 15:41:49, Bruce Stewart [EMAIL PROTECTED] wrote:
Hi Andreas,
I think AUTO_INCREMENT is on a per-connection basis. So if
you're doing
this across different database connections, it will reset to 0.
[snip]
do a 'select * from tablename where test=1' and you will
see
I just attempted to upgrade a 3.23.41-max server on Linux 2.4.12 to
3.23.47-max. Before starting up 3.23.47-max, I added several Innodb
options to the my.cnf file:
---snip---
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M
innodb_data_home_dir =
03.02.02 18:33:50, Samy Elashmawy [EMAIL PROTECTED] wrote:
Folks, I have installed multiple copies of MySql ,
MyODBC , unixODBC and need to clean up the system. I
have removed the rpm versions , but now need to remove
the source versions. How is this done under linux ,
especialy for Mysql ,
Hi all,
My problem goes away after I have upgraded MySQL from
3.23.41 to 3.23.46. Thanks you for anyone who have
made suggestions or who have tried to figure out the
solution.
Kent.
--- Mr Kent Cheung [EMAIL PROTECTED] wrote:
Date: Wed, 30 Jan 2002 20:01:21 -0800 (PST)
From: Mr Kent Cheung
Moodss (a modular monitoring application, graphical and daemon) fully
supports the MySQL database and great efforts are made in collaboration
with the MySQL AB developer Sinisa Milivojevic, in order to achieve a
practical and thorough monitoring of MySQL servers. No less than 7
modules, such
Hi!
InnoDB seems to have created the database and started ok. This does not look
like an InnoDB bug.
I think gethostbyaddr asks from a connection the hostname, and subsequent
code checks that the host has access rights to mysqld.
For some reason gethostbyaddr_r crashes.
Hmm.. if you could run
If you supress aggregate funtions and group by clause then:
select *,
(case a.tipo
when 'F' then
case a2.tipo
when 'F' then a2.valor
when 'M' then a2.valor/2
else 0
end
when 'M' then a.valor/2
else null
end) as valorCalculado
from a
Hi.
Does somebody know which server hardware I have to buy to realize my following
problem ?
I have 3 tables. They are all connected to each other with some queries.
1st table has momentary 10.000 and should be upgraded to 50.000 records.
2nd table has 120.000 records at moment and
iain furneaux writes:
HI,
Firstly I hope this is the right list as the enquiry I have I do not class
as a bug due to my uncertainty about where the problem lies.
I have been using the C API for MySQL 2.22.32 on Linux 2.2.14 and I have
noticed that my program was getting to an
which version of MySQL you are running?
3.23.39 :-(... sorry for not including this earlier. I will try and
move to .47
Thanks!
From http://www.innodb.com/bugfixes.html :
November 17, 2001:
The insert buffer tree can get into an inconsistent state, causing a crash,
Hi,
About glibc, I saw the 2.2.5 release included the spinlock.c patch, part of
the internals.h (except the following part :
-#define STACK_SIZE (2 * 1024 * 1024)
+#define STACK_SIZE (128 * 1024)
)
The local_lim.h is also partially patched :
The following part :
-#define PTHREAD_THREADS_MAX
Hi,
i'm running the mysql server in windows98. When i restart windows mysql
(innodb) states the database was not shut down correctly. However when i
shut down the server explicitely with mysqladmin things seem to work OK.
Is it really necessary to do this explicit shutdown with mysqladmin
jocelyn fournier writes:
Hi,
About glibc, I saw the 2.2.5 release included the spinlock.c patch, part of
the internals.h (except the following part :
-#define STACK_SIZE (2 * 1024 * 1024)
+#define STACK_SIZE (128 * 1024)
)
The local_lim.h is also partially patched :
The following
Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
That suggests using LOAD DATA INFILE, but I would really like to avoid dumping
a very large ISAM mysql table to a text file, just to load it back into another
table (MYISAM).
I was looking for answers as to why isamchk
Hery Yulianto a écrit :
- Original Message -
From: David Phillips [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 04, 2002 4:01 PM
Subject: Re: How to index Optimization on 20 million record
PRIMARY KEY (`FIELD_1`),
KEY `FIELD_1` (`FIELD_1`),
You
Hi,
To tell you a truth, I have downloaded 2.2.5 but still have not found
time to build / install them.
Perhaps the fear of glibc compilation / installation ;)
I've already installed 2.2.5, and it works really fine for me (and at least
it compiles with gcc 3.0.3 ! :))
(with #define
http://www.alt-php-faq.org/local/70/
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: 04 February 2002 11:30
To: [EMAIL PROTECTED]
Subject: Help, Root User Password Lost!
zhu,
Monday, February 04, 2002, 7:24:22 AM, you wrote:
zc Hello Friends:
zc My
On Monday 04 February 2002 14:02, Henry Hank wrote:
Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
That suggests using LOAD DATA INFILE, but I would really like to avoid
dumping a very large ISAM mysql table to a text file, just to load it back
into another table
Hi again Venu,
I tried the latest one. I'm sorry to say that the error persists...
Still leaking handles at terrible speeds. One handle for each select even if we close
the set.
You mentioned something regarding a new version of the server engine as well... Is
this going to be released soon?
Hi there. I have a need to reach into a remote database and write to their
tables from my tables. Or have them reach into my tables and read from
mine. Either way, data will travel over the net. I need that data secure
and I don't know how I can make that secure. It's not a permissions
Hi Rich,
Just so I understand you correctly;
1. Are you trying to use the replication features of MySql for
this communication?
Or
2. Are you talking on the client side application, like PHP,
Java, Perl...?
How about encrypting the data itself and skipping the
Dear all,
I experienced some problems with using MySQL API:
My problem is that if I don't use database a long time it is disconnected and when I
try to connect again at first I use method mysql_ping(), which reopens connection and
that's the point. Please see next code of MySQL API:
static
Mikel King chortled:
Hi Rich,
Hey there. Thanks for the response.
Just so I understand you correctly;
1. Are you trying to use the replication features of MySql for
this communication?
Nope.
Or
2. Are you talking on the client side application, like PHP,
Java,
There is no reason to add comments like There's no successful career path
for a hand-held dba. People come to this list looking for help. Comments
such as this will cause some folks not to ask questions for fear of public
ridicule.
Simply answer the question and move on. If you feel a need to
Skriniar Gregor writes:
Dear all,
I experienced some problems with using MySQL API:
My problem is that if I don't use database a long time it is disconnected and when I
try to connect again at first I use method mysql_ping(), which reopens connection and
that's the point. Please see next
Hery,
You need to get some idea of how many records are being counted.
What I suggest is to put a Limit on your select statement and gradually
increase it.
For example
select count(*) from TABLE_1 where FIELD_1 = XXX_CC limit 10;
If this takes too long, then you know right away
At 15:45 +0100 2/4/02, Skriniar Gregor wrote:
Dear all,
I experienced some problems with using MySQL API:
My problem is that if I don't use database a long time it is disconnected and
That's how it's supposed to behave. What's the bug?
If your application really needs to hold the connection
Mary Grassell writes:
Is your software free to use for Commercial use?
Thank You,
Mary Grassell
sql,query
Hi!
If your program is not a GPL one, you should obtain a licence.
Please write to [EMAIL PROTECTED]
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
At 4:46 PM +0100 2/3/02, Joseph Bueno wrote:
Michael Collins a écrit :
I am trying to normalize some MySQL tables and need to move a few
columns from one table to another while maintaining the relationship
between the two.
SELECT DISTINCT ProductID
(SELECT
ProductID,
SmImage,
From the manual (section 4.9.5 'The Slow Query Log'):
The slow query log can be used to find queries that take a long time to
execute and are thus candidates for optimisation. With a large log, that
can become a difficult task. You can pipe the slow query log through the
mysqldumpslow command to
I'm getting a lot of this in my server log, any idea of what's causing it
or how to find out? I think they are occurring when my web server attempts
to communicate with the database server. It doesn't happen all the time,
but it's happening a lot and causing havoc with being able to view web
Moodss (a modular monitoring application, graphical and daemon) fully
supports the MySQL database and great efforts are made in collaboration
with the MySQL AB developer Sinisa Milivojevic, in order to achieve a
practical and thorough monitoring of MySQL servers. No less than 7
modules, such as
04.02.02 15:11:30, Rich Fortnum [EMAIL PROTECTED] wrote:
Hi there. I have a need to reach into a remote database and write to their
tables from my tables. Or have them reach into my tables and read from
mine. Either way, data will travel over the net. I need that data secure
and I don't know
--On Saturday, February 02, 2002 2:16 AM -0600 Ed Carp [EMAIL PROTECTED] wrote:
I have not completely figured out what the problem is and I never got a
response from any one else on the list. I can tell you it looks like a
mutex problem between two threads. We have followed it down
On Mon, Feb 04, 2002 at 02:27:01PM +0200, Sinisa Milivojevic wrote:
Jeremy,
It could also be a bug in glibc.
As you are using Linux, can you try out binary ??
That was your binary on Linux.
Strangely, I just started up that exact same copy of 3.23.47-max and
it worked fine after a
On Monday 04 February 2002 02:30 am, Jeremy Zawodny wrote:
0x807bb5f handle_segfault__Fi + 383
0x82a94aa pthread_sighandler + 154
0x7cb80076 __evoke_link_warning_llseek + 1954074198
0x7cb7fe19 __evoke_link_warning_llseek + 1954073593
0x7cb713e6 __evoke_link_warning_llseek + 1954013638
Hello all,
i am experiencing the odd problem of 'lost connection
to MySQL server during query'. This is happening because my
mysqld server (for some reason) restarts while i am accesing it.
I am using 2 SQL queries to reproduce the problem i have and decouple
it from my C++ application.
Jeremy Zawodny writes:
On Mon, Feb 04, 2002 at 02:27:01PM +0200, Sinisa Milivojevic wrote:
That was your binary on Linux.
Strangely, I just started up that exact same copy of 3.23.47-max and
it worked fine after a machine reboot.
That's most unusual (and troubling).
Thanks,
On Mon, Feb 04, 2002 at 07:15:33PM +0200, Sinisa Milivojevic wrote:
Yes, this is troubling ...
It could be hardware, though ...
Can you find anything in MySQL log and especially in /var/log/dmesg
or /var/log/messages.
Nope.
Sometimes, not often, Linux kernel is capable of noticing
Neeraj,
Monday, February 04, 2002, 7:55:15 AM, you wrote:
NA Just a simple question. I am using perl DBI to connect to
NA mysql. Its like a daemon, so its always running. But
NA whenever i get a signal it connects to a database
NA (different database each time). So there are 2 ways
NA to do
Joey,
Saturday, February 02, 2002, 8:16:21 PM, you wrote:
JF Dear all,
JF I am running MySQL 3.22.xx at Mandrake 8.1, how can I
JF grade my MySQL??
Please, find your answers at:
http://www.mysql.com/doc/U/p/Upgrade.html
JF Thanks
--
For technical support contracts, goto
Rich,
Sunday, February 03, 2002, 3:03:23 PM, you wrote:
RF Hey there. Wanted to know what security is built
RF into MySQL with respect to writing SQL to remote
RF tables. I have clients that want reads and writes to
RF their tables, but I don't want to share their information.
RF Any idea
(Please reply directly, I am only on the digest list, thanks)
I have an SQL statement that is taking far too long to run, around 11
minutes (while locking inserts/updates).
We have installed some more RAM, and I need help with my.cnf and the
troublesome SQL.
Can anyone suggest some config
Hello, everyone.
I have a slight dilemma, and was wondering what the standard workaround
is. I have three tables: owners (auto_increment primary key is
owners_id), objects (auto_increment primary key is objects_id), and
owners_objects (which is a foreign key table that I created, under
Hi, I have posted a question here previously regarding the query of
talbles that contain duplicate entries in rows with only the id being
different. My question was how to display or abtain ONLY the row with
the highest id value in the result set along with all the other destinct
rows in the
appologies the MySQL version is 3.22.32 (sorry fat fingers! :-) )
- Original Message -
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, February 04, 2002 12:15 PM
Subject: Re: Memory Leaks ?
iain furneaux writes:
HI,
Firstly I
On Sat, 2002-02-02 at 20:22, Egor Egorov wrote:
Get some more info at: http://www.mysql.com/doc/I/n/Insert_speed.html
Hi,
Would the REPLACE .. SELECT be faster if i use LOCK TABLES as it says in
the manual for the INSERT command ?
It's a REPLACE .. SELECT for thousands of rows.
Thanx,
--
On Mon, 4 Feb 2002 at 18:06:34 +0100, Andreas Schoelver wrote:
04.02.02 15:11:30, Rich Fortnum [EMAIL PROTECTED] wrote:
Hi there. I have a need to reach into a remote database and write to their
tables from my tables. Or have them reach into my tables and read from
mine. Either way,
Please help me.
I'm installing mysql-3.23.45 on Sparc 20 with Solaris 2.5 and when
i give the comand make...i have this problem.
..
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/usr/local/mysql-3.23.45/libmysql'
make[1]: Leaving directory
Have you checked on the ulimit for the user that is mysql?
On Sat, 2 Feb 2002, Dan Nelson wrote:
Date: Sat, 2 Feb 2002 20:58:07 -0600
From: Dan Nelson [EMAIL PROTECTED]
To: Randy Arabie [EMAIL PROTECTED]
Cc: Manuel Bouyer [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
S TO MAKE TO ADD SITES FOR ORDER ALFABETICA. USING MYSQL 3,23
www.buscapopular.com.br
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
At 13:10 -0500 2/4/02, Erik Price wrote:
Hello, everyone.
I have a slight dilemma, and was wondering what the standard
workaround is. I have three tables: owners (auto_increment primary
key is owners_id), objects (auto_increment primary key is
objects_id), and owners_objects (which is a
On Mon, 4 Feb 2002 at 13:10:29 -0500, Erik Price wrote:
[ snip background ]
I am sure that many people have done this sort of setup. But what do
you do to get around the problem of INSERTing a pair of values that
already exist? Because the combinations in owners_objects are UNIQUE
iain furneaux writes:
appologies the MySQL version is 3.22.32 (sorry fat fingers! :-) )
Just try our latest 3.23 C API
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
On Monday, February 4, 2002, at 01:48 PM, Marcus Collins wrote:
You can use REPLACE instead of INSERT -- see the manual entry:
URL:http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.
html#REPLACE
Thanks Marcus! My knowledge of MySQL is pretty basic. It has also
HelloErik,
I have a slight dilemma, and was wondering what the standard workaround
is. I have three tables: owners (auto_increment primary key is
owners_id), objects (auto_increment primary key is objects_id), and
owners_objects (which is a foreign key table that I created, under
advice
On Mon, 4 Feb 2002, William R. Mussatto wrote:
Have you checked on the ulimit for the user that is mysql?
I've checked a lot of things.
Which would apply:
kern.maxfiles
proc.[mysqld_pid].rlimit.descriptors.soft
proc.[shell_pid].rlimit.descriptors.soft
Obviously,
Hello all !
I see it's a very busy list so I will try to by short to my first question:
1) Is there a way to put the REAL numbers of rec in the ID=auto-increment? I
made some tests so this number is higher than total recs of the
table.(export/import to text doesn't help)
The Rec_num is stored
Hello again!
I see many people works here with php and that's natural, as php is
connected with MySQL.
In php graphics, I found that printing with a TTF font has no possibility
to set the font high. Is this true?
Also is not possible to open only once one font file and not as many times
as
Im afraid I do not know where the possible leaks are as I only have the
mtrace dump which I included a section of in my first posting, I have
included the whole dump. As the current code runs into several hundred lines
I do not think it would be helpful
mtrace dump
Memory not freed:
iain furneaux writes:
Im afraid I do not know where the possible leaks are as I only have the
mtrace dump which I included a section of in my first posting, I have
included the whole dump. As the current code runs into several hundred lines
I do not think it would be helpful
mtrace dump
Andreas Schoelver chortled:
How about using a VPN (virtual private network) ?
regards
Andreas
sql,select,mysql
I want to minimize the network structure on their part because they will
have a minimal DSL system as they are on the outskirts of town. As well, I
don't want the bulk of the
yes after every call, that was the first thing I tried, it made the
situation better but not cured it. Are there any circumstances where
mysql_free_result() will not free the result ? does it have to be called
before any further mysql_real_query() calls are made even on a diffrent
MYSQL_RES
Marcus Collins chortled:
(sorry; missed the original post)
If you have admin access to both machines, then how about using stunnel
URL:http://www.stunnel.org/ to set up an SSL-encrypted connection
between both machines on the ports on which mysqld communicates?
There's an example for
On Mon, 4 Feb 2002, Randy Arabie wrote:
Date: Mon, 4 Feb 2002 12:01:11 -0700 (MST)
From: Randy Arabie [EMAIL PROTECTED]
To: William R. Mussatto [EMAIL PROTECTED]
Cc: Dan Nelson [EMAIL PROTECTED],
Manuel Bouyer [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re:
hello list,
I'm having trouble with an INSERT command based on a select
Is what I want is in my contacts table I'm selected certain criteria and
then inserting a note into my contactnotes table certain values
Here's what I have so far
contactnotes mysql table headers:
iain furneaux writes:
yes after every call, that was the first thing I tried, it made the
situation better but not cured it. Are there any circumstances where
mysql_free_result() will not free the result ? does it have to be called
before any further mysql_real_query() calls are made even on
Kinney,
I did the following and it worked.
$text=Adding FAQ\'s;
$query=Update faqs SET subject='$text' WHERE id='110';
mysql_query($query);
Good luck.
--
-
Before posting, please check:
http://www.mysql.com/manual.php
I'm currently trying to install MySQL in my home directory on a server which
I do have root access to. I follow the steps outlined in O'Reilly's
'MySQLmSQL' book and I get through the first several steps before problems
occure. To set the stage, I'm using mysql-3.23.47. I'm able to 'configure',
Hi Makis,
There are separate PHP mailing lists - you can find them at www.php.net
- Jonathan
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 04, 2002 11:29 AM
To: MySQL list (E-mail)
Subject: PHP with TTF fonts
Hello again!
I see many people works
What does this have to do with mysql?
Please try a PHP mailing list
ps: database, sql, mysql
savaidis wrote:
Hello again!
I see many people works here with php and that's natural, as php is
connected with MySQL.
In php graphics, I found that printing with a TTF font has no possibility
On Mon, Feb 04, 2002 at 12:01:11PM -0700, Randy Arabie wrote:
On Mon, 4 Feb 2002, William R. Mussatto wrote:
Have you checked on the ulimit for the user that is mysql?
I've checked a lot of things.
Which would apply:
kern.maxfiles
I guess I'm a little confused about the MySQL versions.
What is the real production version? If 4.0.2 can be called a
production version, I'd gladly use it on my web site; however, it
doesn't seem to indicate that on the MySQL home page. So if I find a
bug in 3.23.47 that was fixed a long time
Hi,
-Original Message-
From: Jens Collin [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 04, 2002 5:42 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: MyODBC leaking handles...
Hi again Venu,
I tried the latest one. I'm sorry to say that the error persists...
If you are using tables of the MyISAM type, the auto-increment goes up every time you
insert,
regardless of any deletes. The only way to reset it is to drop and re-create the table
or do a
delete from table command with no where clause. ISAM tables do not do this. Read up
in the manual
on
Thanks, I think that maybe the cause, I was using a single MYSQL structure
for mutiple calls with diffrent MYSQL_RES pointers.
- Original Message -
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, February 04, 2002 7:51 PM
Subject:
Anyone know what this means? I'm getting A LOT of them in my MySQL server
log.
Thanks,
-Ed
ps... any idea on how to troubleshoot something like this?
Error Message:
020204 8:20:54 Aborted connection 22 to db: 'AtFantasy2' user: 'apache'
host: `localhost' (Got an error reading
On Monday 04 February 2002 11:59 am, Jeremy Zawodny wrote:
?This does look like a libc bug. How did you build either one of the
binaries?
They're your binaries. ?I don't buld my own binaries on Linux to save
the hassle of using libraries that are different from what you folks
use. :-)
In my experience, this happens when the version of mysql you're running is
newer then the version of libraries that something on your system was
compiled with, typically, installing the new libs on your system and
recompiling php or whatever you're using to connect to the mysql server
Hello everyone, Im running MySQL version 11.15 Distribution 3.23.47 on
Windows 2000. I'm having issues with the CAST command, for example, if
I execute:
CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE);
I receive the error:
ERROR 1064: You have an error in your SQL syntax near
At 01:19 PM 2/4/2002 , you wrote:
2) I use MySQLfront just for a couple of days. I find it very usefull (has
to be written in Delphi) Is this the best freeware for this job or is there
a better one ?
Makis,
MySQLFront is pretty good considering the price. :)
There is
On Mon, Feb 04, 2002 at 04:37:33PM -0600, Erin Lilly wrote:
Hi, this is Erin Lilly, I've used support before with you all for
bodyconsultant.com and you were extremely helpful. I'm installing mysql on
erinlilly.net and have run into that common /tmp/mysql.sock (111) error
Hi, you just
On Mon, 4 Feb 2002, William R. Mussatto wrote:
Have you checked on the ulimit for the user that is mysql?
I did, but had only set it dynamically. I did raise it quite high,
5000 I believe. After that I initiated the load, but from a normal
user shell which had the default
On Mon, Feb 04, 2002 at 03:43:40PM -0700, Randy Arabie wrote:
On Mon, 4 Feb 2002, William R. Mussatto wrote:
Have you checked on the ulimit for the user that is mysql?
I did, but had only set it dynamically. I did raise it quite high,
5000 I believe. After that I initiated the load,
Hi, this is Erin Lilly, I've used support before with you all for
bodyconsultant.com and you were extremely helpful. I'm installing mysql on
erinlilly.net and have run into that common /tmp/mysql.sock (111) error
version: 3.23.45-pc-linux
To telnet in as root:
erinlilly.net
log-admin
pw-paws
On Mon, Feb 04, 2002 at 02:33:40PM -0700, Sasha Pachev wrote:
On Monday 04 February 2002 11:59 am, Jeremy Zawodny wrote:
?This does look like a libc bug. How did you build either one of the
binaries?
They're your binaries. ?I don't buld my own binaries on Linux to save
the hassle of
On Mon, Feb 04, 2002 at 11:55:57AM +0100, Daniel Backhausen wrote:
Hi.
Does somebody know which server hardware I have to buy to realize my following
problem ?
I have 3 tables. They are all connected to each other with some queries.
1st table has momentary 10.000 and should be
I have an application that stores a large (up to 6gb) database in an
InnoDB table. I'm using an InnoDB table to have concurrent inserts and
selects and to get beyond the 2gb limitation.
I have to allow read-only remote database connections and cannot enforce
that users use any kind of special
Oganes,
I have the following create table, and I get the following error when I create it.
It used to work before. Can anyone help?
CREATE TABLE PROTOCOL_GROUPING(
PROTOCOL_GROUPING_ID MEDIUMINT(20),
GROUP_NAMEVARCHAR(50)NOT NULL,
PROTOCOL_ID
On Mon, Feb 04, 2002 at 05:41:46PM -, Robin Keech wrote:
(Please reply directly, I am only on the digest list, thanks)
I have an SQL statement that is taking far too long to run, around
11 minutes (while locking inserts/updates).
We have installed some more RAM, and I need help with
Hi All,
Does anyone knows how to change my mysqladmin password or how to find out
what the password it, I installed the rpm package, didn't setup any
password, however when I setup a tool to use it with, the tool is asking me
to produce the mysqladmin password.
Thanx
On Monday 04 February 2002 01:12 pm, Greg Bailey wrote:
What is the real production version? ?If 4.0.2 can be called a
production version, I'd gladly use it on my web site; however, it
doesn't seem to indicate that on the MySQL home page. ?So if I find a
bug in 3.23.47 that was fixed a long
Hi All,
I have tried out some performance testing with some heavy SELECT and
UPDATES. The database in question has only 500 records but there are lots of
SELECTs and UPDATEs and the results are:
after timing the program that was targeting MySQL on different platforms
the results are (client
From time to time I seem to see error messages in my database.err log file
for MySQL.
020130 11:19:10 Aborted connection 40437 to db: 'xyz' user: 'abc' host:
`localhost' (Got an error reading communication packets)
I've been reading about the Morning Bug and here's what I extracted about it:
On Mon, 4 Feb 2002, Manuel Bouyer wrote:
What a minute ... you're loading the tables to a 'mysqld' process, using
the 'mysql' command, rigth ?
Maybe it's just the mysql command which runs out of files descriptors ?
Did you try to raise the limit of the shell before starting it ?
Right.
Hi,
Your problem is that your query uses all of the rows in the table. That
means that the indexes on the table are incorrect.
You should try putting a single index on prev_e3_id and a single index on
the other table. It'll probably improve your performance a lot.
BTW. Schedule some time for
1 - 100 of 130 matches
Mail list logo