Re: auto_increment by more than 1

2011-02-23 Thread Reindl Harald
Am 23.02.2011 22:55, schrieb Singer X.J. Wang: > Yes, you can set it up so that it increases it by X only for that statement.. > eg. > > [other stuff] > set auto_increment_increment = X; > insert into that table you want > set auto_increment_increment = 1; > [other stuff] > > Now you have to r

Re: auto_increment by more than 1

2011-02-23 Thread Reindl Harald
Am 23.02.2011 22:29, schrieb Jim McNeely: > I have read the manual, and you're right, the auto-increment_increment is a > system wide setting No, scope session means "set VAR=value" Command-Line Format --auto_increment_increment[=#] Option-File Format auto_increment_increment Option S

Re: auto_increment by more than 1

2011-02-23 Thread Jim McNeely
This doesn't work, it just sets the starting number, but it will still increment by one unless you set the auto_increment_increment system variable, but this affects all the tables in the DB and not just the particular table. Thanks, Jim McNeely On Feb 23, 2011, at 10:26 AM, Carsten Pedersen w

Re: auto_increment by more than 1

2011-02-23 Thread Jim McNeely
I have read the manual, and you're right, the auto-increment_increment is a system wide setting. I only want this on one table. I am in this instance creating ID's for a separate system via HL7 for a Filemaker system, and FileMaker is too lame and slow to actually spit out an ID in time for the

Re: auto_increment by more than 1

2011-02-23 Thread Shawn Green (MySQL)
On 2/23/2011 12:41, Jim McNeely wrote: Is there a way to set the auto-increment for a particular table to increase by some number more than one, like maybe 10? Thanks in advance, Jim McNeely The manual is your friend. Don't be afraid of it :) http://dev.mysql.com/doc/refman/5.5/en/replicat

Re: auto_increment by more than 1

2011-02-23 Thread Carsten Pedersen
Den 23-02-2011 18:41, Jim McNeely skrev: Is there a way to set the auto-increment for a particular table to increase by some number more than one, like maybe 10? Thanks in advance, Jim McNeely CREATE TABLE t ( ... ) AUTO_INCREMENT=10; / Carsten -- MySQL General Mailing List For list archi

Re: innodb buffer pool allocation question

2011-02-23 Thread petya
Hi, This is far more complicated than that. The buffer pool caches innodb pages. Not only data and indexes are stored on innodb pages. For example the undo log or the insert buffer are stored in innodb pages, therefore they are cached by the buffer pool. The simple answer is: in the buffer po

auto_increment by more than 1

2011-02-23 Thread Jim McNeely
Is there a way to set the auto-increment for a particular table to increase by some number more than one, like maybe 10? Thanks in advance, Jim McNeely -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.

How to log general log on a slave when the master's binlog format is row

2011-02-23 Thread Jameson Li
Hi my mysql server's version is 5.1.32, and my master binlog_format is row. I want to know how to log general log on a slave when the master's binlog format is row. When I modifyed my slave's my.cnf, and add the below lines: *log=/var/log/mysql/mysql-general-log* *log-output=FILE* and then I re

Re: Mysql clustering

2011-02-23 Thread Sander de Bruijne
Hi Machiel, Check these two links for good resources: http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/0596101716 http://www.amazon.com/MySQL-High-Availability-Building-Centers/dp/0596807309 AFAIK there is no up-to-date (print) book about NDB (anyone?). I've used the M

Re: Mysql clustering

2011-02-23 Thread blue mary
Try search it on howtoforge.com Or buy a book like "high performance mysql" for reference. Regards, mary. --- machi...@rdc.co.za wrote: From: Machiel Richards To: mysql mailing list Subject: Mysql clustering Date: Wed, 23 Feb 2011 08:53:10 +0200 Good day all Does anybody perhaps have