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
of Oracle for MySQL.
Regards,
Gu Lei
- Original Message -
From: Daniel da Veiga [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, August 08, 2006 12:43 AM
Subject: Re: MySQL SQL statistics
On 8/7/06, 古雷 [EMAIL PROTECTED] wrote:
Hello everyone:
I want to get some SQL statistics
Thanks a lot!
- Original Message -
From: paul rivers [EMAIL PROTECTED]
To: '古雷' [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Monday, July 10, 2006 11:41 AM
Subject: RE: May I create more than 200 databases for one mysqld?
Yes, you can.
Whether there are disadvantages depends
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: mysql@lists.mysql.com
Sent: Tuesday, June 20, 2006 3:49 PM
Subject: finding the slow query
Hi,
I have some
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: mysql@lists.mysql.com
Sent: Thursday, June 08, 2006 9:04 PM
Subject: ERROR 2013 (HY000): Lost
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
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
hahaha, I see. Thank you very much.
Regards,
Gu Lei
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: åˆóã [EMAIL PROTECTED]; mysql@lists.mysql.com
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
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
Thanks a lot. I'll try.
- Original Message -
From: Kishore Jalleda [EMAIL PROTECTED]
To: 古雷 [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, March 29, 2006 11:53 PM
Subject: Re: Multiple-Master Replication recovery
any one of the servers could go down in many ways like
1
.
regards,
gu lei
祝您工作顺利,身体健康,家庭和睦,一切吉祥。
古雷
中企动力科技集团
技术架构部
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
- 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 reply and your help.
I'm working with MySQL 5.0.18-nt via TCP/IP, MyODBC
Thanks a lot!
But my test is not successful. Please help me.
This is my test code:
#ifdef WIN32
#include windows.h
#endif
#include mysql.h
#include stdio.h
main()
{
union ull {
unsigned char a[8];
my_ulonglong id;
} ull;
for(int i=0;i8;i++) ull.a[i]=(unsigned char)255;
char s[200];
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: mysql@lists.mysql.com
Sent: Wednesday, March 15, 2006 11:27 PM
Subject:
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
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: mysql@lists.mysql.com
Sent: Wednesday,
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 PROTECTED]
Cc: MySQL List mysql
-
From: Dušan Pavlica [EMAIL PROTECTED]
To: 古雷 [EMAIL PROTECTED]; MySQL List mysql@lists.mysql.com
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 SET CHARACTER SET utf8 as Initial Statement under
,一切吉祥
古雷
---
中企动力科技集团
技术事业发展部___技术架构部
\__企业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]; mysql@lists.mysql.com
Sent: Tuesday, December 20, 2005 10:10 AM
Subject: Re: (瑞星提示-此邮件可能是垃圾邮件)Re: insert utf8 character in Linux commind-line
tool
Are there two
23 matches
Mail list logo