(David Badurina) For small and large database projects, Microsoft Access works wonderfully. If you have a database with hundreds of thousands of records, maybe even connecting to other databases remotely, Access will work just fine. Security isn’t too much of a problem (no Access database is truly s
Tag: Open Source
Random RDBMS and SQL Myths debunked
(Roland Bouman) A few times now, I’ve been wanting to write this down. I know: a lot of people will go *shrug*. Others may find me pedantic. Some of will say I’m being a smart-ass. Whatever…but I just got to write down a few of these common misconceptions that keep floating around.
MySQL 5.1 auto-inc patch in action: InnoDB scalability test
(Alexander Rubin) I’ve recently done a quick scalability test with MySQL 5.0 and 5.1 to check the new auto-inc patch with InnoDB and to see how MySQL 5.1 scales with InnoDB:
How MySQL replication got out of sync
(Xaprb) I created MySQL Table Checksum because I was certain replication slaves were slowly drifting out of sync with their masters, and there was no way to prove it. Once I could prove it, I was able to show that replication gets out of sync for lots of people, lots of times. (If you really want to
PostgreSQL Advocates Press On
(Brian Prince) Advocates of PostgreSQL say the open-source database is continuing to slowly win converts even as it remains in the shadow of the more widely used MySQL.
Explaining InnoDB graphs for MySQL Administrator
(Corrado Pandiani) Regarding my last post MySQL Administrator useful InnoDB graphs here are the explanations about the meaning of some of the graphs.
Filtered MySQL Replication
(Peter Zaitsev) To get this straight – I’m not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication itself and getting things right with filtering can get quite bumpy road. In some applications however it is very helpful so lets see
MySQL Archiver can now archive each row to a different table
(Xaprb) One of the enhancements I added to MySQL Archiver in the recent release was listed innocently in the changelog as “Destination plugins can now rewrite the INSERT statement.” Not very exciting or informative, huh? Keep reading.
MySQL and Disk Transfers Per Second
(Kevin Burton) The UNIX iostat command (along with vmstat) is a great tool for finding bottlenecks in your disk subsystem.
Choosing innodb_buffer_pool_size
(Peter Zaitsev) My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description.
