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 machi...@rdc.co.za
To: mysql mailing list mysql@lists.mysql.com
Subject: Mysql clustering
Date: Wed, 23 Feb 2011 08:53:10 +0200
Good
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
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
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:
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
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
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 :)
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
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
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 Sets
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 remmeber
11 matches
Mail list logo