RE: Question about MySQL

ing-primer Regards, Gavin Towey -Original Message- From: Banyan He [mailto:ban...@rootong.com] Sent: Friday, August 07, 2009 11:12 AM To: Gavin Towey; joerg.bru...@sun.com; Peter Chacko Cc: mysql Subject: Re: Question about MySQL Hi Gavin, I am interested in the things you made for the optimiz

Re: Question about MySQL

Hi all! First of all, please excuse the typo I made in my posting. I had written >> There may be some merit to this in a specialized setup (NAS systems - >> I'm not convinced of them, but don't claim expert knowledge about them), and of course meant SAN, not NAS systems. As regards NFS: Peter

Re: Question about MySQL

umptions! > > Regards, > Gavin Towey > > -Original Message- > From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] > Sent: Friday, August 07, 2009 1:19 AM > To: Peter Chacko > Cc: mysql > Subject: Re: Question about MySQL > > Hi Peter, all, &

Re: Question about MySQL

http://www.rootong.com > From: Gavin Towey > Date: Fri, 7 Aug 2009 11:07:19 -0700 > To: "joerg.bru...@sun.com" , Peter Chacko > > Cc: mysql > Subject: RE: Question about MySQL > > I always accepted that NFS was unacceptably slow for database access, until I >

RE: Question about MySQL

using GigE over few hops, then it's really not slower than local disks. Remember: benchmark and test your assumptions! Regards, Gavin Towey -Original Message- From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] Sent: Friday, August 07, 2009 1:19 AM To: Peter Chacko Cc: mysql Subjec

Re: Question about MySQL

Hi Jorg, I really appreciate your help sharing your experience/thoughts. Yes, i fully concur with you, NFS is not designed for Databases. But you know there are Distributed SAN file systems (that use Direct IO to the SAN) are serving databases like DB2 in many installations for shared storage.

Re: Question about MySQL

Hi Peter, all, let me just concentrate on the NFS aspect: Peter Chacko wrote: > [[...]] > > Another question is , whats the general experience of running MySQL > servers on NFS shares ? I would *never* use NFS storage for any DBMS (except for some testing): NFS access is slower than local di

Re: Question about mysql procedures

On Fri, 11 Apr 2008 14:52:30 -0700 "Rob Wultsch" <[EMAIL PROTECTED]> wrote: > On Fri, Apr 11, 2008 at 2:15 PM, Joshua D. Drake > <[EMAIL PROTECTED]> wrote: > > Hello, > > > > Can MySQL functions/stored procedures access database data? > > > > Joshua D. Drake > > Yes. Is there something in parti

Re: Question about mysql procedures

At 2:15 PM -0700 4/11/08, Joshua D. Drake wrote: Hello, Can MySQL functions/stored procedures access database data? Yes, with some limitations. You will want to read this section to see whether what you want to do is restricted: http://dev.mysql.com/doc/refman/5.0/en/routine-restrictions.htm

Re: Question about mysql procedures

On Fri, Apr 11, 2008 at 2:15 PM, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > Hello, > > Can MySQL functions/stored procedures access database data? > > Joshua D. Drake Yes. Is there something in particular you are looking to do? -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL Gener

Re: question about mysql start up again

On Wed, 15 Sep 2004, [GB2312] ÀîÈñ wrote: > Hi > > > I have installed some software on aix5.2 . > the list of software: > apache-1.3.29-1.aix4.3.ppc.rpm > php-4.0.6-5.aix4.3.ppc.rpm > MySQL-3.23.47-3.aix4.3.ppc.rpm > MySQL-client-3.23.47-3.aix4.3.ppc.rpm > > All of them was installed by using the

Re: Question about [mysql ] processes

> Subject: Re: Question about [mysql ] processes > Ken Sorensen <[EMAIL PROTECTED]> wrote: > > > I am stumped. I have a very busy MySQL db that we've run for > > about 3 years with no problems. A couple of months ago we upgraded > > the system to RH-3AS wit

Re: Question about [mysql ] processes

Ken Sorensen <[EMAIL PROTECTED]> wrote: > I am stumped. I have a very busy MySQL db that we've run for > about 3 years with no problems. A couple of months ago we upgraded > the system to RH-3AS with RedHat's distro mysql-server 3.23.58-1.9. > Recently I've started getting zombie processes ([mys

Re: Question about MySQL 4.0.20 and make test failure on Linux

Tom Williams wrote: Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to). The compile runs smoothly, but make test fails. Here is my configure command: $ ./configure --prefix=/usr/local/mysql-4.0.20 --enable-

Re: Question about MySQL 4.0.20 and make test failure on Linux

Michael Stassen wrote: I always run `make test` when I build from source. It can catch problems. For example, mysql 4.0.17 built with gcc in Mac OS X 10.2 passed all tests and ran flawlessly for me. On the other hand, mysql 4.0.18 and 4.1.1 built on Mac OS X 10.3 seemed to build fine but fai

Re: Question about MySQL 4.0.20 and make test failure on Linux

Jeff Smelser wrote: On Friday 18 June 2004 11:48 pm, Tom Williams wrote: Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to). The compile runs smoothly, but make test fails. Here is my configure command: Whoa.. 2.

Re: Question about MySQL 4.0.20 and make test failure on Linux

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:48 pm, Tom Williams wrote: > Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux > system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to). > The compile runs smoothly, but make test fails. Here i

Re: Question about Mysql C API v 3.22 and 3.23

