Fulltext results:

01 PostgreSQL streaming replica @01_linux:11_データベース:02_postgresql

10 Hits, Last modified: 3 years ago

-c "UPDATE actor set first_name='BBB' where actor_id=1" UPDATE 1 $ psql -h 172.16.0.52 -U postgres testdb -c "SELECT * FROM actor where actor_id=1" actor_id | first_name | last_name | last_update ----------+------------+---------... tgres testdb -c "SELECT * FROM actor where actor_id=1" actor_id | first_name | last_name | la

15 InnoDB テーブルロック @01_linux:11_データベース:01_mysql

4 Hits, Last modified: 7 years ago

select * from lock_test; +----+--------+-----+ | id | name | age | +----+--------+-----+ | 1 | tan... 2 sec) </code> <code> create table lock_test ( id int primary key auto_increment, name varchar(... sec) mysql> UPDATE lock_test SET age = 21 WHERE id=1; Query OK, 1 row affected (0.01 sec) Rows match... sec) mysql> UPDATE lock_test SET age = 31 WHERE id=2; Query OK, 1 row affected (0.00 sec) Rows match

07 INNODB/MyISAM 確認方法 @01_linux:11_データベース:01_mysql

3 Hits, Last modified: 9 years ago

| eccube_db | | dtb_best_products_best_id_seq | MyISAM | eccube_db ... | InnoDB | eccube_db | | dtb_bloc_bloc_id_seq | MyISAM | eccube_d... B | eccube_db | | dtb_category_category_id_seq | MyISAM | eccube_db

50 MySQLベンチマーク(sysbench) @01_linux:11_データベース:01_mysql

3 Hits, Last modified: 3 years ago

ql> GRANT ALL ON sbtest.* TO 'sbtest'@'localhost' IDENTIFIED BY '[PASSWORD]'; Query OK, 0 rows affecte... " for starting transactions Using auto_inc on the id column Threads started! Time limit exceeded, exit... AUTO_INCREMENT (or equivalent) should be used on id column [on] --oltp-connect-delay=N tim

01 Galera構築 @01_linux:11_データベース:01_mysql

1 Hits, Last modified: 7 years ago

eady|「ON」 になっている| |wsrep_local_index|レプリケートのIndex ID(0から始まります)| |:::|※レプリケート機能が正常な場合は重複することはありません| 後

03 InnoDBテーブル分割 @01_linux:11_データベース:01_mysql

1 Hits, Last modified: 12 years ago

ode> ===== リストア ===== <code console> # mysql < all_backup.sql </code> これで、tablename.idb ができるようになります。

09 Galera + innodb_flush_log_at_trx_commit @01_linux:11_データベース:01_mysql

1 Hits, Last modified: 9 years ago

== 2.障害試験 ===== [[http://planet.mysql.com/entry/?id=2182281|参考:Galera + innodb_flush_log_at_trx_commi

13 mysql56 + galera3 @01_linux:11_データベース:01_mysql

1 Hits, Last modified: 9 years ago

GRANT ALL PRIVILEGES ON *.* TO xtrabk@'localhost' IDENTIFIED BY 'WGHI6t84oaiCh8'; FLUSH PRIVILEGES; </