Category Archives: mysql

Speaking @ Percona Live in London Next Week!

Posted on November 13, 2011 by admin

A quick note, I am speaking at Percona live in London next week… its should be a rip roaring time. I have two topics I am speaking on. The first is on building a MySQL Data Access Layer with Ruby … Continue reading →

Posted in database, mysql | Tagged | Comments Off

Centos yum nginx php mysql

Posted on August 28, 2011 by admin

#rpm -import http://www.jasonlitka.com/media/RPM-GPG-KEY-jlitka #vi /etc/yum.repos.d/utterramblings.repo [utterramblings] name=Jason’s Utter Ramblings Repo baseurl=http://www.jasonlitka.com/media/EL$releasever/$basearch/ enabled=1 gpgcheck=1 gpgkey=http://www.jasonlitka.com/media/RPM-GPG-KEY-jlitka install mysql and php #yum install -y mysql-server #yum install -y php php-cli php-xcache php-mysql php-mbstring php-gd install EPEL，enable the add-on Packages RedHat #rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-3.noarch.rpm … Continue reading →

Posted in Linux, mysql, Nginx, php | Tagged , , , | Comments Off

Getting MySQL Core file on Linux

Posted on August 27, 2011 by admin

Core file can be quite helpful to troubleshoot MySQL Crashes yet it is not always easy to get, especially with recent Linux distributions which have security features to prevent core files to be dumped by setuid processes (and MySQL Server … Continue reading →

Posted in database, Linux, mysql | Tagged , | Comments Off

Deleting all current active tasks

Posted on August 27, 2011 by admin

FOG is “a free computer cloning solution” found at http://www.fogproject.org/. If your a seasoned user you will no doubt have groups setup so you may run commands on multiple machine without loading each one individually. In my scenario we have … Continue reading →

Posted in mysql | Tagged , | Comments Off

Innodb Compression: When More is Less

Posted on August 3, 2011 by admin

So Vadim posted on the MySQL Performance Blog about poor benchmarks when running innodb compressed pages.  I ran some tests a few weeks ago and did not see the same results as him and checked into my previous tests and compared them to … Continue reading →

Posted in database, mysql | Tagged , | Leave a comment

MySQL caching methods and tips

Posted on April 7, 2011 by admin

“The least expensive query is the query you never run.” Data access is expensive for your application. It often requires CPU, network and disk access, all of which can take a lot of time. Using less computing resources, particularly in … Continue reading →

Posted in database, mysql | Leave a comment

More on MySQL Error Messages

Posted on April 7, 2011 by admin

I wrote about MySQL Error Messages before and as you might guess I’m not very happy with quality for error messages it produces. Now I’m revisiting this subject with couple of more annoying examples I ran into during last couple … Continue reading →

Posted in database, mysql | Leave a comment

How to debug long-running transactions in MySQL

Posted on March 15, 2011 by admin

Among the many things that can cause a “server stall” is a long-running transaction. If a transaction remains open for a very long time without committing, and has modified data, then other transactions could block and fail with a lock … Continue reading →

Posted in Bug, database, mysql | Leave a comment

How Percona diagnoses MySQL server stalls

Posted on March 15, 2011 by admin

We receive many requests for help with server stalls. They come under various names: lockup, freeze, sudden slowdown. When something happens only once or twice a day, it can be difficult to catch it in action. Unfortunately, this often leads … Continue reading →

Posted in database, mysql | Tagged , | Leave a comment

Reset MySQL Password

Posted on March 8, 2011 by admin

If you are like me who tend to forget passwords almost every time, then this tip might help you reset your MySQL password just in case. To begin, you must have access to the server, one that can stop and … Continue reading →

Posted in mysql, Password | Leave a comment