got thie error and broken when making mysql 4.1.4-gamma
automake-1.7: not found
WARNING: `automake-1.7' is needed, and you do not seem to have it handy on your
system. You might have modified some files without having the
proper tools for further handling them. Check the
Run
aclocal; autoheader; autoconf; automake
I got many warning and one error:
aclocal general some warning:
configure.in:277: warning: underquoted definition of AC_SYS_COMPILER_FLAG
run info '(automake)Extending aclocal'
or see
Please
Firstly,
I do appologize for my ignorance in advance. I read the message
regarding PRODUCT() and
Don't quote an entire digest to write a new message.
With regards,
Martijn Tonies
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Please
Stored procedures are in the works for MySQL 5.0:
http://dev.mysql.com/doc/mysql/en/TODO_MySQL_5.0.html
The manual is your friend.
Don't quote an entire message/digest to add 3 lines.
With regards,
Martijn Tonies
--
MySQL General Mailing List
For list archives:
HI again,
This multiple mysql proccesses are nothing to worry about - these are the
threads that mysql opens to accept incoming connections. You can configure
the maximum number of connections and the mysql memory usage in the
/etc/my.cnf file.
On Wednesday 01 September 2004 02:14, Yannick
Not difficult :
database db1
database db2
database db3
select db1.table3.column2, db2.table5.column1, db3.table1.column7 FROM
db1.table3, db2.table5, db3.table1;
You can use alias in FROM on table like this :
select alias1.column2, alias2.column1, alias3.column7 FROM db1.table3 AS
alias1,
Warning 2 : it is a mysql example. Whith other DBM, i don't know how to
do that, but i think that its exactly the same thing.
PHP version : mysql_query($query).
Fred.
Tariq Murtaza wrote:
*Hi All,*
Can someone elaborate on How to Select multiples tables of different
database in one query,
On 31 Aug 2004 at 17:33, Todd O'Bryan wrote:
I've tested mysql in my high school lab running from an administrator
and from a student account, both from within the Cygwin terminal, and
at the Windows command prompt. From the administrator account, it runs
fine for hours. From the student
Frank [EMAIL PROTECTED] wrote:
is it somehow possible to log how much CPU time a thread (or query)
consumed? (this is only for debugging purposes)
man mpstat
This may help.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
fix by configure with --without-libedit --without-readline
On Wed, 1 Sep 2004 16:23:36 +0800, Unreal HSHH [EMAIL PROTECTED] wrote:
Run
aclocal; autoheader; autoconf; automake
I got many warning and one error:
aclocal general some warning:
configure.in:277: warning: underquoted definition
Christopher M Bergeron [EMAIL PROTECTED] wrote:
Does anyone know of any guidelines or references that I can refer to
with regard to how long it takes to Optimize tables? I'm running on a
3GHz x86 [single] processor box with SCSI RAID and lots of ram. The
Mysql db files are approx. 35G
Justin Swanhart [EMAIL PROTECTED] wrote:
The problem is that another application has been issuing queries
against the table and those queries have never timed out. So now I
can't kill the connections, because I can't make a database connection
to mysql to even see their thread ids:
[EMAIL
Fredrik Carlsson [EMAIL PROTECTED] wrote:
I have some questions regarding CHECK TABLE, OPTIMIZE TABLE. When i run
these commands on table1 mysql seems to lock up all other databases, is
it possible to run these things in the background so that other
databases can be accessible.
No.
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column where a result of 5 is 5 but -5 is also
5, so in effect all the negative (and only the negative) results are made positive to
find the deviation from zero.
so
5, 4, -3, 4, -1,
abs()
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 01, 2004 12:59 PM
Subject: A question of negative numbers..
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column where
Found answer to my own question:
Returns the absolute value of X:
mysql SELECT ABS(2);
- 2
mysql SELECT ABS(-32);
- 32
This function is safe to use with BIGINT values.
MySQL Reference Manual (C) 2002 MySQL AB
[EMAIL PROTECTED] wrote on 01/09/2004 11:59:58:
is there a function to make negative
numbers positive?
ABS(x)
See http://dev.mysql.com/doc/mysql/en/Mathematical_functions.html
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
MySQL Administrator 1.0.12 and MySQL Query Browser 1.0.7-beta have been
released.
MySQL Administrator is a GUI management console for MySQL, with support
for tasks such as managing users, configuring MySQL, performing backups,
editing table definitions etc.
More information at:
ABS(column) ?
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 01, 2004 6:59 AM
Subject: A question of negative numbers..
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column
I have MySQL for heavy duty job .
here is my InnoDB table space definition
innodb_data_file_path =
/data0/ibdata1:10M;/data0/ibdata2:10M;/data0/ibdata3:1082M;/data0/ibdata4:1500M;/data0/ibdata5:1500M;/
Compile 4.1.4,
gcc -O3 -DDBUG_OFF -pipe -march=pentium4 -fno-omit-frame-pointer -O3
-D_THREAD_SAFE -o myisamchk myisamchk.o -static -D_THREAD_SAFE
-D_THREAD_SAFE libmyisam.a ../mysys/libmysys.a ../dbug/libdbug.a
../strings/libmystrings.a -lz -lkse -lcrypt -lm -lkse
Rhino wrote:
Okay, you've convinced me that you need some Left Joins ;-)
I think you'll have to use a mix of Left Joins and Inner Joins. In
the cases where you need a row even if something doesn't exist, like
a subject who has an address but no phone number, use a Left Join. In
any case
I would use the --tables option of mysqldump. It accepts more than one
table name, so all you need to do is make a list of the tables you want
dumped. If you are combining --tables with other options (like
-B/--databases or -u or -p) make sure the --tables option is the LAST
parameter in the
Greetings-
I have the binary dist of 4.0.20 running on a fairly adequate box
(dualxeon,6gbRAM).
I try to alter a table which has 733k rows and get the following:
mysql ALTER TABLE `CPULoad` CHANGE `TIME` `TIME` VARCHAR( 24 ) NOT NULL;
ERROR 1034: sort_buffer_size is to small
'Huh?' I
Hi:
I'm using MySQL 4.0, and have setup replication with one server and one slave,
both running LM 9.1. My application creates a temporary table on the master,
which is supposed to be deleted when the connection is closed. When that
happens, replication stops with the following message:
[EMAIL PROTECTED] wrote:
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column where a result of 5 is 5
but -5 is also 5, so in effect all the negative (and only the negative)
results are made positive to find the deviation from
I believe some versions of 4.0 have problem with auto dropping
temporary tables in replication. The easy fix is to drop temporary
tables when you are finished with them instead of relying on mysql to
do it for you.
--
Eric Bergen
[EMAIL PROTECTED]
On Wed, 1 Sep 2004 08:16:43 -0600, Alfredo
All,
I am trying to compile MySQL with OpenSSL in an
alternate location ( /data/OpenSSL ).
When I do that either configure will say that no
installation of OpenSSH is there (even with the
--with-openssl-includes= and --with-openssl-libs= ),
or it will compile without OpenSSL support ( show
Mikhail Entaltsev wrote:
You _could_ try adding an identical primary key to the stat_in table as
you have on the 321st_stat table. However, since we need all of the rows
from stat_in in the results, I am not sure that it will help speed up the
join (because it's a left join). Even though I think
Hi,
We have a job that do 'select * from big-table' on a staging mysql database, then dump
to data warehouse, it is scheduled to run once a day, but may be run manually. Also we
have several other small OLTP database on the same server.
When the big job run, it would use all the physical mem
All,
I am trying to compile MySQL with OpenSSL in an
alternate location ( /data/OpenSSL ).
When I do that either configure will say that no
installation of OpenSSH is there (even with the
--with-openssl-includes= and --with-openssl-libs= ),
or it will compile without OpenSSL support ( show
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server). Every
once in a while we wake up to find the too many connections error
coming up. There really aren't too many connections (we have our max
set to 99) -
Is it a too many connections or Host blocked because of many connection
erros? If it is the later you have reached max_connect_errors and need to
issue flush-hosts.
-Original Message-
From: Michael Winston
To: [EMAIL PROTECTED]
Sent: 9/1/04 11:02 AM
Subject: bad too many connections error
Michael Winston wrote:
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server). Every
once in a while we wake up to find the too many connections error
coming up. There really aren't too many connections (we
Hi!
InnoDB is a MySQL table type that provides foreign key constraints, ACID
transactions, row-level locking, consistent (MVCC) non-locking reads,
transaction savepoints, and a commercial InnoDB Hot Backup tool to MySQL.
InnoDB is included in all MySQL releases, except the commercial 'MySQL
I think that there is an error in your code.
I have had this problem with a small application I wrote:
The problem arises when you don't send the quit command to mysql
before dropping tcp.
You must send a quit command in every case (if you opened a socket).
I can not be more precise because i
On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote:
Michael Winston wrote:
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server).
Every once in a while we wake up to find the too many connections
error coming up.
hi...
trying to figure out how to structure an insert/select for a multiple table
situation...
sort of...
insert table1, table2 (table1.item1, table1.item2, table2.item1,...)
select
a.q1, b.q2
from a1
left join a2
on a2.t=a1.t
where a2.r='4';
i can't seem to figure out the syntax for
Hi,
I wanted to setup connectivity between mysql database and oracle database.I have one
database in mysql from which all tables data I want to insert real time data into
oracle database.How to connect mysql database with oracle database?
thanks
While I currently have about a dozen tables, I'd like
to throw this one up for any opinions, suggestion,
warnings, things I may not be saying. It's not a
started entity - schema diagram but should be clear
for the purposes of the email.
Table: Posts (innodb)
What will the connection be used for? Replication? Query between
datasources? There are some third party applications such as Golden Gate
that have replication products. You could also write the connection yourself
in a language such as Java or C.
-Original Message-
From: Seena Blace
To:
Michael Winston said:
On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote:
Michael Winston wrote:
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server).
Every once in a while we wake up to find the too many
Hi,
I've used MySQL 3.23 on Redhat 9 for a long time. Recently, I'm thinking of
using MySQL 4 because some applications need it. I download a rpm from
mysql.com and have it rpm. It can't start and comes up with problem as
-==
terribly wrong...
Bogus stack limit or frame pointer, fp=0xbfffd2b8,
Michael Winston wrote:
On Sep 1, 2004, at 9:10 AM, V. M. Brasseur wrote:
Michael Winston wrote:
Hi-
We've been running into a pretty serious problem for the past several
versions of mysql 4.0 running on OS X (both client and server).
Every once in a while we wake up to find the too many
Not if the host that is blocked is `localhost`.
-Original Message-
From: Michael Winston
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 9/1/04 11:24 AM
Subject: Re: bad too many connections error (os x)
This would make sense since they all the connections are coming from
the same
AFAIK, MySQL servers can only talk to other MySQL servers and that is only
through the replication protocol/connections. Beyond that you will need to
make your server-to-server connections through some kind of external
client. Can Oracle act as a client to foreign databases? If it cannot, I
This would make sense since they all the connections are coming from
the same website. But if this is true, then why can't we connect using
'mysqladmin -uroot'? Shouldn't that work from any host?
Thanks,
Michael
On Sep 1, 2004, at 9:08 AM, Victor Pendleton wrote:
Is it a too many connections
bruce wrote:
hi...
trying to figure out how to structure an insert/select for a multiple table
situation...
sort of...
insert table1, table2 (table1.item1, table1.item2, table2.item1,...)
select
a.q1, b.q2
from a1
left join a2
on a2.t=a1.t
where a2.r='4';
i can't seem to figure out the
I have tried several instals (Windows XP), using binaries from several of
the mirrors, over a 4.1.3b-beta-log version.
No errors reported during any install, but it still reports itself as the
4.1.3b-beta-log version - both in MySQL Administrator (v 1.0.12) and at
the command line opening of
michael...
it was meant as an example, to convey what i want to do, which is do a
simltaneaous insert into multiple tables at the same time. the syntax
concerning the left join/elements to be inserted was not intended to be
syntacticly (sp?) correct!!!
and as i stated, searching through mysql
At 16:14 +0800 9/1/04, Unreal HSHH wrote:
got thie error and broken when making mysql 4.1.4-gamma
automake-1.7: not found
WARNING: `automake-1.7' is needed, and you do not seem to have it
handy on your
system. You might have modified some files without having the
proper tools
At 10:52 -0700 9/1/04, bruce wrote:
michael...
it was meant as an example, to convey what i want to do, which is do a
simltaneaous insert into multiple tables at the same time. the syntax
concerning the left join/elements to be inserted was not intended to be
syntacticly (sp?) correct!!!
and as i
how to take binary/ascii dump of table?
[EMAIL PROTECTED] wrote:AFAIK, MySQL servers can only talk to other MySQL servers and
that is only
through the replication protocol/connections. Beyond that you will need to
make your server-to-server connections through some kind of external
client.
Hello,
I had a problem with our MySQL server-4.0.18 where
it suddenly stoped working.
Even a KILL command didn´t killed the mysqld process.
I looked for any error message in the file
/usr/local/mysql/hostname.err, but I couldn´t see any error
message about such time.
Does anyone knows what
Bruce,
Sorry, I guess I wasn't clear. I understood what you were asking, and I
thought I answered it. Your search of the mysql docs and google found
nothing about multiple-table inserts because you can't do that. I think the
mysql manual page I referenced is clear:
INSERT Syntax
INSERT
My comments intermixed below :-)
Stuart Felenstein [EMAIL PROTECTED] wrote on 09/01/2004 12:30:19 PM:
While I currently have about a dozen tables, I'd like
to throw this one up for any opinions, suggestion,
warnings, things I may not be saying. It's not a
started entity - schema diagram
Have you looked at the manual? The program mysqldump jumps to mind:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Seena Blace [EMAIL PROTECTED]
09/01/2004 02:04 PM
To
[EMAIL PROTECTED]
cc
[EMAIL PROTECTED], Seena Blace
The question:
Is there anything in MySQL that will allow me to determine, accurately, the
last auto-incremented field from a particular database, so I can then insert
based upon this into another table? What if 2 users input at the same time?
Please see the 'long explanation' for further
Hi folks, heres a real stupid question, but Im baffled. I am running MySQL v
. 4.1.3b-beta-nt , JVM 1.4.2_05-b04 by SUN,
Tomcat 5.0.27,Windows 2000 Server
Im attempting to run SERVLETS for my application.
I have a HTML form to kick off my application in Tomcat App
Since you should still have the same information that you used to create
your entry in the candidate table you can do something like:
SELECT @candidateID := Candidate_ID
FROM candidate
WHERE Last_Name = '$lastname'
AND First_Name = '$firstname'
AND Middle_Initial = '$middle'
Yes, LAST_INSERt_ID(). It's connection-specific, not db-specific. Because
it is connection-specific, your 2-users issue is avoided. See the manual
for the details http://dev.mysql.com/doc/mysql/en/Getting_unique_ID.html.
Michael
Eve Atley wrote:
The question:
Is there anything in MySQL that
Ave,
Is there a way to directly import DBF data into MySQL table or do I HAVE to
convert it into CSV (Using EXCEL) or some other method?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This also may caused by the TTL of the http socket and the launched
zombie forks by the http/php server ( the FIN_WAIT_2 problem!!). Thats
what it happend to me . I dunno who waited for who, and became zombie,
was it MySQL waiting for timeout or was socket wating to timeout.
You can test this
At 10:40 AM 9/1/2004, you wrote:
Hi,
We have a job that do 'select * from big-table' on a staging mysql
database, then dump to data warehouse, it is scheduled to run once a day,
but may be run manually. Also we have several other small OLTP database on
the same server.
When the big job run, it
Thanks Mike.
Seems like even with handler, the big query process is still consuming all my RAM and
swap and being killed with error
'VM: killing process mysql
__alloc_pages: 0-order allocation failed (gfp=0x1d2/0)'
I would like to find a startup parameter either for client or server to limit
Hi,
I've set up a master-slave MySQL configuration. When I do: LOAD DATA
FROM MASTER on the slave I get the following error: ERROR 1189: Net
error reading from master . Errorlog displays: create_table_from_dump:
failed in handler::net_read_dump() The master logs displays nothing. A
few
Hi Folks,
We are trying to put a monitoring solution in place at a client and have
come up against something during testing. If the replication user
disappears off the master and the slave cannot log in, the
Slave_IO_Thread still shows running and no error in the last error
number field. Does
I have a column that holds hard disk file location info such as:
/Volumes/External HD/aFolder/aFile.pdf
/Volumes/External HD/aFolder/anotherFile.pdf
etc. . . (many files located in the same folder)
Can anyone suggest a single statement (or multiple) that would update every
file location located
David,
I haven't ever attempted to delete the slave user on the master, and since I
only run replication on 4.1 boxes and not 4.0 boxes, I won't be able to help
much. But I would probably submit it to http://bugs.mysql.com and they can
verify that it is a bug. But they will probably not
Back in 3.23.x we used to see MySQL hang on a corrupt table (typically
caused by an improper shutdown). A kill -9 was needed to stop the
process, upon restart we'd run a mysqlcheck (MyISAM tables) and repair
the table. We didn't see anything obvious in the logs except the last
query, which was
You can use the replace string function:
update table set
file_path=replace(file_path,'aFolder','aFolder/aChildFolder');
In each update aFolder will be replaced by the new path.
John Mistler wrote:
I have a column that holds hard disk file location info such as:
/Volumes/External
Hi All,
I would like to know some information about the MySql architecture.
All the other databases have some info about their architecture in the
documentation.
But I havent found any documentation on the mysql architecture.
Please refer me some websites or download liks where I can get some
Wow! That works. Thanks a bunch! While we're at it, I have one more
hang-up:
Is there a (DISTINCT?) statement that will select the distinct folder
path(s) of every entry in the table?
For instance, if I have three files:
/Volumes/External HD/aFolder/aFile.pdf
/Volumes/External
Hi all,
I'm designing a hosted application that many clients will access. I've
got all sites running off one PHP code base quite nicely, and now I'm
hoping to reduce the multiple databases down to just one shared DB.
(Note: at this stage, all accounts are fictional, so there's no legacy
data
Hi all,
I would like to know the mysql command to do the following:
Create a user (who will access mysql database), with privilaeges so
that, he can only retrieve the information in the data base (values in
the tables), he should not be able to alter, update, delete any table
values.
Kindly
Hi Rajashik,
This is documented very well in the manual at
http://dev.mysql.com/doc/mysql/en/GRANT.html#IDX1697 You would want the
GRANT statement and only allow them SELECT privileges on the tables you
wish them to view.
eg. GRANT SELECT on test.* to user@somehost.% IDENTIFIED BY
password;
Dear Friends,
I am trying to compile PHP with MySQL support in an HP DL380
server (Xeon Processors). The MySQL is build with Intel Compiler.
I am getting the following problem / error :
---
/usr/local/mysql/lib/libmysqlclient.a(libmysql.o)(.text+0x1ade): In
function
77 matches
Mail list logo