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

t: 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 tes

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

Question about MySQL

Hello MySQL developers, Could any one tell me if MySQL's equivalent of PRO C concept in ORACLE? and Is there any equivalent for SQL *NET in MySQL? Other than C API/ODBC what are the other interfaces from client applications to MySQL database ? Another question is , whats the general experience o

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

Question about mysql procedures

Hello, Can MySQL functions/stored procedures access database data? Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to

RE: a question about MySQL installation

: Sunday, May 22, 2005 7:12 AM To: mysql@lists.mysql.com Subject: a question about MySQL installation Dear, I have installed MySQL4.1. But why it can not startup when I open my computer? Also, how can I test MySQL can run or not? Thanks for your advice. Best Regards, Terry -- MySQL General

a question about MySQL installation

Dear, I have installed MySQL4.1. But why it can not startup when I open my computer? Also, how can I test MySQL can run or not? Thanks for your advice. Best Regards, Terry

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

question about mysql start up again

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 command : rpm -i *.* then Apache and php can work but

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

Question about [mysql ] processes

Greetings, 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 ([mysql ]). I've checked/tested the obviou

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

Question about MySQL 4.0.20 and make test failure on Linux

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-assembler --enable-

Re: A question about mysql database backup.

On 02/25/2004 09:13 AM Frederic Wenzel wrote: Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I want to make sure whether the following procedures are correct for database backup. 1. mysqldump -F --opt database_name > database_name.backup In my opinion, you shou

Re: A question about mysql database backup.

on 02/27/2004 12:11 AM, Li, Lenny Yong Bo (Lenny) at [EMAIL PROTECTED] wrote: > > 1. database backup. > This is done on the standby one with the following command. > mysqldump --opt --quote-names --flush-logs database_name > database.backup How does this operations handle binary fields, password

RE: A question about mysql database backup.

t, R&D, Lucent Qingdao [EMAIL PROTECTED] 86-532-8702000-5033 http://gdcsr60.gdc.lucent.com/~lennyli > -Original Message- > From: Frederic Wenzel [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 25, 2004 4:13 PM > To: Li, Lenny Yong Bo (Lenny) > Cc: [EMAIL PROTECTED

RE: A question about mysql database backup.

- > From: Frederic Wenzel [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 25, 2004 4:13 PM > To: Li, Lenny Yong Bo (Lenny) > Cc: [EMAIL PROTECTED] > Subject: Re: A question about mysql database backup. > > > Li, Lenny Yong Bo (Lenny) wrote: > > > Now I am

Re: A question about mysql database backup.

Li, Lenny Yong Bo (Lenny) wrote: > Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I > want to make sure whether the following procedures are correct for database backup. > 1. mysqldump -F --opt database_name > database_name.backup In my opinion, you should gen

A question about mysql database backup.

Ms./Sir, Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I want to make sure whether the following procedures are correct for database backup. 1. mysqldump -F --opt database_name > database_name.backup 2. stop mysqld if is running. Then start it with "--log-bin"

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

Question about Mysql C API v 3.22 and 3.23

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 in that version of the C API? Thank You,

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

Question about MySQL and Oracle.

Hello! I have one question. MySQL is better than Oracle or not? Thank you. -- ___ OperaMail free e-mail - http://www.operamail.com OperaMail Premium - 28MB, POP3, more! US$29.99/year Powered by Outblaze -- MySQL General Mailing List For list

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

question about mysql backup

Hi all, Up until now we always created database backups using the mysqldump tool. But I'm wondering, if it is possible to just create a tar archive of the complete mysql data directory. We are running on Linux (2.4.18) and we use mysql 4.014. Thanks, Harm de Laat Informatiefabriek The Netherl

question about mysql-4.x escaping with USE_MB

quoted from mysql-4.1/libmysql/libmysql.c = static ulong mysql_sub_escape_string(CHARSET_INFO *charset_info, char *to, const char *from, ulong length) { const char *to_start=to; const char *end; #ifdef USE_MB my_bool use_mb_flag=use_mb(charset_info); #endif for (end=from+length;

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

question about mysql installation

Hi all, Can i install mysql twice on the same comuter? And on the same hard disk? Thanks, Shilry _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 ---

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

Question about MySQL and lwp_mutex_lock and lwp_mutex_wakeup

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 the second one has been used for UPDATES and INSERTS. Initially I was running a process that was

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

Question about MySQL replication and OPTIMIZE TABLE

Hello, I am running MySQL 4.0.5 64 bit on a Sun Solaris and I am using MyISAM Indices. I would like to set replication (one master and one slave). My question is: When I OPTIMIZE TABLE table1, ... on the master will the slave be updated or if I want to optimize the same tables on the slave I n

A question about mySQL scalability

ly about 50MB (1/80 of the former maximum limit) Do you think I am right trusting mySQL on this one ? What is the upper limit database wide ? I know it depends on the disk space and the CPU and probably the file system.. But what sort of figures do you have in mind when answering this

a question about mysql++

Hi, I am trying to comile a c++ program but I got an error message as below: sqlplus.hh: No such file or directory I have mysql server and client 3.23... on rh 7.2 and I have installed binary RPM for SuSE 8.* built by gcc 3.2 <../Downloads/mysql++/mysql++-1.7.9gcc3.2-2.i386.rpm> by: rpm -ivh "my

Re: Status question about Mysql

On Tue, 20 Aug 2002, Matt Heaton wrote: > Hi, I am running 3.23.49 and had a quick question I hope someone can answer. > 70% of the time my sql server is doing just fine. I have 4 GIGs of memory, > and a 1.33 Ghz processor.I am running Redhat 7.3 with a 2.4.19 kernel. > > 70% of the time m

Status question about Mysql

Hi, I am running 3.23.49 and had a quick question I hope someone can answer. 70% of the time my sql server is doing just fine. I have 4 GIGs of memory, and a 1.33 Ghz processor.I am running Redhat 7.3 with a 2.4.19 kernel. 70% of the time my server is fine, the other 30% it is 100% max

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

Question about MySQL

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 attention, Sigalit _ Join

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

Question about mysql++ and g++

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 everything installed correctly whe

Question about mysql server Installation

Dear Anyone I am one of the Linux user. I use the freebsd operating system. I have one main problem. After installation completed , I put the command "mysql" in #prompt. But some error message will shows, I don't know how to solve it. The Error message is "

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

Question about MySQL GUI on Win32

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! -Jason --

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] >

question about mysql under FreeBSD

Hi, I have test two systems with mysql Linux Slackware 7.1 kernel 2.2.16 and FreeBSD-4.2-STABLE. I have mysql 3.23.36 only running on this two hosts and hosts are the same (PIII 800 Mhz Ami MegaRaid RAID 1 18.2 Go 1 Go RAM). I copy the database from FreeBSD to Linux and I launch a same select o

Hi, a question about mysql and servlets

Hello everyboy, nice to post you. I hope this question not to be very frequent but i'm new in this list. I'd like to know if anybody knows how to connect a servlet with MySQL. It doesn't matter if it is by a ODBC:JDBC bridge o a 100% JDBC Driver. I can download the drivers. I want to know the