Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 6

Displaying posts with tag: Strangeness (reset)

Dude, where is my memory?
+2 Vote Up -0Vote Down

"Kris, please have a look at our database. We are running a materialized dataset processor, and on a database with about 40 GB of buffer pool and a database size of 6 GB, we are observing swapping."

Now, that is interesting. The box in question has 48 GB of memory, and indeed, hardly 6 GB of data.

CODE:mysql> select 
 -> sum(data_length+index_length)/1024/1024/1024 as gb 
 -> from tables 
 -> where table_schema not in ('information_schema', 'performance_schema', 'mysql');

  [Read more...]
Enemy Action
+2 Vote Up -0Vote Down

"Hey, Kris! We got a connection surge on $IMPORTANT_MASTER, and a short activity drop preceding that. All other graphs are flat."


I am looking.
Continue reading "Enemy Action"

+0 Vote Up -0Vote Down

If you have a slave, that slave is probably running with the read-only flag set in the mysqld-section of your my.cnf. To be able to write to a read-only slave you need to be the replication SQL_THREAD or have SUPER privilege.

Since 5.0.16, it is still possible to execute CREATE TEMPORARY TABLE on a read-only slave, so CREATE TEMPORARY TABLE privilege also allows you to write to a read-only slave in a limited and controlled way.

If you want to process a lot of data in a temporary table, you are probably creating the temporary table without any indices, then INSERT ... SELECT data into it, and then ALTER TABLE ... ADD INDEX …

  [Read more...]
Test your backups
+0 Vote Up -0Vote Down

Today I had to migrate the mysql database of our BugZilla Installation from an old Server to a new installation. I discovered, that obviously nobody had exercised the restoring process in quite some time, because it aborted:#1062 - Duplicate entry '223' for key 1The problem was caused by the 'profiles' table of BugZilla, where all users are stored.
Continue reading "Test your backups"

Cluster FAQ
Employee +0 Vote Up -0Vote Down

Seeing the MySQL cluster FAQ always puts a smile on my face.
Little things amuse little minds, I guess.

Oy vey!
Employee +0 Vote Up -0Vote Down

Innobase, Oy!
Apparently, Oy is Finnish for Ltd. — ah, the possibilities are endless!

Showing entries 1 to 6

Planet MySQL © 1995, 2016, 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.