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
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,
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
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
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
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
)
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
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
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
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
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
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
;
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
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
(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
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
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
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
| 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
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
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
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
| 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
/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
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
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
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:
&
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
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
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
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
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.
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
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
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]
请问，怎么样把文本文件解析出来，然后写入数据库！？就是：C当中的解析器。
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
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.
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
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 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
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/
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,
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
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]
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
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]
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
--
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
