Classic Listener Process 1 Process 2 Process 3
- Slides: 23
Архитектура Classic Listener Process 1 Process 2 База данных Process 3
Classic Process 1 update re-read Process 2 База данных
Архитектура Super. Server Process Thread pool, Cache, M-Cache База данных
Interbase 7 n Multithreading n Shared memory access Загрузка процессоров (CPU_AFFINITY) n MAX_THREADS n – default = 50 n Local applications – max_threads = 1
Временные таблицы n TMP$DATABASE n TMP$TRANSACTIONS TMP$ATTACHMENTS n TMP$STATEMENTS n TMP$POOLS n TMP$PROCEDURES n TMP$RELATIONS n TMP$POOL_BLOCKS n
Запросы к временным таблицам n Наиболее длительные запросы – SELECT a. tmp$user, s. tmp$timestamp, s. tmp$sql, s. tmp$quantum FROM tmp$statements s, tmp$attachments a WHERE a. tmp$attachment_id = s. tmp$attachment_id ORDER BY s. tmp$quantum DESC ROWS 10; n Активность пользователя – SELECT TMP$USER, TMP$USER_IP_ADDR, TMP$TIMESTAMP, TMP$STATE, TMP$TRANSACTIONS, TMP$RECORD_SELECTS, TMP$RECORD_INSERTS, TMP$RECORD_UPDATES, TMP$RECORD_DELETES FROM TMP$ATTACHMENTS WHERE TMP$USER = 'SYSDBA'
Управление сервером n Отключение коннекта – UPDATE TMP$ATTACHMENTS SET TMP$STATE = 'SHUTDOWN' WHERE (TMP$ATTACHMENT_ID = 12345) n Отмена выполнения запроса – UPDATE TMP$STATEMENTS SET TMP$STATE = 'CANCEL‘ WHERE (TMP$STATEMENT_ID = 12345) n Принудительное завершение транзакций – UPDATE TMP$TRANSACTION SET TMP$STATE = 'ROLLBACK' WHERE (TMP$TRANSACTION_ID = 12345) n Отмена любых операций в коннекте
BOOLEAN n create table XXX( …, b boolean) n Длина - 4 байта 0 = False n 1 = True n unknown = Null n Допускаются 0 и 1 в качестве значений n
Позиционирование Функциональность Oracle DB 2 Sybase SQLServer Enterprise Inter. Base 7 Server Edition Embedded Application Specific Inter. Base 7 Desktop & Server Editions Inter. Base 7 Desktop Edition Desktop Paradox Filemaker Fox. Pro Codebase More Concurrent Users
Интерпретация результатов n n n n n FIBPlus Inter. Base Express BDE IB Objects db. Express Функции IB API Free IB Components ODBC OLE DB Zeos Database Objects 33% 10% 4% 4% 2% 2% 1%
Вопросы? support@ibase. ru
- Fabric event listener
- Plot clue no red ink
- Perceptive listening definition in music
- Database listener
- Good listener
- Purposeful listening meaning
- Active vs passive listening
- Gui event types in java
- Mand in psychology
- Specialized cloud mechanisms
- Ros tf listener
- Listening
- Swing component
- Component listener
- Listening strategies
- It takes a great man to be a good listener meaning
- Java awt event listener
- Content oriented listener examples
- Scenebuilder
- Java listener
- Jlist listener
- Listener pattern
- Ambusher listener
- Automated scaling listener