Re: Discontinued AUTO_INCREMENT problem....
Hi, There is one variable called innodb_autoinc_lock_mode. If the value is 0, this issue wont come. You might set it to 1 or 2. -Partha www.mafiree.com - Original Message From: Wagner Bianchi wagnerbianch...@gmail.com To: 杨涛涛 david.y...@actionsky.com Cc: Xavier Correyeur x.correy...@free.fr; mysql@lists.mysql.com Sent: Tue, 21 December, 2010 3:28:00 PM Subject: Re: Discontinued AUTO_INCREMENT problem Too curious...could you share a SHOW CREATE TABLE from this table as requested before? Best regards. -- Wagner Bianchi 2010/12/21 杨涛涛 david.y...@actionsky.com Hi. You can show us your show create table statement as well. 杨涛 我博客1:http://yueliangdao0608.cublog.cn My 我博客2:http://yueliangdao0608.blog.51cto.com 2010/12/20 Xavier Correyeur x.correy...@free.fr Hi everybody ! A have a discontinued AUTO_INCREMENT sequence when i insert data in a table with a 100 (or more) items SELECT request. The problem (or situation) is reproductible, you can see an example below. Anybody could explain this to me ? Cheers XC My MySQL version : Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using readline 6.1 == Example = -- CREATE test table mysql create table test(`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` VARCHAR(255), `test` int(10), KEY `keyid`(`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1; Query OK, 0 rows affected (0.00 sec) -- INSERT DATA FROM ANOTHER TABLE mysql insert into test(name) select `name`from user limit 100; Query OK, 100 rows affected (0.01 sec) Records: 100 Duplicates: 0 Warnings: 0 -- AUTO_INCREMENT ID CHECK = OK mysql select max(`id`) from test; +---+ | max(`id`) | +---+ | 100 | +---+ 1 row in set (0.00 sec) --INSERT DATA WITH CHECKED SELECTREQUEST 2 = DATA INSERT OK mysql insert into test(name) select `name` from userlimit 100; Query OK, 100 rows affected (0.01 sec) Records: 100 Duplicates: 0 Warnings: 0 -- AUTO_INCREMENT ID CHECK = should be 100 + 100 = 200 -- = 27 IDs are unset, first ID of 2nd insert is 128 instead of 101 -- No field between 100 and 128 mysql select max(`id`) from test; +---+ | max(`id`) | +---+ | 227 | +---+ 1 row in set (0.00 sec) == End Example = -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=yueliangdao0...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysqldumpslow
Is it possible to run mysqldumpslow on a remote host? -Partha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL restore failing
In mysql 5.1, mysql.proc table contains 20 columns. Can you check your new DB again? -Partha - Original Message From: Machiel Richards machi...@rdc.co.za To: mysql mailing list mysql@lists.mysql.com Sent: Fri, 3 December, 2010 1:38:24 PM Subject: MySQL restore failing Hi All I am hoping that someone could assist me with this one. I am trying to restore a database to a new machine for testing purposes. The current machine is running mysql-5.0.72sp1 and the new machine 5.1.50. When running the restore is runs for quite a while and then crashes with the following message: [r...@mysql2 home]# mysql -u root -p mysql_full_021210.dump Enter password: ERROR 1547 (HY000) at line 14284: Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted I have checked the current production system for this table and the column count is 16, I then checked the new system as well as a newly setup clean MySQL-5.1.50 database and they are all 16 columns and exactly the same as far as I can see. Is there anyone that might know why I am getting this? I would really apprecaite any help as this machine needs to be up and running by eod today. Regards Machiel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL sock file is missing: server doesn't start
Hi, This can be useful... http://mafiree.com/blg/?p=124 -Partha www.mafiree.com - Original Message From: spacemarc spacem...@gmail.com To: MySQL mysql@lists.mysql.com Sent: Mon, 11 October, 2010 12:37:24 AM Subject: MySQL sock file is missing: server doesn't start hi MySQL server doesn't start because #2002 the /var/run/mysqld/mysqld.sock is missing. The server only start with sudo mysqld_safe but without the mysqld.sock file. I've checked my /etc/mysql/my.cnf file and the paths are correct for [client] and [mysqld]: /var/run/mysqld/mysqld.sock I run 5.1.41 on Ubuntu 10.04 How to resolve this issue? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=par...@mafiree.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Export into txt file (comma delimited)
HI, Just add this at the end of your command fields termininated by ',' like below, select * from ae_a222 where ano=2009 and dia_juliano between '1' and '365' into outfile C:\\Documents and Settings\\rbastos\\Meus documentos\\teste.txt fields termininated by ',' ; - Partha www.mafiree.com - Original Message From: Rodrigo A. de Brito Bastos rodrigo...@gmail.com To: mysql@lists.mysql.com Sent: Fri, 8 January, 2010 6:00:19 PM Subject: Export into txt file (comma delimited) Hey guys! Is there a way to export a table into a txt file but delimited *with comma*? I'm using this expression: select * from ae_a222 where ano=2009 and dia_juliano between '1' and '365' into outfileC:\\Documents and Settings\\rbastos\\Meus documentos\\teste.txt Thanks in advance! Rodrigo A. de Brito Bastos rodrigo...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org