Do you need to find qps for peak hours not avg qps through mysql life.

The MySQL 5.1 offers new GLOBAL_STATUS information schema tables. These can be used to report certain performance metrics, such as the number of queries processed per certain seconds, NOT overall avg queries per second, Its good to know how much qps in peak hours.

http://forge.mysql.com/tools/tool.php?id=217

At OSCON in 2006, I followed sessions that discussed how open source companies would fare when big corporations come in. Back then there were only a handful of examples of big companies purchasing small open source companies. Three years later, we've witnessed MySQL AB get swallowed by Sun, only to have Sun be swallowed by Oracle. Now there are more open questions than ever and at least three versions of MySQL that are jockeying to continue the MySQL blood-line. Yesterday I attended talks by two of these groups and I have to wonder how the MySQL game will play itself out over time.

The first talk I attended was: "Drizzle: Status, Principles, and Ecosystem" where a number of Drizzle developers shared their thoughts about this project. …

I started my company about a year ago, but I’ve been doing consulting for a long time. In fact, my first job in the IT industry was working for a consulting firm. Before that, starting as far back as grade school, I was involved in a lot of volunteer civic and community service activities. I admire companies who get involved in their communities, or even outside of their communities, wherever help is needed.

As part of my business plan, I’ve put in place a policy of accepting one pro-bono consulting project per year. So far, I haven’t gotten any requests for free consulting work, so here’s my public shout out to let you know what types of services are available:

1. Speaking or Training. My specialties are things like advanced Linux administration and SQL, but I’m perfectly capable of delivering content for people who just need to know how the internet works, or want to …

I started my company about a year ago, but I’ve been doing consulting for a long time. In fact, my first job in the IT industry was working for a consulting firm. Before that, starting as far back as grade school, I was involved in a lot of volunteer civic and community service activities. I admire companies who get involved in their communities, or even outside of their communities, wherever help is needed.

As part of my business plan, I’ve put in place a policy of accepting one pro-bono consulting project per year. So far, I haven’t gotten any requests for free consulting work, so here’s my public shout out to let you know what types of services are available:

1. Speaking or Training. My specialties are things like advanced Linux administration and SQL, but I’m perfectly capable of delivering content for people who just need to know how the internet works, or want to …

In one of the servers we have an issue that happens to one of the servers that some itemsthat have the status of "freeing items" and "Sending data" are just stuck there, causing alot of locks on the server, and the load of the server drops to almost 0.The server then wouldn't restart, and the only solution is to kill the mysqld process, andfix the crashed tables that result from the kill.How to

The Daily WTF collects excellent tales from the real world. These days, the dismal dramatic sagas are often (at least in part) about mistakes involving databases; no surprise there, they’re so prolific…

Anyway, if you can learn from other people’s mistakes, that’s cheap and efficient education! I thought I’d share today’s edition with you: it’s called Death by Delete. Read and enjoy^H^H^H^H^Hlearn.

Business intelligence has been talked about for quite a while. Even today, while companies are looking to make budget cuts, some experts are saying that BI can be used to beat the recession.

When I hear about BI systems, the first thing that comes to my mind is a huge and expensive system that has very powerful servers, that sucks data from many sources and runs some intensive and even more expensive reporting suite. Since I had been involved in projects to set those systems up, I know that it can probably take around a year to complete.

So everyone is in fact thinking about saving money yet still being …

The ibdata file is too big 10GB, and actually we've only about 2GB (data+index) in innodb storage engine.How we can defragment this file and reduce it?How is this happened?By default the ibdata file created initially by (innodb_data_file_path = ibdata1:10M:autoextend) and auto extended by (innodb_autoextend_increment = 8MB) when it’s needed, and this file (tablespace) contain all innodb tables (

There appears to be much ado about Google Fusion Tables (GFT) threatening the database stalwarts like Oracle and IBM. Am I missing something? It appears to be less like a database and more like Google Docs’ Spreadsheet. The difference being that GFT replaces formulaic functions with bulk capabilities like filtering, aggregation and merging.

GFT appears to have no query capability, other than the ability to filter data. In other words, you can narrow the data down to what fits your criteria and then you can visualize that data. Instead of the formulaic "processing" you get from a database, you have the ability to aggregate data (combine disparate data), filter it (show stuff that fits your criteria) and then visualize it so that individuals can discern correlations and trends.

There appears to be much ado about Google Fusion Tables (GFT) threatening the database stalwarts like Oracle and IBM. Am I missing something? It appears to be less like a database and more like Google Docs’ Spreadsheet. The difference being that GFT replaces formulaic functions with bulk capabilities like filtering, aggregation and merging.

GFT appears to have no query capability, other than the ability to filter data. In other words, you can narrow the data down to what fits your criteria and then you can visualize that data. Instead of the formulaic "processing" you get from a database, you have the ability to aggregate data (combine disparate data), filter it (show stuff that fits your criteria) and then visualize it so that individuals can discern correlations and trends.