Tags | Domains | Searches | Statistics | Options | Advanced Search
|
Tags | Domains | Searches | Statistics | Options | Advanced Search |
Pythian Group Blog - Dec 28, 2007
Welcome to the 77th edition of Log Buffer, the weekly review of database blogs. This is the last Log Buffer of 2007. . . a time for looking back at the year, looking ahead to the next, and generally focusing on time …
Tagged: sql server, oracle, mysql, postgresql, group blog posts, log buffer
Pythian Group Blog - Dec 22, 2007
In the era of consolidation, storage has not been left out. Different systems are made to share the same storage boxes, fiber-channel switches and networks. Inside a typical storage box, we have front-end and back-end …
Tagged: oracle, virtualization, storage, io, qos, network, sysadmin, raid, san, shared, group blog posts
Pythian Group Blog - Dec 22, 2007
Welcome readers to the seventy-sixth edition of Log Buffer, the weekly review of database blogs. As I mentioned in LB#75, this is Yule Log Buffer, a special edition for the busy holiday season. In lieu of a full …
Tagged: group blog posts, log buffer
Pythian Group Blog - Dec 19, 2007
The “sla” in mysqlsla stands for “statement log analyzer”. This does a much better job than mysqldumpslow of analyzing your slow query log. In fact, you can sort by many different parameters — by sheer number of times …
Tagged: tool, profile, toolkit, mysql, optimize, group blog posts, explain, mysql toolkit, maatkit, mysqlsla
Pythian Group Blog - Dec 19, 2007
I gave this talk at the UKOUG, and I have received a few requests to post the slides online. Instead of just posting the PowerPoint I took some time to give the presentation again (internally here at Pythian) and this …
Tagged: oracle, memory, linux, top, sysadmin, swap, sga, group blog posts, vmstat, meminfo
Pythian Group Blog - Dec 18, 2007
Mind you this was actually written more than a week ago but I didn’t have time to review and upload the photos on time so sorry for this delay. I’m on the plane back to Canada and I’m extremely satisfied with the …
Tagged: oracle, presentations, conference, birmingham, group blog posts, ukoug
Pythian Group Blog - Dec 18, 2007
Today I’ve been checking out a new client environment. My mission is to figure out (cold) some of the characteristics of the queries being run, and particularly if they’re “good” or “bad”. In my arsenal of “tools I …
Tagged: tool, profile, toolkit, mysql, optimize, group blog posts, explain, mysql toolkit, maatkit
Pythian Group Blog - Dec 15, 2007
Hello everyone, We have several MySQL DBA openings, one in each of our offices in Ottawa, Boston, or Hyderabad, India. (Our Sydney office is doin’ fine.) Working at Pythian is different than working in-house or as a …
Tagged: job, boston, hyderabad, mysql, ottawa, opening, group blog posts, non tech articles, pythian, not on homepage, job openings at pythian
Pythian Group Blog - Dec 15, 2007
Welcome to the 75th edition (a.k.a. the Diamond Edition) of Log Buffer, the weekly review of database blogs. Let’s get things started with some views of the recently finished UKOUG Conference & Exhibition. On …
Tagged: group blog posts, log buffer
Pythian Group Blog - Dec 15, 2007
A friend of mine asked me: I’m hoping you can help me out with something — I’m trying to optimize a search feature. Since it uses a MySQL database, the search already uses the LIKE statement to get matches for a search …
Tagged: search, mysql, like, sounds like, match, group blog posts