June 19, 2013

Comment: Open Source, the MySQL market (and TokuDB in particular)

May 10, 2013 By 13 Comments

… open source have some chances to survive with a proper business model. As you properly describe for MariaDB model is to…

Filed Under: MySQL Tagged With: , , , , , , ,

Post: Is your MySQL Application having Busy IO by Oracle Measures ?

January 8, 2012 By 1 Comment

… for this post I wanted to mention what James calls “Busy” Oracle database application when it comes to IO consumption: It… if you do. I believe we see more of applications busy from IOPs numbers, especially now when we easily can get… of CPUs we want to make sure these CPUs are busy and as such need to run storage powerful enough to…

Filed Under: Hardware and Storage, Insight for DBAs, MySQL

Post: How to use tcpdump on very busy hosts

April 18, 2011 By 17 Comments

… mk-query-digest with tcpdump on “very” busy hosts. You might be thinking, “very busy is a relative and unquantifiable term,” and… request. Back to the question of, “what is a very busy host?” In my experience, if you are getting even 5…

Filed Under: Insight for DBAs, MySQL

Post: Can having information public hurt consulting business ?

April 30, 2008 By 9 Comments

… the fact we keep information public can hurt our consulting business ? Lets keep aside for the moment amount of new business publishing this information brings to us but think it also …. In this case surely having such instructions public can hurt business badly. In other cases value could be access to the…

Filed Under: Events and Announcements Tagged With:

Post: Intro to OLAP

July 12, 2010 By 10 Comments

This is the first of a series of posts about business intelligence tools, particularly OLAP (or online analytical processing) tools using… plan on covering the following topics: Introduction to OLAP and business intelligence. (this post) Identifying the differences between a data warehouse… is BI? Chances are that you have heard the term business intelligence. Business intelligence (or BI) is a term which encompasses many…

Filed Under: Insight for Developers, MySQL Tagged With: , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… set: mysql: SELECT id, title, MATCH(title, body) AGAINST (‘arizona business records’ IN NATURAL LANGUAGE MODE) AS score FROM seo_test… | id | title | score | +——+———————————————————————–+——————–+ | 458 | Free Business Forms for Starting or Maintaining a Successful Business | 1.3383517265319824 | | 7112 | Download Idaho Tax Forms for….10: mysql: SELECT id, title, MATCH(title, body) AGAINST (‘arizona business records’ IN NATURAL LANGUAGE MODE) AS score FROM seo_test…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Death match! EBS versus SSD price, performance, and QoS

February 21, 2011 By 55 Comments

… then we have the percent of time the device was busy, and the average number of requests in progress at the…_cnc rd_rt wr_mb_s wr_cnc wr_rt busy in_prg …snip… 54009.9 sda3 32.6 1.1… the reasons I wrote the diskstats tool — you can understand busy-ness and utilization correctly. The %util that is displayed by…

Filed Under: Cloud and NoSQL, Hardware and Storage, MySQL

Post: Only Design What You Can Implement

March 26, 2007 By 1 Comment

…” like approach for web application development at least on business-development boundary. Business people would dream up some features for developers to… companies rather than big ones – sometimes speaking to developers and business people you would see very different performance metrics. For example…

Filed Under: Insight for Developers Tagged With:

Post: Estimating Replication Capacity

July 20, 2010 By 4 Comments

…_TIME is 446 second, out of this replication thread was busy (BUSY_TIME) 74 seconds which means replication capacity is 446/74… very aggressively can be an overhead especially if it is busy system with a lot of connections mysql> show processlist; +——–+————-+———–+——+———+——+———————————————————————–+——————+ | Id…

Filed Under: Insight for DBAs, MySQL Tagged With: ,

Post: A note about Pythian

April 17, 2008 By 4 Comments

… open and helpful even when it comes to somewhat competing businesses. Though he is of course right – for small companies as… much better. When I’m saying we’re somewhat competing businesses this is indeed only somewhat. Pythian focuses on Remote DBA… etc while we’re more focused on startups, small/medium businesses and “light” web companies. Pythian is able to provide services…

Filed Under: Events and Announcements Tagged With:
« Older Posts
Newer Posts »