hi van
thank you for responding.
but i have gcc-2.95.2-149 installed (a suse 7.1 version). so i think this
isn't the problem...
i tried several other things:
i changed to other auth_mysql modules for apache: didn't help
i used apache 1.3.17: didn't help
i tried it fi
hi,
i've not reconfigured linuxthreads.
/proc/sys/kernel/threads-max has 57344. At the time
when the machine hits 100% CPU, apache processes are
taking most of the CPU time, and i have around 250
processes on the entire system, with around 10-15
running processes. mysqladmin status shows me a
Steven Glogger wrote:
>
> hi van
>
> thank you for responding.
> but i have gcc-2.95.2-149 installed (a suse 7.1 version). so i think this
> isn't the problem...
> i tried several other things:
> i changed to other auth_mysql modules for apache: didn't help
> i used apache
Hi everybody: here is a new version of moodss.
Check it out! (or at least the screenshots at
http://jfontain.free.fr/moodss3.gif or
http://jfontain.free.fr/moodss4.gif :).
Notes:
- moodss modules can now be written in Python! Sample randpy and
minipy modules are provided. Documentation (see ra
small problems with query below...
my fault?
mysql> desc poll_answer;
+-+-+--+-+-+---+
| Field | Type|Null | Key | Default | Extra |
+-+-+--+-+-+---+
| poll_id | int(10) | | | 0 |
On Tue, Mar 20, 2001 at 08:27:39AM +0100, René Tegel wrote:
> copying tables between databases:
>
> create table db2.table2 select * from db1.table1;
>
> however, you'll loose meta data (indexes) on this table, so you'd have to
> create them again.
>
> second method:
> use the explorer or a dos
#x27;, '', 'ApacheBench/1.3c',
'/www/www.dedserius.com/index.php3', 'tempe.ds.lan', '192.168.1.2', '20010320
00:34:47', 'scottsdale.ds.lan', '', '/index.php3')
Scottsdale is a Dual 400 MHz Celeron with 128MBytes RAM;
Hi,
I have a strange problem happening. I have created an application on a PC
with Mysql-3.23.22-beta and I have different results than on a standard
Mysql-3.23.35.
The main problem seems to be at the following:
Say have 6 rows with a column name "actif", out of these 6 rows 3 have a
NULL va
On Tue, Mar 20, 2001 at 10:03:34AM +0100, Fred van Engen wrote:
> Third:
>
> RENAME TABLE tbl_name TO new_table_name;
>
> (see http://www.mysql.com/doc/R/E/RENAME_TABLE.html )
>
> Fourth:
>
> ALTER TABLE tbl_name RENAME [TO] new_table_name;
>
> (see http://www.mysql.com/doc/A/L/ALTER_TABLE.ht
I would like to know how to write a SQL statement if i have a composite key
present in the table. eg. my table is
APPCODE EMAILID EMAIL
1 ML1 [EMAIL PROTECTED]
1 ML2 [EMAIL PROTECTED]
2 ML1 [EMAIL PROTECTED]
3 ML1 [EMAIL PROTECTED]
4 ML1 [EMAIL PR
"Gerald L. Clark" wrote:
>
> This does not answer your problem, but 'timestamp' is a reserved word.
>
...not the complete truth ;-) :
7.34 Is MySQL picky about reserved words?
A common problem stems from trying to create a table with column names
that use the names of datatypes or functions b
i wanna ask something ..
can an asp application connect to mysql database ??? if can how ?? please i really
need it for my final exam .. tengkyu anyway
hi van
ok, here we are:
CONFIGURE/INSTALLATION ===
i installed it with:
./configure --datadir=/usr/local/mysql/data --localstatedir=/www/server/dat
abases
make
make install
cd scripts
./mysql_install_db
cd ../support-files
chmod 755 mysql.server
cp mysql.server /etc/rc.d/m
what about:
CREATE UNIQUE INDEX id ON thistable (APPCODE, EMAILID);
regards,
rene
- Original Message -
From: "Duke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 4:02 PM
Subject: Wats the CREATE TABLE statement?
I would like to know how to write a SQL st
Bonjour,
Here is my setup :
Mysql-3.23.35 complied from sources with :
./configure --prefix=/usr/local/mysql --without-bench --enable-thread-safe-client
--with-innobase
System: SunOS sun013
Hello,
I'm a MySQL newbie (hopefully, there's a few others of me around so I won't
feel like I stick out so much).
I've setup a Linux box running Red Hat 7.0 with Apache 1.3.12, PHP 3.0.18,
and MySQL 3.22.32 (I know its an older version, but our web hosting service
has not upgraded their vers
Has anybody come across this exception, and can advise me what it means ?
Thank you,
David.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archi
In JDBC2.0, you can move the invisible pointer witing your ResultSet
backwards and forward, or to absolute row numbers. You can therefore move
the pointer completely out of the table - fro wxample, by calling
ResultSet.beforeFirst(). If you then attempt to access the "current" row,
you will get t
Hi all,
The original message below was posted to the BugTraq mailing list. Have the
developers seen this? I know it talks about version mysql-3.20.32a (which is
ancient), but he mentions that it affects other versions.
Anyway, I don't run my MySQL server as root, so I'm not worried. :)
Regards,
Hello ,
can anyone tell how to connect from vc++ to mysql server.I badly
need it for my project.
satish.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello everybody,
I have some pb to administrate mysql, I can't create a new database error:
you are an anonymous localhost
I just can create a new tables in database already exist.
what can I do , please help m!!!
OH! You're running Apache. Why didn't you say so?
Can I also assume that the Apache processes are the clients of Mysql?
You can throttle back Apache to prevent a system crash much easier than you
can throttle Mysql (IMHO).
Use a line like this in Apache's httpd.conf file:
MaxClients 50
Thi
Hi,
I am currently exploring the replication feature in 3.23.33 and
encountered this error the moment I start the slave server:
010320 18:38:13 Slave: connected to master '[EMAIL PROTECTED]:9900',
replication started in log 'FIRST' at posit
ion 4
010320 18:38:13 Slave: received 0 length pack
Hi!
On Mar 20, Basil Hussain wrote:
> Hi all,
>
> The original message below was posted to the BugTraq mailing list. Have the
> developers seen this? I know it talks about version mysql-3.20.32a (which is
> ancient), but he mentions that it affects other versions.
>
> Anyway, I don't run my MyS
Hello!!
I have a question for the mysql install.
Type of mysqlsource distribution
Mysql Versionmysql-3.22.32.tar.gz
My System SunOS stachyonbse01 5.7 Generic sun4u sparc SUNW,Ultra-60
After upload
> gunzip > mysql-3.22.34.tar.gz | tar -xvf -
Result of the a
Hi there,
I am a mysql newbie. Is there anybody that can help me solve this code, so that it can
run on mysql
$sql="CREATE TEMPORARY TABLE tempingr SELECT resepid FROM resep r WHERE NOT EXISTS
(SELECT * FROM what_ingr w WHERE w.resepid=r.resepid and NOT EXISTS
At 09:47 AM 3/20/2001 +0100, \"Piotr Gapinski\" wrote:
>small problems with query below...
>my fault?
>
>mysql> desc poll_answer;
>+-+-+--+-+-+---+
>| Field | Type|Null | Key | Default | Extra |
>+-+-+--+-+-+--
You are getting that error because your JSP pages are trying to connect to
MySQL using the login javaworks and no password.
Either:
1: You've not GRANTed any permissions to javaworks@localhost
or
2: You did GRANT permissions but with a password and you are not sending the
password.
HTH,
Cal
http
Hi,
the version mysql that I am using supports the transactions but these
are not recognized from the DBD.
How can I resolve the problem?
Thanks
--
Brunella del Sorbo
Officine Digitali Srl
Idee Tecnologie & Soluzioni per il Web
Via Ferrarese 219/7 40128
Bo
Sorry,
MySQL does not yet support sub-selects.
Cal
http://www.calevans.com
-Original Message-
From: Budiono Tjiayono [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 6:17 AM
To: [EMAIL PROTECTED]
Subject: Exists and Not exists
Hi there,
I am a mysql newbie. Is there anybody t
Hello all!
I have running now mysqld with --long-log option.
is it fully debug log of mysql?
becouse when phpmyadmin communicating with mysql it say
'Unknown database' error. But when i look to logs there is nothing
about this error.
How is possible turn on full log debuging.
Thank You!
S poz
Hi,
U can check out this page to see what an alteon is:
http://www.alteonwebsystems.com/products/testing/
Regards
Pedro
- Original Message -
From: "Jeremy D. Zawodny" <[EMAIL PROTECTED]>
To: "Pedro" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 4:53 AM
Subject:
Hi Everyone
I know this type of question has been answered quite frequently so
please accept my apologies if this is "old hat" and just annoying. I
have spent a good few hours searching past discussions and the 'net
but I still haven't been successful so I'm posting my question here.
I am buildi
Hi,
I get the following message if i try to connect to server:
Can't connect server through socket /var/lib/mysql/mysql.sock(111)
Cal said, i should modify my php.ini and should give the exact definition for
the mysql socket.
but i don't have an entry in the php.ini for mysql socket.
any idea
Gilles Dumangin writes:
> Hi,
>
> I have a strange problem happening. I have created an application on a PC
> with Mysql-3.23.22-beta and I have different results than on a standard
> Mysql-3.23.35.
>
> The main problem seems to be at the following:
>
> Say have 6 rows with a column
BAUMEISTER Alexandre writes:
> Bonjour,
>
> Here is my setup :
>
> Mysql-3.23.35 complied from sources with :
> ./configure --prefix=/usr/local/mysql --without-bench --enable-thread-safe-client
>--with-innobase
>
>==
It's my mistake, for setting the same server-id on both servers.
Lois
-Original Message-
From: Neo Sok Lay [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 20 March, 2001 7:41 PM
To: [EMAIL PROTECTED]
Subject: URGENT: Replication problem
Hi,
I am currently exploring the replication feature
it looks like that:
[MySQL]
mysql.default_socket=
but I think thats not the problem. has your apache enough rights to access
the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to
group "mysql".
-> "mysql:x:27:apache" or something similar, then make "chmod g+rx
/var/li
Jeremy,
Thanks for the info.
Do you happen to know how many actual hits a Yahoo or
eBay or Google get each day?
According to http://us.mediametrix.com/data/thetop.jsp
Yahoo had about 60 million "unique visitors" in Feb
Google had about 10 million
eBay was in the middle
Unique Visitor is the c
maillists writes:
> it looks like that:
>
> [MySQL]
> mysql.default_socket=
>
>
> but I think thats not the problem. has your apache enough rights to access
> the directory /var/lib/mysql ? if not edit /etc/group an add "apache" to
> group "mysql".
> -> "mysql:x:27:apache" or s
Alex,
let us see. A known bug with Innobase is that was not included
in univ.i in directory mysql/innobase/include. Then Innobase files are
created with arbitrary access permissions on some Unixes.
Could you look with ls -l what permissions Innobase data file ibdat1 has
on your machine and also
>I get the following message if i try to connect to server:
>
>Can't connect server through socket /var/lib/mysql/mysql.sock(111)
Is mysqld running (ps -ax)?? is your mysql.sock in /var/lib/mysql?
I've only seen mysql.sock in /tmp if you've got a config file for
connection to mysql edit it to m
HI
I am trying to set up an ODBC connection between my Windows 2000 PC and
my Web Server which has a MySQL database on it. I installed the MyODBC
package for Windows NT and entered all the relevant information:
DSN E-SkyMySQL
MySQL host 192.168.1.100
MySQL Database Name eskylight
User httpd
and
Hi Thanks for the help,
I checked again.
but i don't have an entry in php.ini
[mysql]
mysql.default_socket =
So, i did execute the tip from egon.
But now,
i don't get the content from .php files
but i think i'll get it to work today.
thanks
regards
denis
---
for mysqld -child processes. i set it manually, but how to do it
automatically. has somebody done this ?
thanks
christoph
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
Your workstation may not be in the host table of the MySQL Server.
Pat...
- Original Message -
From: "Nick" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 9:31 AM
Subject: Problem Setting up MyODBC Driver
> HI
>
> I am trying to set up an ODBC connecti
I am running mysql version 3.23.35 on a linux platform.
The hardware platform is a PIII 700 with 500Mb of ram and a fast SCSI drive.
The server is currently supporting about 200 concurrent connections, with a
view to up this to a couple of thousand.
My problem is the time it takes to make a conne
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
It would also be VERY cool to be able to adjust the priority of selects like you can
with inserts. In some cases I know selects are going to take long and thus do not want
them to take all resources.
Also, it would be REALLY cool to be able to specify a time limit for a select after
which time
>Description:
I have download the version 3.23.33 - BSDI(Intel) and when i tried to run
scripts/mysql_install_db, i receive the error below:
./bin/my_print_defaults: can't load library 'libz.so'
WARNING: The host 'wave.seachange.com' could not be looked up with resolveip.
This probably me
This is documented in the manual as a "kernel fork bomb". See manual for solution.
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> "Paul Coleman" <[EMAIL PROTECTED]> 2001/03/21 12:35:28 >>>
I am running mysql version 3.23.35 on a linux platform.
The hardware platform is a PIII 700 with 500Mb of ram
Bonjour Heikki,
HT> let us see. A known bug with Innobase is that was not included
HT> in univ.i in directory mysql/innobase/include. Then Innobase files are
HT> created with arbitrary access permissions on some Unixes.
HT> Could you look with ls -l what permissions Innobase data file ibdat1 ha
Paul Coleman writes:
> I am running mysql version 3.23.35 on a linux platform.
> The hardware platform is a PIII 700 with 500Mb of ram and a fast SCSI drive.
> The server is currently supporting about 200 concurrent connections, with a
> view to up this to a couple of thousand.
>
> My probl
edit /etc/ld.so.conf
add a line for the directory that contains your library
run ldconfig
Alonso Guarisma wrote:
>
> Dear MySQL Sirs (or Andrew Schmidt)
> Please see attachament for error messages.
> Thaks in advance for any help.
>
> Alonso Guarisma
>
> Original Message
> S
Hi Nick,
I think u have to make the following.
go to mysql prompt:
use mysql;
then
select * from user;
is there an entry for the mysql client and the user on it?
i don't think so.
so u have to make a new entry.
then:
grant all on *.* to username@clienthostname
username (username u are conne
Hi,
i deleted mysql in /var
and make re-install in /usr/local/
but received the same error.
so i make an entry in the php3.ini
[mysql]
mysql.default_socket = /temp
where i found the mysql.sock
the error message is still there?
Other ideas?
regards
denis
On Tuesday 20 March 2001 14:52, yo
Howdy:
New guy to MySql and just installed 3.23 to my redhat 6.2 server. Was
wondering why I get 3 processes started for mysqld.
[nick@Dell1 nick]$ ps -ax | grep my
615 ?S 0:00 sh
/usr/bin/safe_mysqld --datadir=/var/lib/mysql --pi
646 ?S 0:00
/usr/sbin/mysqld --bas
An example query and an explanation of what you are trying to do
would be helpful.
Thanks
On Tue, 20 Mar 2001, Brunella del Sorbo wrote:
> Hi,
> the version mysql that I am using supports the transactions but these
> are not recognized from the DBD.
> How can I resolve the problem?
> Thanks
>
Hi,
This is my first posting, although i've been signed up to the list for a
while.
My problem is this.
Table A (5000 rows)
ID, NAME, SCORE
Table B (1000 rows)
ID, NAME, SCORE
I want all records from Table A and those from Table B where they match, for
this i'm using a right join. However, t
On 20.03.2001 14:48:58 Sinisa Milivojevic wrote:
> Also, do you have clients that do not call mysql_close at the end ,
> like PHP programs ?
Huh? According to the PHP manual, I always thought that it is unnecessary to
explicitly call mysql_close() in PHP. In the PHP manual it says, that the
c
Hei
If I send a SELECT sql-request to my DB and this request returns an
"Empty set" ...
mysql_num_rows(MYSQL_RES *result) returns 0 - This is OK
but mysql_num_fields(MYSQL_RES *result) returns 1 - This is not OK ;-)
Why? Am I missing anything?
Sincerely
Rafael Martinez
On Tuesday 20 March 2001 07:58, Richard Ellerbrock wrote:
> It would also be VERY cool to be able to adjust the priority of selects
like you can with inserts. In some cases I know selects are going to take
long and thus do not want them to take all resources.
>
> Also, it would be REALLY cool t
Dear Gerald Clark,
Thank you very much for your response. I tried your lines and apparently
it worked fine.
Alonso Guarisma
Gerald L. Clark wrote:
> edit /etc/ld.so.conf
> add a line for the directory that contains your library
>
> run ldconfig
>
> Alonso Guarisma wrote:
>
>> Dear MySQL Sir
Bonjour Sinisa,
SM> The above could indicate some timeout problem.
SM> Can you build mysql --with-debug and start it with --debug and see in
SM> the trace file when are the above timeouts reported ??
SM> Also, do you have clients that do not call mysql_close at the end ,
SM> like PHP programs ?
Hi.
You can use an ENUM column type assuming the numerical range is less than
65535 numbers.
http://www.mysql.com/doc/E/N/ENUM.html
-ravi.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 11:05 AM
To: [EMAIL PROTECTED]
Subject: Second
you can use either an ENUM or a SET. Other than that, no.
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 10:05 AM
To: [EMAIL PROTECTED]
Subject: Second Request - Limit Filed Input
Is there a way in MySQL
Is there a way in MySQL to limit the values that a (numeric) field can hold. For
example if I want a given field to only have the values 1 - 10 can I do this and can
it be done in the definition of the field when the table is created?
---
I am using Access as a front end to a MySQL database via MyODBC. All is well except
when I try to delete a record from a table that contains a dat field. I get various
results, all not the desired result. Most often I get prompted to verify that I want
to delete the current form. Is this a
Having works on the result table, not the source tables.
Since you did not select cnt, having can not examine it.
Maybe you ment 'where' instead of 'having' ?
\"Piotr Gapinski\" wrote:
>
> small problems with query below...
> my fault?
>
> mysql> desc poll_answer;
> +-+-+--
try:
[mysql]
mysql.default_socket = /temp/mysql.sock
Cal
http://www.calevans.com
-Original Message-
From: denis mettler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 10:40 AM
To: [EMAIL PROTECTED]
Subject: Re: Can't connect server through socket
/var/lib/mysql/mysql.sock(111
Hi,
If I use "mysqlhotcopy database/pathToTheBackupDirectory/" to backup the
whole database, what's the script/command to restore it?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
After upgrading from 3.23.32 to 3.23.35 I stopped getting statistics
when using mysqlimport. (Records: Deleted: Skipped: Warnings:)
I took a quick look at 3.23.32 mysqlimport.c and it is the same code as
3.23.35.
The command
---
mysqlimport --ignore --verbose --fields-terminated-by='
Add execute permission to mysql.server.
It is compiled without it.
Tim Thorburn wrote:
>
> Hello,
>
> I'm a MySQL newbie (hopefully, there's a few others of me around so I won't
> feel like I stick out so much).
>
> I've setup a Linux box running Red Hat 7.0 with Apache 1.3.12, PHP 3.0.18,
>
Hello
I am looking for help how to put gziped plain data file to mysql DB
and then get it from there.
Every time I try OUTFILE to file and then gzip -d file name I got file corrupted
Any help will be appreciated
Leo
**
T
Hi,
I did. but the problem is the same.
regards
denis
On Tuesday 20 March 2001 17:45, you wrote:
> try:
> [mysql]
> mysql.default_socket = /temp/mysql.sock
>
>
> Cal
> http://www.calevans.com
>
>
> -Original Message-
> From: denis mettler [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, Marc
houda chraibi wrote:
>
> Hello everybody,
> I have some pb to administrate mysql, I can't create a new database error:
> you are an anonymous localhost
> I just can create a new tables in database already exist.
> what can I do , please help m!!!
Read chapter 6sss!!!
--
You mus use GNU tar.
±è°æ¾Ö wrote:
>
> Hello!!
> I have a question for the mysql install.
>
> Type of mysqlsource distribution
> Mysql Versionmysql-3.22.32.tar.gz
> My System SunOS stachyonbse01 5.7 Generic sun4u sparc SUNW,Ultra-60
>
> After upload
> > gunzip > mys
Hello,
I encountered following problem: when using older mysql (3.22.23 vs
3.23.33) then older is about 4-6 times faster on the same machine. What
could be the problem? Sytem is Debian 2.2r2, older mysql was from .deb but
newer i built myself. The query looks like this:
SELECT f.foto_id, f.imgna
Hi again
No .. not really that big (the table)
-rw-rw 1 mysqlmysql 100916 Mar 16 17:09 imp_addr.ISD
-rw-rw 1 mysqlmysql1024 Mar 16 17:09 imp_addr.ISM
-rw-rw 1 mysqlmysql8648 Mar 9 11:06 imp_addr.frm
100K the ISD
On Tue, Mar 20, 2001 at 11:55:59AM -0500, [EMAIL PROTECTED] wrote:
> Hello
> I am looking for help how to put gziped plain data file to mysql DB
> and then get it from there.
> Every time I try OUTFILE to file and then gzip -d file name I got file corrupted
> Any help will be appreciated
Are you
My question is that,
why is he trying to connect through socket in /var/lib/mysql
cause i have installes in /usr/local
and the path to the mysql.sock is in php3.ini /temp/mysql.sock
any ideas?
regards
denis
On Tuesday 20 March 2001 14:52, you wrote:
> it looks like that:
>
> [MySQL]
> mysql.d
On Tue, Mar 20, 2001 at 10:51:14AM -0500, Nick Taylor wrote:
> Howdy:
>
> New guy to MySql and just installed 3.23 to my redhat 6.2 server.
> Was wondering why I get 3 processes started for mysqld.
Because that's how the Linux kernel implements threads. (This seems to
come up every week.)
Jerem
You dont need a script or command to restore the database, mysqlhotcopy
just creates a copy of your database files (.MYI, etc.) in the
/pathToTheBackupDirectory/. It basicaly performs the same function as the
unix command cp, only it does the necessary locking, etc.
John Barton
Unix Systems Admin
Thank you, very much. Just glad to know nothing wrong.
Nick
- Original Message -
From: "Jeremy D. Zawodny" <[EMAIL PROTECTED]>
To: "Nick Taylor" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 12:20 PM
Subject: Re: why 3 processes?
> On Tue, Mar 20, 2001 at 1
It is more likely /tmp/mysql.sock
tmp has no 'e'.
denis mettler wrote:
>
> Hi,
>
> I did. but the problem is the same.
>
> regards
> denis
>
> On Tuesday 20 March 2001 17:45, you wrote:
> > try:
> > [mysql]
> > mysql.default_socket = /temp/mysql.sock
> >
> >
> > Cal
> > http://www.calevans.c
Did you quote the data before inserting it?
[EMAIL PROTECTED] wrote:
>
> Hello
> I am looking for help how to put gziped plain data file to mysql DB
> and then get it from there.
> Every time I try OUTFILE to file and then gzip -d file name I got file corrupted
> Any help will be appreciated
>
At 11:22 AM 3/20/2001 -0500, Ravi Raman wrote:
>You can use an ENUM column type assuming the numerical range is less than
>65535 numbers.
>
>http://www.mysql.com/doc/E/N/ENUM.html
One problem I've seen with enums is that I end up with a blank ('') field
if I try to insert a row with a value in t
Hi to all:
Somebody knows how to make a read/writa table lock?
I'm trying with java source:
stmt.execute("LOCK TABLES table-x READ, table-x WRITE");
stmt.execute("UNLOCK TABLES");
but it fails.
Best regards,
Fabio Galarraga
[EMAIL PROTECTED]
-
That was a mistake by myself.
it was /tmp/
so, if i make ps
i can see that there are 4 mysqld processes are running
could this be the problem?
And if i use:
ps -aux|grep mysqld
there is only a difference between the process id.
nothing else?
ideas???
Regards
Denis
On Tuesday 20 M
Hello,
We're are a little worried about the ratio of tmp_disk_tables to
tmp_tables. We are assuming the created_tmp_tables from `mysqladmin
extended-status` represents the total number of temporary tables created
and created_tmp_disk_tables from `mysqladmin extended-status` represents
the number
I have found at least three ways to check up/down status of MySQL. I am
wondering what is considered the most reliable method, please comment
and add if you have another method.
1. Check for existence of PID file created by MySQL
2. Check for existence of mysql.sock
3. Verify connection via teln
Yes, I have tried it both ways. I configure Apache a second time after
making php and it still does not work. :(
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
> Subject: Re: [PHP-DEV] RE: 4.0.5RC1 static build with Apache 1.3.19
> problem
>
>
> Did you configure Apache af
Hello all!
Does MySQL have a function that converts an IP address from dotted decimal to binary,
and back
again?
Jason Bell
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
Alex,
I looked at the new debug log you sent and obviously some client is
making connections to your server. This cannot come from
Innobase, there must be some client process running on your machine.
>From the debug log I find the following:
...
T@11 : info: handle_
Hi.
It's kind of counter-intuitive to me as well, but the rationale is that
there obviously was an error if you have a "" value for an ENUM column. this
theoretically allows you at some later time to use that indicator to do some
sort of error-check or update/delete all erroneous rows, or whatev
Steven Glogger wrote:
> LOG FILE =
> 010303 18:30:11 Aborted connection 1727 to db: 'unconnected' user: 'admin'
> host: `localhost' (Got an error reading communication pa
> ckets)
> 010303 18:33:11 Aborted connection 1729 to db: 'unconnected' user: 'admin'
>
On Tue, Mar 20, 2001 at 03:05:53PM -0300, Fabio Galarraga wrote:
> Hi to all:
> Somebody knows how to make a read/writa table lock?
> I'm trying with java source:
>
> stmt.execute("LOCK TABLES table-x READ, table-x WRITE");
>
> stmt.execute("UNLOCK TABLES");
>
> but it fails.
And what is t
Heikki,
I hope Sinisa will be able to find out the problem :)
I noticed that it there were 2 connections to the server. But
I'm sure that I've no process of my own connecting to the server.
And another strange thing is that it's always the same connections:
===
I am running linux 6.2 (2.4 kernel) with MySQL3.23 installed. This kernel
allows MySQL3.23 to support large file sizes, up to 4 Gigs.
It looks like the mysqldump utility is still bound by the 2 GB file size
limit. Does anyone know how to get mysqldump to recognize the
large files.
Yes, but it makes it hard to track down who/what piece of code entered
those bad values. You just have to clean them up later and wonder.
Not the end of the world, but I have some cases where I'd rather fail and
deal with the error at time of input (have them re-enter or whatever).
thanks
-b
1 - 100 of 120 matches
Mail list logo
