[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 574: sizeof(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 630: sizeof(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 494: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 113: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5348: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3937)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5348: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3937)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5348: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3937)
Russian Progress User Group • Большая база и st-файл
Страница 1 из 1

Большая база и st-файл

Добавлено: 25 дек 2014, 12:00
Базоров Роман
Приветствую.

Есть в базе данные (bsize 8192) Area II размером 42 Гб.
Какую указать структуру области в st-файле с точки зрения производительности (90% чтение, 10% запись) ?

d "history":11,64;512 /data/base_11.d1 f 50000000
d "history":11,64;512 /data/base_11.d2
или
d "history":11,64;512 /data/base_11.d1 f 10000000
d "history":11,64;512 /data/base_11.d2 f 10000000
d "history":11,64;512 /data/base_11.d3 f 10000000
d "history":11,64;512 /data/base_11.d4 f 10000000
d "history":11,64;512 /data/base_11.d5 f 10000000
d "history":11,64;512 /data/base_11.d6
или
d "history":11,64;512 /data/base_11.d1 f 5000000
d "history":11,64;512 /data/base_11.d2 f 5000000
d "history":11,64;512 /data/base_11.d3 f 5000000
d "history":11,64;512 /data/base_11.d4 f 5000000
d "history":11,64;512 /data/base_11.d5 f 5000000
d "history":11,64;512 /data/base_11.d6 f 5000000
d "history":11,64;512 /data/base_11.d7 f 5000000
d "history":11,64;512 /data/base_11.d8 f 5000000
d "history":11,64;512 /data/base_11.d9 f 5000000
d "history":11,64;512 /data/base_11.d10 f 5000000
d "history":11,64;512 /data/base_11.d11

P.S. Область растет достаточно быстро, 2-3 Гб в месяц

Re: Большая база и st-файл

Добавлено: 25 дек 2014, 13:44
Arelav
Чем меньше экстентов, тем лучше - я бы выбрал первый вариант. Или даже вообще оставил один экстент переменного размера.

Re: Большая база и st-файл

Добавлено: 25 дек 2014, 13:50
Arelav
Действительно, поскольку это область второго типа и размер кластера указан 512 блоков, и поскольку по мере необходимости пространство выделяется в Type II сразу кластерами, то сильной разницы между переменными и фиксированными экстентами в производительности заметно не будет.

Re: Большая база и st-файл

Добавлено: 25 дек 2014, 13:51
Arelav
Вот здесь,"17.Какие типы экстентов лучше использовать, переменного или фиксированного размера?", Гас описывает различие их http://rupug.pro/frequently-asked-quest ... e-rdbms/3/

Re: Большая база и st-файл

Добавлено: 25 дек 2014, 14:19
Базоров Роман
Спасибо, прочитаем

Сейчас я тестирую производительность разных st на чтение.
На файловой системе XFS с inode64 различимой разницы нет.

Re: Большая база и st-файл

Добавлено: 25 дек 2014, 14:30
Arelav

Re: Большая база и st-файл

Добавлено: 26 дек 2014, 15:06
Базоров Роман
Цифры, увы, не сохранились

Тестирование было примитивным:
1) одноопоточное -> tabanalys, idxanalys
2) многопоточное -> взял 3 самых больших таблицы и for each по каждому индексу (14 параллельных поисков) + считаем усредненный результат

P.S. На ext4 результаты медленнее, поэтому могу порекомендовать ext4 для домашних каталогов пользователей
и p/r-модулей, а базу данных запускать на xfs. Сравнивал через full backup/restore