At 8:51 -0600 1/12/04, Joe Johnson wrote: Hello, I am attempting a change in my use of mysql C API to use 3.23.54 instead of 3.21 and I am finding that the mysql_real_connect function is failing to run (it crashes the program). My mysqld version is also 3.22.27. Anyone know whether this is a bug i

Re: Question about MySQL and Oracle.

It depends a lot on the features that are needed. Right now we use mySQL for some things and Orcale for others. The vibes I have seen from both Oracle and MySQL is that for right now MySQL is a complementary product to Oracle. Soon I think MySQL will be right up there with Oracle. Check the

Re: question about mysql backup

You may tar de mysql data directory but you shouldn't do it with mysql server running (because it is using the files). If you do not want to stop the mysql server (or lock it from writes), you can, for example, use mysqlhotcopy first to create an identical data directory and then do a tar on that

Re: question about mysql installation

t somthing that i need to ceate? Thanks for all the ones who replied me. From: "Jerry" <[EMAIL PROTECTED]> Reply-To: "Jerry" <[EMAIL PROTECTED]> To: "shirly cohen" <[EMAIL PROTECTED]> CC: <[EMAIL PROTECTED]> Subject: Re: question about mysq

re: question about mysql installation

On Thursday 20 February 2003 13:42, shirly cohen wrote: > Can i install mysql twice on the same comuter? > And on the same hard disk? Yes and Yes: http://www.mysql.com/doc/en/Installing_many_servers.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This

Re: question about mysql installation

Yes, http://www.mysql.com/doc/en/Installing_many_servers.html - Original Message - From: "shirly cohen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 11:42 AM Subject: question about mysql installation > > Hi all, > Can i install mysql twice on the same

Re: Question about MySQL and lwp_mutex_lock and lwp_mutex_wakeup

On Thu, 12 Dec 2002 18:41:05 -0700 Mariella Di Giacomo <[EMAIL PROTECTED]> wrote: > Hello, > > I am running MySQL 4.0.5b 64 bits on a Solaris 2.8. > The server used has 8 CPUs. > > MySQL DB has access (and menage) in that system 2DBs. > The first DB is only is accessed only through SELECTS and

re: Question about MySQL replication and OPTIMIZE TABLE

Mariella, Thursday, December 05, 2002, 4:15:52 AM, you wrote: MDG> I am running MySQL 4.0.5 64 bit on a Sun Solaris and I am using MyISAM MDG> Indices. MDG> I would like to set replication (one master and one slave). MDG> My question is: MDG> When I OPTIMIZE TABLE table1, ... on the master will

Re: Question about MySQL

Sigalit, Sunday, May 12, 2002, 3:47:24 PM, you wrote: SCD> I am new in the "MySql" business so I'm sorry if my question is too simple. SCD> Is there any way to nest queries in MySql in the following manner: SCD> "select from where id = (select ...)" No, MySQL doesn't have sub-selects yet. You

Re: Question about MySQL

As far as I know MySQL does not yet support nested SELECT statements. -Nick > Hi, > > I am new in the "MySql" business so I'm sorry if my question is too > simple. Is there any way to nest queries in MySql in the following > manner: "select from where id = (select ...)" > > Thanks for your a

Re: Question about mysql++ and g++

Mike Holmquist writes: > Ok, i downloaded the mysql++-1.7.8-1.i386.rpm > rpm > file from RpmFind.net. I have mysql installed already on my machine, o > ya and im running linux. I have gcc installed, version 2.96, i think > e

Re: Question about MySQL GUI on Win32

Jason Holliston writes: > This is probably something I'll smack my head about afterward, but here > goes: is it possible to execute multiple queries in the MySQL client GUI on > Win32? What's accepted on the command line or in a .sql script doesn't work > when pasted into it. Thanks in advance!

RE: Question about MySQL GUI on Win32

Baker [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 24, 2001 8:12 AM > To: Jason Holliston; [EMAIL PROTECTED] > Subject: Re: Question about MySQL GUI on Win32 > > > It depends on the gui you're using. Get the one at my.anse.de > > At 07:49 AM 4/24/2001 -0700, Ja

Re: Question about MySQL GUI on Win32

> It depends on the gui you're using. Get the one at my.anse.de > > At 07:49 AM 4/24/2001 -0700, Jason Holliston wrote: > >This is probably something I'll smack my head about afterward, but here > >goes: is it possible to execute multiple queries in the MySQL client GUI > >on Win32? What's acce

RE: Question about MySQL GUI on Win32

ing. http://www.anse.de/ does, however. Thanks for the information. -Jason -Original Message- From: Scott Baker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 8:12 AM To: Jason Holliston; [EMAIL PROTECTED] Subject: Re: Question about MySQL GUI on Win32 It depends

Re: Question about MySQL GUI on Win32

It depends on the gui you're using. Get the one at my.anse.de At 07:49 AM 4/24/2001 -0700, Jason Holliston wrote: >This is probably something I'll smack my head about afterward, but here >goes: is it possible to execute multiple queries in the MySQL client GUI on >Win32? What's accepted on the

Re: question about mysql under FreeBSD

AIL PROTECTED]> Sent: Sunday, April 22, 2001 7:35 PM Subject: RE: question about mysql under FreeBSD > Hello over there, > > Do you have softupdates enabled? > > Have a good time, > Andrey Nepomnyaschih > [EMAIL PROTECTED] >