Posted in MySQL, Non-Tech Articles, Not on Homepage, Oracle, SQL Server, dbWatch by: Keith Murphy
Comments Off
02 Jul
Seems I have turned into a bit of a news source. dbWatch Software sent me a news release on their dbWatch monitoring platform, which looks like it might be an interesting product for those who work in a heterogeneous database environment. Here’s the release:
FOR IMMEDIATE RELEASE
Contact:
Rob Shuster, VP US Sales
dbWatch USA
6122B S. Eagle Pass […]
Posted in 10.2.0.4, DBA, Oracle, numa by: Jeff Hunter
Comments Off
02 Jul
No, no, not the Brangelina twins announcement, the numactl output.
$ ps -ef | grep oracle
oracle 13771 2418 0 Jun24 pts/0 00:00:00 -ksh
oracle 13772 13771 0 09:24 pts/0 00:00:00 ksh -i
oracle 13775 13772 0 09:24 pts/0 00:00:00 ps -ef
oracle 13776 13772 0 09:24 pts/0 00:00:00 grep oracle
$ numactl –hardware
available: 4 nodes (0-3)
node 0 size: 10239 MB
node 0 free:
Posted in OOW, Oracle, Random, openworld, openworld2008, ukoug de sig by: Tim...
Comments Off
02 Jul
Just a quick post to let people know what is going on in the next few weeks/months…
UKOUG DE SIG
I’m speaking at the UKOUG DE SIG on the 10th July. Andrew Clarke had a free slot so I offered to speak to help him out. I owe him a few favors and it is on my […]
Posted in Infrastructure by: Jonathan Lewis
Comments Off
02 Jul
I’ve just been browsing through a subdirectory on my laptop that has been copied from machine to machine over the years - even though some of the material needs programs that probably don’t exist any more.
This slide, from a presentation I gave at the UKOUG annual conference in 1996, raised a wry smile. The title […]
Posted in Oracle by: kevinclosson
Comments Off
02 Jul
While doing an install of 11g x86_64 11.1.0.6 Clusterware today I hit a problem I’ve seen before but had to think for a moment about what was the cause of the error. I figured if I had to scratch my head on this one, someone, someday would likely be out googling for the answer. Here […]
Posted in MVCC, MySQL, innodb, innodb_buffer_pool_size, innodb_data_file_path, innodb_data_home_dir, innodb_file_per_table, innodb_flush_log_at_trx_commit, innodb_log_file_size, page-level locking, row-level locking, table-level locking by: Keith Murphy
Comments Off
02 Jul
InnoDB is a storage engine that uses MVCC (described shortly) to provide ACID-compliant transactional data storage using row-level locking. MVCC stands for Multi-Version Concurrency Control. It is how InnoDB allows multiple transactions to look at a data set of one or more tables and have a consistent view of the data. MVCC keeps a […]