|
|
|
auto_increment_increment применяется не для всех таблиц
|
|||
|---|---|---|---|
|
#18+
Подскажите пожалуйста. Настроили master/master, в конфиге соответственно auto_increment_increment=2 auto_increment_offset=1 и auto_increment_increment=2 auto_increment_offset=1 репликация работает, но возникла проблема с тем, что не во всех таблицах AUTO_INCREMENT прибавляет с учетом настроек. В некоторых таблицах по прежнему делает +1. Например для этой: node | CREATE TABLE `node` ( │······························································· `nid` int(10) unsigned NOT NULL AUTO_INCREMENT, │······························································· `vid` int(10) unsigned NOT NULL DEFAULT '0', │······························································· `type` varchar(32) NOT NULL DEFAULT '', │······························································· `title` varchar(128) NOT NULL DEFAULT '', │······························································· `uid` int(11) NOT NULL DEFAULT '0', │······························································· `status` int(11) NOT NULL DEFAULT '1', │······························································· `created` int(11) NOT NULL DEFAULT '0', │······························································· `changed` int(11) NOT NULL DEFAULT '0', │······························································· `comment` int(11) NOT NULL DEFAULT '0', │······························································· `promote` int(11) NOT NULL DEFAULT '0', │······························································· `moderate` int(11) NOT NULL DEFAULT '0', │······························································· `sticky` int(11) NOT NULL DEFAULT '0', │······························································· PRIMARY KEY (`nid`,`vid`), │······························································· UNIQUE KEY `vid` (`vid`), │······························································· KEY `node_type` (`type`(4)), │······························································· KEY `node_title_type` (`title`,`type`(4)), │······························································· KEY `status` (`status`), │······························································· KEY `uid` (`uid`), │······························································· KEY `node_moderate` (`moderate`), │······························································· KEY `node_promote_status` (`promote`,`status`), │······························································· KEY `node_created` (`created`), │······························································· KEY `node_changed` (`changed`), │······························································· KEY `node_status_type` (`status`,`type`,`nid`), │······························································· KEY `nid` (`nid`) │······························································· ) ENGINE=InnoDB AUTO_INCREMENT=1072068 DEFAULT CHARSET=utf8 | при этом: > SHOW GLOBAL VARIABLES LIKE 'auto_increment_increment'; │······························································· +--------------------------+-------+ │······························································· | Variable_name | Value | │······························································· +--------------------------+-------+ │······························································· | auto_increment_increment | 2 | │······························································· +--------------------------+-------+ │······························································· 1 row in set (0.00 sec) │······························································· │······························································· > SHOW GLOBAL VARIABLES LIKE 'auto_increment_offset'; │······························································· +-----------------------+-------+ │······························································· | Variable_name | Value | │······························································· +-----------------------+-------+ │······························································· | auto_increment_offset | 1 | │······························································· +-----------------------+-------+ │······························································· 1 row in set (0.00 sec) В чем может быть причина? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 06.12.2013, 00:18:30 |
|
||
|
auto_increment_increment применяется не для всех таблиц
|
|||
|---|---|---|---|
|
#18+
Pasha2013В чем может быть причина? В нежелании читать маны дальше второй строчки. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 06.12.2013, 08:40:53 |
|
||
|
|

start [/forum/topic.php?fid=47&fpage=197&tid=1835595]: |
0ms |
get settings: |
6ms |
get forum list: |
9ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
22ms |
get topic data: |
6ms |
get forum data: |
2ms |
get page messages: |
29ms |
get tp. blocked users: |
1ms |
| others: | 204ms |
| total: | 283ms |

| 0 / 0 |
