June 19, 2013

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

…In my case here is the properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql…/java/mysql-connector-java.jar Example Schema CREATE TABLE `parent` ( `parent_id` int(10) unsigned NOT … SchemaSpy via crontab once you’re done. What are some ERD tools you use and …

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

Post: MySQL and Percona Server in LinkBench benchmark

May 8, 2013 By 18 Comments

…unsigned long, unsigned long, unsigned long, unsigned long, long, unsigned…In CPU-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , , ,

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

…I’m interested in testing – it is an insert-intensive workload (which is TokuDB’s…is closer to what I need). Tables looks like: CREATE TABLE `sbtest1` ( `hid` int(10) unsigned NOT NULL DEFAULT ’0′, `mid` int(10) unsigned…threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Post: How to recover table structure from InnoDB dictionary

April 22, 2013 By 4 Comments

…unsigned DEFAULT NULL, PRIMARY KEY (`NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 `NAME` is a human readable table name in…is regardless at what position primary key fields are defined in CREATE TABLE statement internally they always go first in…. Index id in our example is 1679: mysql> SELECT * FROM…

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

Post: High-Performance Click Analysis with MySQL

December 22, 2008 By 13 Comments

… there, it can change the lifecycle of your application in advance. What about partitioning in MySQL 5.1?  I know there are some… int unsigned not null, is_blue tinyint unsigned not null, clicks int unsigned not null, impressions int unsigned not null, …. primary key(day, ad, is_blue) ); What…

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

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…is true that InnoDB full-text search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text search, in… column called FTS_DOC_ID which is a BIGINT UNSIGNED NOT NULL with a unique index on… a time. If you try it, this is what happens: mysql> alter table dir_test_innodb ADD …

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

Post: MySQL Indexing Best Practices: Webinar Questions Followup

August 16, 2012 By 4 Comments

… thing you need to consider is string comparison in MySQL is case insensitive by default while…is a good practice. Normally I’d do something like CREATE TABLE LINK (id1 int unsigned not null ,id2 int unsigned…Trick “Unionizing Order by” described in presentation. Q: what is the impact on indexing to…

Filed Under: Insight for DBAs, MySQL

Post: Profiling MySQL Memory Usage With Valgrind Massif

January 9, 2013 By 3 Comments

…) is using, where (i.e. for what function) it was allocated, how it got there (a backtrace, please!), and at what point in time…_log_event(char const*, unsigned int, char const**, Format_description_log_event const*) (in /usr/local/percona/mysql-5.5.28/usr/sbin…_log_event(char const*, unsigned int, char const**, Format_description_log_event const*) (in /usr/local/percona/mysql-5.5.28/usr/sbin…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit

November 24, 2011 By 2 Comments

… think it’s a shame. What I have to found to be useful in the daily work is to have the ability to… 0x6A7D72: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long…==    by 0x6435EA: mysql_execute_command(THD*) (sql_parse.cc:2309) ==9090==    by 0x782C6D: sp_instr_stmt::exec_core(THD*, unsigned int*) (sp…

Filed Under: MySQL

Post: Connecting orphaned .ibd files

May 13, 2011 By 19 Comments

… first what’s going on and why InnoDB refuses to use suggested .ibd file. There is …is following: SYS_TABLES: CREATE TABLE `SYS_TABLES` ( `NAME` varchar(255) NOT NULL default ”, `ID` bigint(20) unsigned…CHKSUM 4 /* in < MySQL-4.0.14 space id the page belongs to (== 0) but in later versions the …

Filed Under: MySQL
« Older Posts