Hi Hank
I just can think like this table
CREATE TABLE xyz (
hashtag VARCHAR(...) NOT NULL,
comment_id ... NOT NULL,
user_id bigint unsigned not null,
PRIMARY KEY (hashtag, comment_id),
INDEX(comment_id, hashtag),
index idx_user_id(user_id)
) ENGINE = InnoDB;
one user want to check all his comm
dl Harald wrote:
>
>
> Am 19.10.2012 08:42, schrieb Dehua Yang:
> > MyISAM storage tables also have this kind of problem.
> >
> > I have try serval solutions for this problem , but can't work very well.
> >
> > If your application isn't very import , you
MyISAM storage tables also have this kind of problem.
I have try serval solutions for this problem , but can't work very well.
If your application isn't very import , you can let your application auto
repair this problem.
Just like this :
When your application catch this error information , run
Hi Kent
How did you found the snmp traps ?
Would you give me some tips that how did you locate this problem?
On Thu, Oct 18, 2012 at 5:37 PM, Kent Ho wrote:
> Thanks for the replies.
>
> After examining the logs carefully. We found several devices sending snmp
> traps to the application m
Hello Shawn
Thanks for your tips. We send the " select LAST_INSERT_ID() " by our data
middle ware.
I'll ask the middle ware team to check it out.
On Wed, Oct 17, 2012 at 9:33 PM, Shawn Green wrote:
> Hello Dehua,
>
>
> On 10/17/2012 3:33 AM, Dehua Yang wrote:
&
select LAST_INSERT_ID() ; Under high concurrency , it would return other
threads value to you.
On Wed, Oct 17, 2012 at 2:23 PM, W. D. wrote:
> When creating a record, the first field (KeyField)...
>
> KeyFieldBIGINT UNSIGNED NOT NULL AUTO_INCREMENT
>
> ...is it possible to copy t
Hi
There many reasons to lose connection to MySQL server.
And what's more , the important thing is that you should provide the error
code to us.
If you got the error code , you can check it by perror X
Anymore detail information would be appreciate !
On Wed, Oct 17, 2012 at 10:32 AM, ad...@cana
e5520 - 2.26GHz 500 GB SATAII
2011/2/28 David Brian Chait
>
>
> > -Original Message-
> > From: Yang Yang [mailto:dapiy...@gmail.com]
> > Sent: Sunday, February 27, 2011 12:29 PM
> > To: Johnny Withers
> > Cc: mysql@lists.mysql.com
> > Subject: R
a-centos-red-hat-rhel/
>
> <http://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/>Install
> went well, server runs great. I'd suggest going with 5.5.
>
> JW
>
>
> On Sun, Feb 27, 2011 at 11:30 AM, Yang Yang wrote:
>
>> hi,
hi,i am a new guy for a company,and will make 1-3 server to mysql datacenter
i have 2 question want to ask and hope receive responce
1.on centos or linux server,i should use 5.0 version or 5.1 version,which
verison is better and can resolve many traffic use php+mysql
2.the my.cnf should i config
/opt/MySQL607start.sh
/opt/MySQL607/bin/mysqld_multi start 607
-bash-3.1# cat /opt/MySQL607stop.sh
/opt/MySQL607/bin/mysqld_multi stop 607
==
Best Regards!
Yang Wang
Email: yw...@lfm-agile.com.hk
- Original Message -
From: "Nitin Mehta"
To: "Pra
| NULL| GPL |
+-+--++-+-+
18 rows in set (0.00 sec)
Best Regards!
Yang Wang
- Original Message -
From: "Joerg Bruehe"
To:
Cc: "Yang Wang"
Sent: Monday, Apri
make[1]: *** [install] 错误 2
make[1]: Leaving directory `/home/ruochen/mysql-5.5.4-m3/sql'
make: *** [install-recursive] 错误 1
=
reference:
http://bugs.mysql.com/bug.php?id=51740
Best Regards!
Yang Wang
hanks in advance.
--
Yang Zhang
http://www.mit.edu/~y_z/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
rn up any clear answers. Any way to recover
from this, or is mysqldump + load data the way to go?
--
Yang Zhang
http://www.mit.edu/~y_z/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
| NULL| NULL | 335790898 | 100.00 | Using where; Using temporary
|
+++-+--+---+--+-+--+---+--+--+
2 rows in set, 1 warning (0.04 sec)
--
Yang Zhang
http://www.mit.edu/~y_z/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
dropped). How do I reclaim
my disk space? Thanks in advance.
--
Yang Zhang
http://www.mit.edu/~y_z/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
sing mysql-5.4.3; is this a beta
bug/anyone else happen to know something about this? Thanks in
advance.
--
Yang Zhang
http://www.mit.edu/~y_z/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
e and "select * into outfile
'/tmp/pipe'", but mysql complains about the file existing already.
Is there any other quick way to do this without having to write a
client app? Thanks in advance.
--
Yang Zhang
http://www.mit.edu/~y_z/
--
MySQL General Mailing List
For list a
(b) select b from y;
show create table x;
This will show auto_increment = 32768 instead of 3.
Is this a bug introduced in the beta? Has it been fixed in newer
releases? Couldn't find a mention in the bug database. Thanks in
advance.
--
Yang Zhang
http://www.mit.edu/~y_z/
--
MySQL Genera
rint weight, ids
weight = 0
ids = []
_txn = None
if _txn != txn:
saw_upd = False
if qt == 'update' and not saw_upd:
weight += 1
saw_upd = True
ids += [id]
Is it possible to achieve the Python single-pass performance using
pure SQL? Thanks in
;
I'm not sure if this creates an additional unnecessary join, though --
trying to make sense of the output of EXPLAIN has been a separate
exercise in frustration all to itself (even with mk-visual-explain).
Thanks in advance for any answers.
--
Yang Zhang
http://www.mit.edu/~y_z/
--
MySQL
an AUTO_INCREMENT column that
> contains 0."
>
> -Original Message-
> From: "Yang Zhang"
> Sent: Monday, January 25, 2010 10:21am
> To: mysql@lists.mysql.com
> Subject: auto_increment without primary key in innodb?
>
> In innodb, is it possible
a key
--
Yang Zhang
http://www.mit.edu/~y_z/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ue to buffer page flushes.
OTOH, it may be possible that the DB is already entirely in memory,
and the performance difference is due entirely to mysql runtime
overheads. Either way, explanations/hints would be much appreciated.
Thanks in advance.
--
Yang Zhang
http://www.mit.edu/~y_z/
--
MySQL Ge
B|1 |
| A|2 |
| C|2 |
| D|1 |
| C|4 |
+--+--+
10 rows in set (0.00 sec)
mysql> select name,sum(qty) as qty from t2 group by name order by qty desc;
+--+--+
| name | qty |
+--+--+
| A| 9 |
| C|6 |
| B|3
091213 13:45:13 [ERROR] Can't find messagefile
'/local-home/yang/packdb/mysql/share/mysql/share/english/errmsg.sys'
091213 13:45:13 [ERROR] Aborting
091213 13:45:13 [Note]
Installation of system tables failed! Examine the logs in
./data-mysql/ for more information.
You can try t
)
r...@localhost:(none) 18:36:58>select version();
+---+
| version() |
+---+
| 5.1.29-rc-log |
+---+
1 row in set (0.00 sec)
__
Best Regards!
Yang Wang
Email: yw...@lfm-agile.com.hk
first desc products
or try to
update products set sizes='Small' where
SKU='prodSKU1';
Best Regards!
Yang Wang
Tel.: 0769-21687397
Fax.: 0769-21685577
Email: yw...@lfm-agile.com.hk
- Original Message -
From:
To: "Victor Subervi"
Cc:
Sent: Fri
Dear all,
I have a question about the limitatin of table size.
If I use the InnoDB engine, I don't have to worry that the total size of
table is greater than the single filesize?
Thanks a lot!
Best,
Sookhyun.
aa but CAN NOT
"drop database test_aaa". This is important for me to mantain the
system. Hope someone here can give me some hints! Thanks in advanced!
Regards,
Cheng-Lin Yang
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
esult. All result truely sorted by id by some of
them appears different. Can someone help me on this problem? Any suggestion
is extremely welcomed. Thanks in advanced.
--
Cheng-Lin Yang
Sun Certified Java Programmer
High Speed Network Group Lab (HSNG)
Institu
n advanced! :)
Regards,
Cheng-Lin Yang
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Table 1.45k0.82/s
File30.00/s
for sqlserver200,we can pass 100 warehouse test.
so,we think mysql's performance is better than sqlserver ,but we can't
get the good test result.
best regard
george yang
10/24/200
Dear everyone,
(B
(BI'd like to ask you a question, thanks in advance.
(B
(BQ: How long will it take to import 100GB data into MySQL DB by command "mysqlimport" ?
(B
(BBest regards,
(BMay Yang
(B
(B
(B--
(BMySQL General Mailing List
(BFor list archives: http://lists.
请问，怎么样把文本文件解析出来，然后写入数据库！？就是：C当中的解析器。
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
t liuxin from some limit hosts to access the mysql server. Please
tell me what I should do. Thanks.
Best regards,
Liu Yang
[EMAIL PROTECTED]
2003-07-22
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks guys,
Actaully my Hard disk is 10G, just for one table. There is enough table
space. I noticed when I created index for 1.9G table, at the first phase,
mysql copy table, but mysql doesn't write to the tmp index file, I means the
filesize of the tmp index didn't increase. When I create in
Hello MySQL,
I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I
create indexs for it, I couldn't finish after 4 hours. But when I reduce the
records to 16,000,000, about 1.9G, the same index can be finished within 35
minutes. Can anyone explain it? Thanks in advance.
I a
t "Segmentation Fault "
and If I use "gcc test.c -L /usr/local/mysql/lib/ -static " to compile it ,It says
that "undefined reference to 'mysql_init' "
How should I do ?
Thanks!
Best Regards
Li Yang
Hi, I'm a newbie to MySQL
I have use mysqldump to backup a database to an file named test.sql ,but how I
can load the test.sql to create the same database to another server??
Thanks!
Best Regards
Li Yang
Hi,
I apologize for this too basic question.
I installed MySQL using rpm. But I can't fine
mysql.h and mysql_config on my server. Where are they
from?
More Details:
Environment: MySQL server 3.23.46 and client 3.23.47
on RedHat7.2. MySQL database is running.
Objective: To install MySQL dri
dear Sir/Madam,
I have downloaded mySQL from your company's website.
Is it possible to use mySQL as Microsoft's Access or SQL server7.0? that
means I can create table very easy. just from window screen. I hope get
your reply.
Thanks for you help.
john
--
Dear Sir:
I want to ask some questions about Redhat Linux+MySQL installation.
1. At the Redhat Linux 6.2 opration system, I install MySQL database 3.23.43.
Commands is as follws:
# cd /usr/local
# tar ¨Czxvf MySQL-3.23.443.tar.gz
# mv MySQL-3.23.43 /usr/local/MySQL
# cd /usr/lo
Dear Sir:
I want to ask some questions about Redhat Linux+MySQL installation.
1. At the Redhat Linux 6.2 opration system, I install MySQL database 3.23.43.
Commands is as follws:
# cd /usr/local
# tar ¨Czxvf MySQL-3.23.443.tar.gz
# mv MySQL-3.23.43 /usr/local/MySQL
# cd /usr/lo
Hi,
I have installed mysql version 3.23.38 on solaris 2.7and then
installed and configured the snore to have mysql as the plug-in database.
I created a database 'snort' for snort and a user 'snort' that has
privileges to INSERT
and SELECT on that database.
I then built the structure of the dat
The command I used was:
mysql[2]mysql -u root -h som-host-name
ERROR 1130: Host 'some-host-name.bbn.com' is not allowed to connect to this
MySQL serv
er
>Date: Wed, 13 Jun 2001 14:18:46 -0400
>To: [EMAIL PROTECTED]
>From: Nancy Yang <[EMAIL PROTECTED]>
>Subject
Hi,
when I try the following command, I got is not allowed to connect to
this mysql server.
Any clue?
Nancy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
ved symbol in ./bin/mysqld: pthread_rwlock_rdlock
Unresolved symbol in ./bin/mysqld: pthread_rwlock_unlock
pthread_rwlock_init
pthread_rwlock_destroy
pthread_rwlock_wrlock
I appreciate
49 matches
Mail list logo
