Tag: MySQL

Google Charts for DBA: Tablespaces Allocation

Pythian DBA’s have daily reports for each monitored database and some of the components are using charts to visualize the data. I’m a big fan of charts myself (when applied appropriately) and want to show how you can generate simple charts directly from the database. You’d be very surprised how easy it can be done from *any* database without installing any additional software or configuring something special.

Read More >

Log Buffer #135: A Carnival of the Vanities for DBAs

Welcome to the 135th edition of Log Buffer, the weekly review of database blogs.

Read More >

Different Technology Stacks On Production and DR?

Last week, I was at the NetApp office in North Sydney for the presentation on NetApp SnapManager for Oracle. It was good opportunity to learn more about NetApp snapshots while working on a project for one of our clients in Sydney. It was an especially interesting topic as I have some experience using Veritas Checkpoints. I learned that NetApp can provide access to the same LUNs via either Fiber-Channel (FC) or iSCSI. And this is when the interesting argument surfaced.

Read More >

Log Buffer #134: A Carnival of the Vanities for DBAs

Welcome to the 134th edition of Log Buffer, the weekly review of database blogs. There’s no time to lose, so let’s begin—with MySQL.

Read More >

MySQL Query Analyzer Review

I had the chance to review the new Query Analyzer program from Sun over the last few days. I am very interested in how it performs as I have previously not had a chance to see the program in action (or the Enterprise Monitor program either for that matter). So, before getting into what the Query Analyzer can (and cannot) do let’s look at what Sun says it does.

Read More >

Log Buffer #133: A Carnival of the Vanities for DBAs

Hello and welcome to the 133rd edition of Log Buffer, the weekly review of database blogs.

Read More >

MySQL: Using CONNECT to Quickly Verify Replication Health

One very helpful use of the technique Sheeri described in Remote connections without leaving the mysql shell is making sure that replication is working properly. According to the MySQL Reference Manual’s section on SHOW SLAVE STATUS Syntax, it shows information corresponding to the slave thread in the slave server. When replication is broken, however, or not working properly due to network issues between master and slave, this information may not be accurate. This has improved over recent releases, but it’s still not perfect. The question, then, is: how to be 100% sure (or as close as you can get to 100%) that replication is running fine? The answer, as offered by Sheeri: use CONNECT.

Read More >

MySQL Memory Consumption

Sure, there are some big things. innodb_buffer_pool_size and key_buffer_size spring to mind. But all the little things add up too. On a busy system did you consider thread_stack? It defaults to 128k per connection. With 500 connections that’s 64 MB. You may dismiss that and and say its not much. But in the end it doesn’t take 64 MB to cause a crash of your serve.

Read More >

Log Buffer #132: A Carnival of the Vanities for DBAs

The 132nd edition of Log Buffer, the weekly review of database blogs, has been published by Lisa Dobson on the Oracle Newbies Blog.

Read More >

Hitting Oracle with a Hammer

Recently, I had an opportunity to participate in a database stress-testing exercise. The objective is to make sure the particular hardware can handle the expected load and also to test where the physical limit of the machine lies if we keep increasing the number of concurrent users. I searched for tools available out there. The open source Hammerora turned out to be excellent tool for the purpose of simulating a typical transactions load in any number of threads. It’s built with the Tcl scripting language and it can simulate a real workload with as many client user sessions as your system can handle. If you’re looking for an easy way to measure throughput performance of your database, keep reading.

Read More >
Page 47 of 64« First Page...10...4546474849...60...Last Page »