Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 46 6 Older Entries

Displaying posts with tag: rant (reset)

again, on benchmarks
+6 Vote Up -0Vote Down

Dear interweb, if you have no idea what you’re writing about, keep it to yourself, don’t litter into the tubes. Some people may not notice they’re eating absolute crap and get diarrhea.

This particular benchmark has two favorite parts, that go with each other together really well:

I didnt change absolutely any parameters for the servers, eg didn’t change the innodb_buffer_pool_size or key_buffer_size.


If you need speed just to fetch a data for a given combination or key, Redis is a solution that you need to look at. MySQL can no way …

  [Read more...]
Bad Web Developers Don’t Scale
+2 Vote Up -1Vote Down

Over the last 5 years, I’ve read so many articles about how X doesn’t scale. PHP, MySQL, SQL Server, Apache, you name it – everything gets a bad rap. Everyone has a different idea of scale and size, and sadly most people think their site with 1 million page views a month can’t handle the load because whatever technology they chose to use supposedly doesn’t scale.

Guess what folks – the problem probably isn’t the language you chose, or the database you’re using. Unless you’re actually big (many millions of pageviews per day), you can usually run just fine with a straight up LAMP stack on a few servers. The real issue is that your dev …

  [Read more...]
Blame it on MyISAM
+3 Vote Up -0Vote Down

I reviewed most of the changes from the v4 Google patch today. My head hurts now. During this review I checked whether bugs fixed in the patch have also been fixed in recent releases of official MySQL. I am happy that most of them have been fixed. But some changes will never be accepted, such as the one that added support for INF for FLOAT/DOUBLE columns.

The default value of sql_mode is the empty string. You probably want to change that before your applications come to depend on it. When it is the empty string, invalid values are coerced to valid values on INSERT …

  [Read more...]
Percona Performance AAR
+0 Vote Up -0Vote Down

So we've been there.

In my opinion the conference was a great success. Our presentation was not, but that's another story. Percona really showed what conferencing is about. Don't know about MySQL. It was behind the closed doors. Valiant guardians strictly watched that you didn't overhear a word of Sacred Knowledge. Hell, even to get to the Expo hall you had to pay $25 (that's right, you had to pay for watching advertisement) and surrender information about your private life, like your phone number and how you learned about the Expo.

read more

Oracle really….
+0 Vote Up -0Vote Down

Ummmmmfff…. wind out of my sails today. I believe their was an analyst who predicted this a year ago when Sun bought MySQL…. I wish I could find the article. I am going to head down to the UC floor and get a feel for what people are thinking… will post more as I get time.

highbase beta-0.9.4
+0 Vote Up -0Vote Down

Heavy testing, headphones with no music, lots of Sanchez Gran Reserva, headphones with Miles Davis, more testing, an updated Installation Guide, Charles Mingus & Eric Dolphy, and I still couldn’t get a Release Candidate out.

Well, such is the life of the multi purpose hacker. Other people are always finding out new purposes for you, which makes your free time aproach zero.

Does this mean that the release date of rc-1 will never come? Nah, I don’t think …

  [Read more...]
Fun with innodb stats
+0 Vote Up -0Vote Down

I scrubbed the SQL here to protect the innocent, but check this fun stuff out.  Working with a client who randomly started seeing huge spikes in CPU and disk activity on their server after weeks of seemingly running fine.  I tracked it down to a subset of long running queries.  These queries typically run in around a second per run, but out of the blue they started taking 600 seconds.

Here is the explain for the first query:



  [Read more...]
We need a better benchmark
+0 Vote Up -0Vote Down

Boy am I sick or what, maybe I should see a shrink or something.  What’s the first thing that runs through my head when I wake up on a Sunday morning?  Is it thoughts of family, the days events, happy thoughts or something pleasant non technical?  No.  Its that we need a better benchmark suite for MySQL and the open source database community as a whole.  Right now the staple of our benchmarking diet is sysbench and dbt2.  While both have served their purpose they are a bit long in the tooth and do not do a good job of truly capturing what end users are doing out their.  I mean sysbench uses a single table!   Where’s the join love.  Has anyone …

  [Read more...]
Darn Ec2 Latency!
+0 Vote Up -0Vote Down

Memcached puts    141075
Memcached hits    122696
Memcached misses  18329
Memcached Prefix:  29298
Memcached Get Total Lat 12222 (us)
Memcached Get Recent Lat 10925 (us)
Memcached Miss Total Lat 8490 (us)
Memcached Miss Recent Lat 5740 (us)
Memcached Set Total Lat 142 (us)
Memcached Set Recent Lat 65 (us)

12ms?  Really, I mean come on…. what are we using 10baseT?

at least it appears somewhat consistent.  …

  [Read more...]
We need to rid the world of “DBAs”
+0 Vote Up -0Vote Down

This may come as a complete shock based on the title of my website… but I have come to the conclusion that all DBA’s should be eliminated from all companies hierarchies. WHAT? Yep I do not think any company should employ a “DBA” ever again.

Before the mob comes and beats me up for heresy, Let me explain. The term and more specifically the job title “Database Administrator” is way to broad. More so then most titles in my opinion. In fact I feel it is an ancient description that does a disservice to most modern database professionals. I have seen titled DBA’s responsible for entire infrastructure stacks, and I have seen DBA’s who only know how to run SQL and perform backups. …

  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 46 6 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.