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
13 14:04:19 [Note] mysql//bin/mysqld: ready for connections.
Version: '5.4.3-beta' socket: '/tmp/mysql.sock' port: 3307 MySQL
Community Server (GPL)
$ mysql//bin/mysql -u root mysql -e 'show tables;'
--
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
13 matches
Mail list logo
