Гость
Целевая тема:
Создать новую тему:
Автор:
Форумы / MySQL [игнор отключен] [закрыт для гостей] / auto_increment_increment применяется не для всех таблиц / 3 сообщений из 3, страница 1 из 1
06.12.2013, 00:18:30
    #38491141
Pasha2013
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
auto_increment_increment применяется не для всех таблиц
Подскажите пожалуйста. Настроили 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)


В чем может быть причина?
...
Рейтинг: 0 / 0
06.12.2013, 08:40:53
    #38491239
Akina
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
auto_increment_increment применяется не для всех таблиц
Pasha2013В чем может быть причина?
В нежелании читать маны дальше второй строчки.
...
Рейтинг: 0 / 0
06.12.2013, 10:22:30
    #38491372
Pasha2013
Гость
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
auto_increment_increment применяется не для всех таблиц
Содержательный ответ.
Не укажите на эту строчку в мане?
...
Рейтинг: 0 / 0
Форумы / MySQL [игнор отключен] [закрыт для гостей] / auto_increment_increment применяется не для всех таблиц / 3 сообщений из 3, страница 1 из 1
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]