Dear all,
I've an error with message :
ERROR 1135: Can't create a new thread (errno 12). if you are not out of
available memory,
you can consult the manual for a possible OS-dependent bug.
This error occured when trying to connect to MySQL Server.
Connection using TCP/IP.
here my.cnf :
This
At 01:29 14/01/2003 -0500, C. Reeve wrote:
Hi,
I just uninstalled and reinstalled and got it to work on port 3306, but I
can't get it to work on any other port. As I said, I have changed this in
my.ini. Is there something else I should be doing to get this to work on a
non-standard port.?
Hi,
If you use NULL on the USER parameter that means you wish to login with the
current user which is already logged under Linux.I suppose that you don't
have any user set to connect at MySQL server.
I think it's better to try with root instead of NULL.
Regards,
Gelu
Hello,
has anyone managed to compile MySQL 4 with MyLUA?
--
Christian Kohlschütter
[EMAIL PROTECTED]
http://www.newsclub.de - Der Meta-Nachrichten-Dienst
-
Before posting, please check:
http://www.mysql.com/manual.php
I have a mySQL database that is about 240 megabytes. I am loading it on
a Linux server with 2 gigs of RAM. I would like to have the whole table
reside in memory to save time from disk access. Is there any way to load
the tables into RAM on startup? I am thinking about creating a heap
table,
I notice that sometimes when I establish a connection with myODBC with
Microsoft Access, and send it occasional sql statements it works fine at
first. But if you let it sit for, say, 30 minutes and comes back, the
Access table locks up. I am not sure if this is a problem with myODBC
(which I
Hi.
On Tue 2003-01-14 at 06:02:10 +, [EMAIL PROTECTED] wrote:
SELECT id,first,last FROM names ORDER BY id LIMIT 2,1;
Work? Limits to one result, start at second offset. (I may have the 2,1 in
the wrong order though)
Ok my gut would say that this would not give the result I want
You may try using a Ramdisk as storage for mysql data folder.
Regards,
Shamit
http://www.vshamit.com
- Original Message -
From: Steve Quezadas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 14, 2003 2:53 PM
Subject: Loading a database into RAM
I have a mySQL database
Hi
We want to create a knowledge base using PHP-MYSQL and if required other
tools like specialized search engine. The knowledge base may consists
for normal text content, HTML content, PDF files, DOC files etc. The
preferred OS is RH Linux 7.3.
My queries are:
1. Should we store these files as
Hi,
if your system suddenly crashs all changes to the database are lost.
be aware of this !
regards,
philipp
p
- Original Message -
From: Shamit Verma [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 14, 2003 11:01 AM
Subject: Re: Loading a database into RAM
You may
InnoDB appears to be losing records.
The version I am using is 3.32.53 in Windows 2000.
Gaps are appearing in the autoincrement sequence when
the application does not permit record deletions.
Records disappear although they have been retrieved
for printing earlier.
Does anyone know how this
Hi
We got a problem with a slow database after deleting records using the
MySQL released with RedHat 7.2 (Server version 3.23.41). Here is the short
story:
We have a table with a lot of data, at the moment there are 85 million
records in our table. We developed a script that deleted old
Steve Quezadas [EMAIL PROTECTED] writes:
I have a mySQL database that is about 240 megabytes. I am loading it
on a Linux server with 2 gigs of RAM. I would like to have the whole
table reside in memory to save time from disk access. Is there any way
to load the tables into RAM on startup? I
Hi.
I see InnoDB uses Asynchronous IO on Windows NT but not on Linux. There
are patches, made by SGI, which enables asynchronous IO on Linux 2.4
(http://oss.sgi.com/projects/kaio/).
Are there any plans to support native asynchronous IO in InnoDB?
Quoted from the project site:
Preliminary
Hi
I have a table holding a set of messages along with child tables holding
more details for the same. Normal RDBMS scenario.
The typical requirement is to see a set/page (say 10 per page) of such
messages along with the details page by page and also the total rows
available applying the
From my experience: don't do anything.
Linux filesystem cache is really efficient and as soon as all your database
will be in the cache, you wont get any disk read anymore; only writes when
you INSERT/UPDATE data.
Our main database server has 2Gb RAM and the total size of all databases
is around
This is what MYSQL manual 3.23.41 says, may be it helps you
OPTIMIZE TABLE should be used if you have deleted a large part of a
table or if you have made many changes to a table with variable-length
rows (tables that have VARCHAR, BLOB, or TEXT columns). Deleted records
are maintained in a linked
What is the best way to get the total count as well as the paged
content. Do I need to fire two queries or is there a trick which can do
this in a single query?
I'm doing this on tables with many millions of records. I take a hit once
to get a total record count then cache that value in the
Thx Adam
But what if concurrent inserts are happening to the table while the
users page-view thru the data. The count may change.
vikash
-Original Message-
From: Adam Erickson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 4:48 PM
To: Vikash K Agarwal; [EMAIL PROTECTED]
Thank you for your reply, Vikash
We have decided not to use optimize because of the size of the table.
Optimize would halt the system to long. So we decided just to reuse the
space. Our problem is that after the deletion a select query that used to
take a second now takes 30 minutes and locks up
I'm trying to use 4.0.9 ( from source ) but if i compile with docs the
mysql print this error on make:
cd . \
/bin/sh /temp/mysqlcom-4.0.9-gamma/missing --run makeinfo -I . --no-headers --no-split
--output manual.txt manual.texi
manual.texi:29334: @include `reservedwords.texi': No such file
Am Dienstag, 14. Januar 2003 10:14 schrieb Christian Kohlschütter:
Hello,
has anyone managed to compile MySQL 4 with MyLUA?
I just want to note that I managed it myself.
It compiles nicely, after resolving a little naming problem (lua class name
vs. attribute name), and works fine.
--
Gunnar
Something you can try:
1. Export all data (mysqldump, SELECT INTO OUTFILE), import it in a new
table (mysqlimport, LOAD DATA INFILE), create indexes on the new table,
drop the old table. This would remove the holes from data and indexes
wud be fresh again. This wud also not hold up
Hello,
Because I switched some large tables back to myisam from innodb (sorry
Heikki) my innodb datafile has a few gig 'empty'. I would like to reclaim
that space.
Can I expect a problem if I:
- make _all_ innodb tables myisam (And be very sure I changed them all),
- shutdown the dbase,
-
Hi
Can some one guide me on how to use the embedded MySQL
server.
I have gone through brief description in the MySQL
manual but did not get much from it
When we use Embedded server in an application ,do we
need complete MySQL installation ???
any pointer will be appraciated
thanks
asif
Hi,
I am replicating a table between 2 servers.
The table on the master executes many transactions that should be
replicated to the table on the slave..
The table on the slave is only readable...
I have noticed that the changes on the master are not replicated at once
but it takes about 2 hours to
Thanks but actually I'm looking for a way to return all the relations
upwards and downwards of a term. no matter the position (so I need general
query to do that. Any ideas?
Thanks in advance. Leo.
- Original Message -
From: Anthony Richardson
To: Leonardo Javier BelÈn [EMAIL
Check that mysql has write privileges at the operating system level.
Loren McDonald wrote:
Just tried. Nope...
mysql grant all privileges on mysql.* to ext identified by 'ext1tex2'
with grant option;
ERROR 1036: Table 'user' is read only
One solution could be something like
SELECT id, first, last
FROM names
WHERE last '$previouslast' AND first 'previousfirst'
ORDER BY last, first
LIMIT 1
That is: Take all results that come after the previous name, sort
them and then take only the first.
The problem with
Hello,
I'm working with mySQL 3.23.32 under Solaris. I have
a database with two tables 'bron' and 'topic'. Those
tables are related via 'naam_bron'. Lets say that
table 'bron' contains 100 records where column
'media' = 'Book' and table 'topic' contains 30
records where column 'topic_code' =
Hi Leo,
how about this:
select * from planttable where id like 01% or id like %02
CH
Leonardo Javier Belén wrote:
Thanks but actually I'm looking for a way to return all the relations
upwards and downwards of a term. no matter the position (so I need general
query to do that. Any ideas?
Thats good but what about a way query up and down only modifying a var,
something like and hierichal search?.
Leo.
- Original Message -
From: CH Tsang [EMAIL PROTECTED]
To: Leonardo Javier Belén [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, January 14, 2003 11:30 AM
Subject: Re:
Nope, same thing - and XP's firewall is not enabled, so this is not an
issue. Also, it works on port 3306 fine. When I run a netstat it says it is
listening on port 3308 and I get 'mysqld: ready for connections', however,
that port is not active. When I scan my PC this port is not open. I can't
I run into the same problem. in general, once slave started, it can not be
stopped, via
mysqlslave stop or net stop mysql (stop Windows Service)
Anybody has solution to this problem?
Thanks,
VK
- Original Message -
From: Massimo Petrini [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
On 14 Jan 2003, at 15:28, Peter van der Kamp wrote:
What should be the result when I issue the following
query:
select naam_bron from bron, topic where
(bron.media=Book)
or (topic.naam_bron = bron.naam_bron and
topic.topic_code = 5.1);
Before posting my results I'll wait for your
On Monday 13 January 2003 14:21, Adrian Bucur wrote:
I removed an old mysql version and I installed a new one on a machine
running Suse 8.1 Linux.
shellrpm -i MySQL-client-3.23.54a-1.i386.rpm
shellrpm -i MySQL-shared-3.23.54a-1.i386.rpm
shellrpm -i MySQL-devel-3.23.54a-1.i386.rpm
shellrpm
On Tuesday 14 January 2003 09:26, mahdi samia wrote:
I have writed a program and compiled it by g++.
I used from API function for connecting to MySQLServer :
mysql_real_connect(db,192.168.2.245,NULL,NULL,vlrdb,3306,/tmp/mysql.so
ck,CLIENT_ODBC)
but when running it I receive following
On Tuesday 14 January 2003 01:45, Loren McDonald wrote:
Just tried. Nope...
mysql grant all privileges on mysql.* to ext identified by 'ext1tex2'
with grant option;
ERROR 1036: Table 'user' is read only
Check permissions on the privilege table files, like host.frm, user.frm etc in
the
On Monday 13 January 2003 23:38, Gabe Geisendorfer wrote:
Hello, I'm in the process of moving from Postgres to MySQL and I have a
question.
+How do you prevent a field from being left empty?
I have an InnoDB table that looks like the following.
CREATE TABLE `stuff` (
`stuff_id`
* Leonardo Javier Belén
Thanks but actually I'm looking for a way to return all the relations
upwards and downwards of a term. no matter the position (so I need general
query to do that. Any ideas?
0100 - Rose tree
0101 - pink rose tree
0102 - red rose tree
0103 - rococo rose tree
0200 -
I thought about answering your original post except that I couldn't figure
out what you want. And after reading this, I'm even more confused. What
does it mean for id's to be sorted by last name?
Ok let me see if I can state thre problem better (though I think that I am begining to
Hello All,
I've read many different methods to expand the number of file descriptors that mysql
(and apache)
can use. However I've not been able to find the perfect method, many guides seem to be
out of
date, etc.
I am wondering, does anyone have any advice on their own preferred methods of
Hi!
InnoDB is a MySQL table type that supports transactions, foreign key
constraints, and a non-free hot backup tool.
MySQL AB decided to release 4.0.9 so quickly after 4.0.8 to fix a bug in
remote connections in 4.0.8.
For InnoDB, 4.0.9 is a bugfix release. I have also removed the .err log
# - 3rd post - #
# - PLEASE HELP -- #
hi to all,
is it still true that mysql/innodb needs explicit
index creation on foreign keys?
why can't i use a standard syntax for foreign keys
creations?
i have a database schema (ddl) with over 50 tables and
i was trying
Hi all,
I've asked on another list which database they recommend among MySQL and MS
SQL, and ... possibly PostgreSQL.
Most of that list members answered me that they recommend MS SQL because it
has much more features.
Can you tell me which are the most important differences between MS SQL and
Can I index just a smaller number of characters from a field even though the
field has more?
Will this make MySQL to index that field faster?
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: David T-G
No, you should contact your ISP and ask them to create you a MySQL account.
Probably you don't have one.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: christina [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 13, 2003 6:53
I won't say you need to go back to high school, but maybe you need to
review how SQL works. You have no criterion for joining your two
At least my knowledge of SQL needs an update.
Although there are criteria for joining the two
tables I realize that the way I specified them is
wrong.
Description:
When try to use enum ('a','b','unsigned') MySQL understands it as enum ('a','b','')
unsigned.
How-To-Repeat:
Something like:
alter table test change en en enum ('a','unsigned');
Fix:
Submitter-Id: submitter ID
Originator:Michal Cihar
Organization:
MySQL support: none
Synopsis:
Natale,
please address these general questions to [EMAIL PROTECTED]
InnoDB requires that the indexes are created explicitly. It would require a
change to MySQL to automate the creation of them.
Without indexes foreign key checks would be very slow because then every
check would have to do a
Hello, I'm in the process of moving from Postgres to MySQL and I have a
question.
+How do you prevent a field from being left empty?
I have an InnoDB table that looks like the following.
CREATE TABLE `stuff` (
`stuff_id` int(11) NOT NULL auto_increment,
`somevalue1` varchar(35) NOT NULL,
It seems you want something like
select * from table
limit 1,1
for the first query and then...
select * from table
limit 2,1
You might also want to add order by as well to assure the proper order
each query.
HTH,
Ron
[EMAIL PROTECTED] wrote:
Now Ben did
On Tue, 14 Jan 2003 16:41:06 +0100 (CET)
Natale Babbo [EMAIL PROTECTED] wrote:
# - 3rd post - #
# - PLEASE HELP -- #
hi to all,
is it still true that mysql/innodb needs explicit
index creation on foreign keys?
Yes
why can't i use a standard syntax
At 16:00 +0530 1/14/03, Vikash K Agarwal wrote:
Hi
We want to create a knowledge base using PHP-MYSQL and if required other
tools like specialized search engine. The knowledge base may consists
for normal text content, HTML content, PDF files, DOC files etc. The
preferred OS is RH Linux 7.3.
My
Hi,
I'm running Freebsd 4.6.2 with mysql server v3.23.49
I have a little question about using Mysql on Freebsd and having a database
on a NT 4 linked drive, using Samba (the drive was mounted on my FreeBSD
system with Sharity-light because smbmount doesn't work on Freebsd) .
I can query my
At 09:49 14/01/2003 -0500, C. Reeve wrote:
Hi,
Something wrong happens with your system:
Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-1999 Microsoft Corp.
c:\mysql\binmysqld --standalone --console --port=3308
mysqld: ready for connections
in another windows:
Microsoft Windows
Use table type =Innodb for foreing keys and transacionts...etc
and type =myisam for speed
Simon
-Original Message-
From: Octavian Rasnita [mailto:[EMAIL PROTECTED]]
Sent: 14 January 2003 10:20
To: MySQL
Subject: Foreign keys
HI all,
I've read the following text in a book:
ANSI SQL
Thx for the correction Paul.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 10:17 PM
To: Vikash K Agarwal; [EMAIL PROTECTED]
Subject: Re: doc storage as BLOB and its search engine on MYSQL
At 16:00 +0530 1/14/03, Vikash K Agarwal wrote:
many thanks for your reply.
then i ask me: why mysql needs explicit creation
instead of create itself what it needs?
manually creating the index seems to be a big
complication (for big databases) and a waste of time.
don't you think so?
it's a bug or a wanted feature? why?
Thanks.
--- Okan
Are there plans in future versions to have MySQL fail the below INSERT
statement?
It would be useful to at least receive a warning.
In my situation, I only intend on leaving fields blank by omitting them
if:
1. I have set a DEFAULT on the column.
2. Or the column accepts NULL's.
On Tue, Jan 14, 2003 at 10:10:02AM +0200, Octavian Rasnita wrote:
Can I index just a smaller number of characters from a field even though the
field has more?
Will this make MySQL to index that field faster?
Good Day Octavian,
You can index part of a column with the syntax
INDEX
I'm aware that NULL and are not the same thing.. I would like to
prevent the column from accepting values automatically ( with out the
presence of a DEFAULT).
-Original Message-
From: Csongor Fagyal [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 8:21 AM
To: [EMAIL PROTECTED]
HI all,
I've read the following text in a book:
ANSI SQL supports a special kind of key called a foreign key. Foreign keys
help protect database integrity by enabling the database to manage things
such as the deletion of rows with dependent relationships in other tables.
Though MySQL supports
On Tue, Jan 14, 2003 at 12:20:06PM +0200, Octavian Rasnita wrote:
I've read the following text in a book:
ANSI SQL supports a special kind of key called a foreign key. Foreign keys
help protect database integrity by enabling the database to manage things
such as the deletion of rows with
Vaso Koutsonikola wrote:
Hi,
I am replicating a table between 2 servers.
The table on the master executes many transactions that should be
replicated to the table on the slave..
The table on the slave is only readable...
I have noticed that the changes on the master are not replicated at
I'm having trouble on one of my SQL servers. It is the slave in a
master/slave setup. select now() returns the wrong time (+5 hours).
The systems time is in EST and show variables shows timezone=EST.
Eg.
mysql select now();
+-+
| now() |
mysql, query
Hi, all,
I have a development table which is created using the following commands on
3.23.53-log mysql server on MAC 10
CREATE TABLE web_transaction_item(
trans_item_id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
trans_id INT UNSIGNED,
prod_id INT UNSIGNED,
Use table type =Innodb for foreing keys and transacionts...etc
and type =myisam for speed
Yes, but do the foreign keys in InnoDB honor the constraints? I
think that was the original question. What's the poing of using
foreign keys if it's not going to maintain the integrity of your data.
That
Does MySQL allow using foreign keys or not?
It does. Try it by yourself with version 4.0.8 +.
Adolfo
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Dear all,
can anyone point me to a reference regarding the Com_ status information
you get with SHOW STATUS LIKE 'Com_%'? I searched the MySQL website and
Google groups, but nothing.
TIA,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6,
I agree with you. If there is no index already on the referenced fields
then add one. By adding a foreign key you are already altering the
table why not just finish the job.
-Original Message-
From: Natale Babbo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 8:58 AM
To:
At 12:01 -0500 1/14/03, Michael Knauf/Niles wrote:
Ok, this has got to be easy, but I'm not getting it right...
I have a table, products containing a 944 rows. One of the fields is
fgNumber,
I have another table, categoryRelatedToProducts which also has an fgNumber
field and currently has no
I have an InnoDB table that looks like the following.
CREATE TABLE `stuff` (
`stuff_id` int(11) NOT NULL auto_increment,
`somevalue1` varchar(35) NOT NULL,
`somevalue2` varchar(35) NOT NULL,
PRIMARY KEY (`stuff_id`)
) TYPE=InnoDB COMMENT='stuff table';
I run the following
Use INSERT...SELECT syntax:
http://www.mysql.com/doc/en/INSERT_SELECT.html
-steve
At 12:01 PM -0500 1/14/03, Michael Knauf/Niles wrote:
Ok, this has got to be easy, but I'm not getting it right...
I have a table, products containing a 944 rows. One of the fields is
fgNumber,
I have
then i ask me: why mysql needs explicit creation
instead of create itself what it needs?
manually creating the index seems to be a big
complication (for big databases) and a waste of time.
don't you think so?
it's a bug or a wanted feature? why?
I agree with you 100%.
A foreign key,as its
-Original Message-
From: Steve Quezadas [mailto:[EMAIL PROTECTED]]
I notice that sometimes when I establish a connection with
myODBC with
Microsoft Access, and send it occasional sql statements it
works fine at
first. But if you let it sit for, say, 30 minutes and comes back,
At 10:10 +0200 1/14/03, Octavian Rasnita wrote:
Can I index just a smaller number of characters from a field even though the
field has more?
Will this make MySQL to index that field faster?
For BLOB and TEXT columns, you *must* in fact index just a certain number
of bytes (maximum of 255
On Tue, Jan 14, 2003 at 11:41:16AM +0200, Octavian Rasnita wrote:
Hi all,
I've asked on another list which database they recommend among MySQL
and MS SQL, and ... possibly PostgreSQL. Most of that list members
answered me that they recommend MS SQL because it has much more
features.
On Tue, Jan 14, 2003 at 05:49:24PM +0100, Nicolas wrote:
Hi,
I'm running Freebsd 4.6.2 with mysql server v3.23.49
I have a little question about using Mysql on Freebsd and having a
database on a NT 4 linked drive, using Samba (the drive was mounted
on my FreeBSD system with Sharity-light
On Mon, Jan 13, 2003 at 02:46:45PM +0800, Ivan Hoo wrote:
hi All,
has anyone been able to setup ssl secure replication for mysql?
I don't believe you can do that yet. There's now way to specify the
necessary credentials in the slave setup.
how do i know whether the replication is actually
I'm new to administering MySQL, so bear with me:
We run a large MySQL database with one of the tables amassing
over 40 million entries. It somehow got corrupt and now I'm
running isamchk -o (-r failed) and it's in its 110th hour and
it's getting slower. I'm running 3.23.38 and cannot upgrade
On Mon, Jan 13, 2003 at 03:34:29PM -, Andy Eastham wrote:
I've got a mysql application that was developed on win32 and linux that is
now going to be deployed on a Sun E250 Solaris 9 box with 3 36Gb non raided
SCSI disks. No problem I thought - the performance is fine on my PIII
850MHz
Ok, this has got to be easy, but I'm not getting it right...
I have a table, products containing a 944 rows. One of the fields is
fgNumber,
I have another table, categoryRelatedToProducts which also has an fgNumber
field and currently has no data.
I'd like to add all 944 fgNumbers to the
Hi,
You can use INSERT...SELECT.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Michael Knauf/Niles [EMAIL
On Tue, Jan 14, 2003 at 12:42:18AM +0200, Jani Tolonen wrote:
...
* Added join operator `FORCE INDEX (key_list)'. This acts likes `USE
INDEX (key_list)' but with the addition that a table scan is
assumed to be VERY expensive. One bad thing with this is that it
makes `FORCE'
Hi,
There might be a bug in mysql 4 (tested on 4.0.8-gamma and 4.0.9-gamma) when
combining simple arithmetic operations and date conversion
I have a table with the following structure
date_col date -00-00
int_col tinyint(3) unsigned
This is what happens when I try to run a query like the one
Greetings
Seemingly MySQL has a persistant problem that I could not solve whatever I
tried to do. It seems that it is impossible to send large amount of binary
data to mysql's BLOB field. It is written in manual that 4.0x versions do
not have limit for max_allowed_packet. It is also written that
Michael,
I have a table, products containing a 944 rows. One of the fields is
fgNumber,
I have another table, categoryRelatedToProducts which also has an
fgNumber
field and currently has no data.
I'd like to add all 944 fgNumbers to the categoryRelatedToProducts
table.
INSERT INTO
can anyone point me to a reference regarding the Com_ status information
What exaclty do you mean? http://www.mysql.com/doc/en/SHOW_STATUS.html
states that the com_ is just how many times the command has been
issued. So if com_select = 34021 there have been 34021 selects issued to
the
In addition to the previous I just want to say that the problem is most
likely with the unsigned columns - I altered the integer column to remove
the 'unsigned' property and now it is working properly
Regards
Dobromir Velev
[EMAIL PROTECTED]
- Original Message -
From: Dobromir Velev
At 19:11 +0100 1/14/03, Stefan Hinz wrote:
Dear all,
can anyone point me to a reference regarding the Com_ status information
you get with SHOW STATUS LIKE 'Com_%'? I searched the MySQL website and
Google groups, but nothing.
They're counters for the number of times various types of statements
Dear all,
can someone explain this phenomenon (I connect to mysqld-max-nt in
another DOS box, then close the window without issuing 'quit'; MySQL
4.0.7 with InnoDB tables on Win2K SP2):
mysql SHOW STATUS LIKE 'Aborted%';
+--+---+
| Variable_name| Value |
In the last episode (Jan 14), Stefan Hinz said:
can anyone point me to a reference regarding the Com_ status
information you get with SHOW STATUS LIKE 'Com_%'? I searched the
MySQL website and Google groups, but nothing.
http://www.mysql.com/doc/en/SHOW_STATUS.html
`Com_xxx'
Hi,
I just installed MySQL and PHP on Windows XP and have a question. I created
a test database on Windows (exactly the same as the test one I use in Linux)
and copied a test PHP script which accesses Mysql and displays some
information. On Linux it works perfectly, but on Windows I get the
Hi,
In fact ...you can choice the RDBMS depend on what you wish to do.
If you are able to design the database for using without store
procedures,viewers,triggers...you can choose MySQL. It's stable enough and
the better part is that have very good performance.
Regards,
Gelu
On Tue 2003-01-14 at 09:22:40 -0500, [EMAIL PROTECTED] wrote:
One solution could be something like
SELECT id, first, last
FROM names
WHERE last '$previouslast' AND first 'previousfirst'
ORDER BY last, first
LIMIT 1
[...]
I don't think it would loop forever, since you
Dobrý den,
terça-feira, 14 de janeiro de 2003, 16:58:08, napsal jste:
RC I'm new to administering MySQL, so bear with me:
RC We run a large MySQL database with one of the tables amassing
RC over 40 million entries. It somehow got corrupt and now I'm
RC running isamchk -o (-r failed) and it's
Does anyone know when MySQL 4.0.9 for Windows (bins) will be available
for download?
Thanks,
Gabe
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hello,
I want to know whether the mysql depot (mysql-3.23.54a) works on
HP-UX PA_RISC2.0 or it works only on PA_RISC1.0.
If it doesn't work on PA_RISC2.0, where can I find a mysql depot
that works on PA_RISC2.0?
Hello,
One of our developers recommends that you use the
Thanks, I'll try that!
Robert
On Tue, 2003-01-14 at 14:54, Dyego Souza do Carmo wrote:
Dobrý den,
terça-feira, 14 de janeiro de 2003, 16:58:08, napsal jste:
RC I'm new to administering MySQL, so bear with me:
RC We run a large MySQL database with one of the tables amassing
RC over 40
1 - 100 of 154 matches
Mail list logo
