Oracle for MySQL.
Regards,
Gu Lei
- Original Message -
From: "Daniel da Veiga" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 08, 2006 12:43 AM
Subject: Re: MySQL SQL statistics
> On 8/7/06, 古雷 <[EMAIL PROTECTED]> wrote:
>> Hello everyone:
>>
>>
Hello everyone:
I want to get some SQL statistics including executions, CPU time for each SQL
Statement.
How can I get it from MySQL?
regards,
Gu Lei
Thanks a lot!
- Original Message -
From: "paul rivers" <[EMAIL PROTECTED]>
To: "'古雷'" <[EMAIL PROTECTED]>;
Sent: Monday, July 10, 2006 11:41 AM
Subject: RE: May I create more than 200 databases for one mysqld?
> Yes, you can.
>
> Wh
May I create more than 200 databases for one mysqld?
And is there any disadvantage when there're many databases on one mysqld?
Thanks.
Regards,
Gu Lei
Hi,
Maybe you can use --log-slow-queries.
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
Gu Lei
- Original Message -
From: "Peter Van Dijck" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, June 20, 2006 3:49 PM
Subject: finding the slow query
> Hi,
> I have some troubles finding t
hahaha, I see. Thank you very much.
Regards,
Gu Lei
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "åˆóã" <[EMAIL PROTECTED]>;
Sent: Friday, June 09, 2006 11:02 AM
Subject: Re: mysql-5.0/Docs
At 10:45 +0800 6/9/06, å^óã wrote:
>Thanks a lot.
>
>
>
>In MySQL Internal
Thanks a lot.
In MySQL Internals Manual:
"At this moment, internals.xml has over 100 pages of information, including
some details about the formats of MySQL files that you won't find anywhere
else, and a complete description of the message formats that the client and
server use to communicate
Hello:
In MySQL Internals Manual:
"With the BitKeeper downloads, /Docs is nearly empty. The important files are
only present if you do a regular source-file download, or if you do a separate
'bk clone' for 'mysqldoc' instead of 'mysql-5.0' (in which case this major
directory is mysqldoc/Docs i
Hello
That version is quite old and is an alpha version. I think you can download a
release for production use.
Gu Lei
- Original Message -
From: "murthy gandikota" <[EMAIL PROTECTED]>
To:
Sent: Thursday, June 08, 2006 9:04 PM
Subject: ERROR 2013 (HY000): Lost connection to MySQL serve
Hello:
For example:
What does "Web Access" and "Remote Troubleshooting" mean in this page
https://shop.mysql.com/network.html?rz=s2
regards,
gu lei
Hello:
How could I know which transaction or thread hold the lock?
For example:
show innodb status\G
---TRANSACTION 0 78076313, ACTIVE 3906 sec, process no 12729, OS thread id
2952076208 starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 1024
MySQL threa
help me.
regards,
gu lei
祝您工作顺利，身体健康，家庭和睦，一切吉祥。
古雷
中企动力科技集团
技术架构部
Thanks a lot. I'll try.
- Original Message -
From: "Kishore Jalleda" <[EMAIL PROTECTED]>
To: "古雷" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, March 29, 2006 11:53 PM
Subject: Re: Multiple-Master Replication recovery
> any one of the servers could g
Hello:
If I use Multiple-Master Replication with two mysql server, when one of them
goes down(disk crashed) must I shutdown the good one to recover the
Multiple-Master Replication ?
regards,
gu lei
w.
regards,
gu lei
- Original Message -
From: "Daniel Levy" <[EMAIL PROTECTED]>
To: "古雷" <[EMAIL PROTECTED]>
Sent: Thursday, March 23, 2006 3:26 PM
Subject: Re: Unicode (UTF-8) question
> Dear Gu Lei,
>
> Again, thank you very much for your r
Nelson:
Thanks a lot.
I found that sprintf(s,"%llu\n",ull.id); works with gcc but not with VC6.0 .
Thanks.
Regards,
Gu Lei
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "??" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, March 15, 2006 11:27 PM
Subject: Re: insert my
Thanks a lot!
But my test is not successful. Please help me.
This is my test code:
#ifdef WIN32
#include
#endif
#include "mysql.h"
#include
main()
{
union ull {
unsigned char a[8];
my_ulonglong id;
} ull;
for(int i=0;i<8;i++) ull.a[i]=(unsigned char)255;
char s[200];
sprintf(s,"%llu\
Hello,everyone!
My table has a bigint column which needs store 8bytes integer.
I looked up in Mysql Menual. It seems that , if I use C API I can only use
preapared statement functions to insert bigint values.
I can not use mysql_real_query or mysql_query to insert bigint values because I
do not
You can set character set for each column or set default character set for each
table when CREATE TABLE.
Also you can set default character set for each database when CREATE DATABASE.
- Original Message -
From: "Dave M G" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, February 15, 2006 1:54 A
Hi, Shawn Green
Thanks for your reply. But I expect new version of MyODBC(one of
mysql-connectors), not of mysqld. We now use mysql5.0. The newest version of
MyODBC is 3.51.12.
Regards,
gulei
- Original Message -
From: <[EMAIL PROTECTED]>
To: "古雷" <[EMAIL PROTECTE
al Message -
From: "Dušan Pavlica" <[EMAIL PROTECTED]>
To: "古雷" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Tuesday, January 10, 2006 6:34 PM
Subject: Re: How can I keep character_set_client value after MyODBC auto
reconnect?
> Hi,
>
> did you try
，一切吉祥
古雷
---
中企动力科技集团
技术事业发展部___技术架构部
\__企业IP通讯部
电话：010 58022278-302
地址：北京亦庄经济技术开发区北工大软件园
（地盛北街1号）A区3号楼
邮编：100176
export LANG=zh_CN.UTF-8
- Original Message -
From: "wangxu" <[EMAIL PROTECTED]>
To: "Andreas Streichardt" <[EMAIL PROTECTED]>;
Sent: Tuesday, December 20, 2005 10:10 AM
Subject: Re: (瑞星提示-此邮件可能是垃圾邮件)Re: insert utf8 character in Linux commind-line
tool
> Are there two option?
> How to u
23 matches
Mail list logo
