quick question on mysql memory usage

the query, will the memory used by this query release to OS? Thanks in advance for your info. Regards, jenny

question on mysql proxy's load balancing

Hi, When I read Jk's document on MySQL proxy: http://jan.kneschke.de/projects/mysql/mysql-proxy/ In Load balancing part, he mentioned that: "We use SQF (shortest queue first) to distribute the load across the backends equally. Each backend will get the same number of connections." My understandi

quick question on innodb_log_file_size

64-bit system as well? Why? Thanks in advance for your information. Jenny

Re: best practice MySQl backup onto tape

Hi, Keith, In my case, it is just single MySQL server(no replication). Thanks for your info, I'll check with mk-parallel-dump tools, since the speed of backup is important considering the database is locked for the duration of the backup. Regards, Jenny On 12/14/07, B. Keith Murphy &l

best practice MySQl backup onto tape

nce, or can backup directly to the tape(no need to dump to disk first), etc. comparing to use mysqldump. Thanks in advance for your information, or comment on the above solution. Regards, Jenny

Question on "mysql-test-run sp" failed

verrun the stack, and looks like that authors of the test wanted to note exactly this - could you please let me know if my understanding is correct, and let me know how to increase the stack limit for the mysqld process? Thanks much for your information in advance. Regards, Jenny

how to start mysql instanct manager on Solaris platform?

rom /usr/local/mysql/bin/mysql mysql> show instances It complained wrong sysntax,that make me believe that commands for MySQL IM accepts are not available for some reason. Is there anything wrong with my above steps causing the problems? Thanks in advance for your information! Jenny

How to port Oracle anonymous PL/SQL block to MySQL

Hi, As I know that MySQL supports stored procedure from 5.0. Does anyone have the info on if there is any plan to support anonymous PL/SQL block in MySQL in later MySQL version? So that when port Oracle anonymous PL/SQL block, it doesn't need to change to procedure/function? Thanks, Jenny

MySQL slow query log

Hi, Could anyone explain what might be the possible reasons that in the slow query log(running read-only queries) the most very slow queries(taking 200-300sec) were the queries: 1. create table ... type = MyISAM 2. show slave status Thanks, Jenny

Re: can't connect to the MySQL server from remote machine?

Hi, I tried with "telnet localhost 3306" locally, and got the message as: "Connected to localhost.localdomain (127.0.0.1). Escape character is '^]'. = 5.0.16-standard!QS//?.e,7~9>iw;]E!r=Connection closed by foreign host." What is this meaning? Thanks, Je

Re: can't connect to the MySQL server from remote machine?

Yes, I did try both hostname and IP, but can't work although I can ping to the two boxes from each other. Just wondering if it is because of the port(3306) got disabled?? Thanks, Jenny On 12/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Jenny Chen <[EMA

can't connect to the MySQL server from remote machine?

of the error message and how to solve it? Thanks, Jenny

any alias for MySQL cluster question?

Hi, I'd ask some questions on MySQL cluster. Does anyone know if there is any email alias for the cluster questions? Thanks, Jenny

A few questions about triggers in MySQL 5

Hi, Does the current latest MySQL 5.0 support: 1. column based triggers 2. trigger restriction 3. multiple triggers of same type of the table 4. triggers reference another table And any information on in which release they will be supported? Thanks, Jenny

RE: rename database

Thanks that's easy. -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 10:28 AM To: 'Chen, Jenny '; ''[EMAIL PROTECTED]' ' Subject: RE: rename database You can rename it at the filesystem level. -Orig

rename database

Experts: Is it possible to rename existing database ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

InnoDB

configured? Thanks in advance. Jenny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to get timestamp of inserted record

...what i have to do...i have to mention the current timestamp value with values of all fields of a record or is there any way to insert new record so that it will automatically take current timestamp for that record. Plz specify the sql query also, if u know right now. Thx in advance. Rgds, Jenny

Is type of datetime & timestamp same??

tamp value is different. I m having a problem how can I distinguish them so that I can insert the data in correct format.or is there any bug in myodbc driver. Thanx in advance for ur kind help. Rgds, Jenny __ Do You Yahoo!? Yahoo! Health - Feel be

Is type of datetime & timestamp same??

ferent. I m having a problem how can I distinguish them so that I can insert the data in correct format.or is there any bug in myodbc driver. Thanx in advance for ur kind help. Rgds, Jenny __ Do You Yahoo!? Yahoo! Health - Feel better, live b

Error Codes

the return error code value and which file contains all these error codes?? I m using function SQLGetDiagRec() to see the error messages, Can i use the same for error code? Thx in advance, Rgds, Jenny __ Do You Yahoo!? Yahoo! Autos - Get

Error Codes

and which file contains all these error codes?? I m using function SQLGetDiagRec() to see the error messages, Can i use the same for error code? Thx in advance, Rgds, Jenny __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http

How can I make and execute .sql file

whatever operation i need i can write on it. Plz help me to make it. Rgds, jenny __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com - Before posting

Segmentation Fault

i comment this, it gives with SQLFreeStmt with SQL_DROP I m unable to catch the cause, can anyone help me to come out this problem. Thanx in advance. Rgds, Jenny __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http

Sql Query

Hello all, I wud like to know one query by which i can copy/create the same table from existing table. Rgds, Jenny __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com

Re: what is the limit for max_packet_size?

n the small file size also can't. Thanks - Original Message - From: "Carsten Gehling" <[EMAIL PROTECTED]> To: "Jenny" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 15, 2002 1:23 PM Subject: Re: what is the limit for max_pack

what is the limit for max_packet_size?

the small file size also can't??? Is somebody know face this problem b4? Thank very much. Jenny Ko System Engineer INFOPRO SDN BHD The Total Banking Solution Provider

How to retrieve image from MySQL

that if we want to insert binary data into a BLOB column, some special characters must be represented by escape sequences, is it any function available in VB? Is any one know what forum is discuss about VB and MySQL? Thanks Regards, Jenny

Please remove me

Hi, Please remove my name from the list. Thanks! Jenny Lie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

RE: Installation problem.

Hi, Thanks! I did log in as Administrator. I'm running Windows NT Server 4.0 Jenny Lie Web Developer Onramp Network Services Inc. 200 Town Centre Blvd, #302 Markham, ON L3R 8G5 (905) 470-4064 EXT 241 E-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> http://www.onramp.ca --

RE: Installation problem.

I did reboot the machine and it still can't do mysqld-nt --install. Anything I should do? The first step, I did run setup.exe, then in c:\mysql\bin, I ran mysqld-nt --install, was that right? Thanks for your time. Jenny Lie Web Developer Onramp Network Services Inc. 200 Town Centre