… continue what we are doing: diagnose and solve the root problems our customers experience, and build new features to overcome limitations…-source database server and other software tools, with accompanying world-class services and support. We salute everyone who’s helping advance MySQL and…
Post: MySQL, AIX5L and malloc()
November 3, 2008 By 11 Comments
… database. Because we planed to use advanced virtualization with VIOS + LPAR/DLPAR I conceived the idea to use one spare partition for MySQL… run MySQL database on AIX 5L operating system. You compiled it successfully, configured and.. unluckily database didn’t start due to memory allocation problem…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… be highly variable. You can mask I/O problems on some workloads by making I/O not matter… you don’t need high concurrency from your MySQL database. When you do, the limitations on the core …However, the versions of MySQL that Amazon runs on RDS may not be the most advanced available. My benchmarks …
Page: Consulting for MySQL
July 31, 2006 By
…MySQL Replication Advanced MySQL Replication consulting including chained and circular replication, bi-directional replication, troubleshooting MySQL Replication performance problems. MySQL Operations and Administration Assistance with MySQL…
Page: Presentations
May 3, 2006 By
… up various things in MySQL as well as solve other performance related problems. Download Innodb Performance Optimization MySQL Users Conference 2007,… from other databases or other Storage Engines to Innodb this one is must read. Download Advanced MySQL Performance Optimization Tutorial MySQL Users …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…, even to think of things that seem “less advanced” than using a database. Sharding and Partitioning Sharding is inevitable if your write… can change the lifecycle of your application in advance. What about partitioning in MySQL 5.1? I know there are some… use traditional DW methods, like star schemas. The problem is that MySQL doesn’t tend to perform well on a data…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… you’ve been reading enough database related forums, mailing lists or blogs you probably heard complains about MySQL being unable to handle… your database as textbooks teach you… but when dealing with large data sets it could be recepie to disaster. The problem is… reasons elevating this problem in MySQL is lack of advanced join methods at this point (the work is on a way) – MySQL can’t…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… Rollback_transactions: 0 mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; …advanced query logging, would give the administrator powerful tool to almost effortlessly catch the users doing bad things on the database and point them to the specific problems…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…MySQL when it needs to log “not usual” queries like Events, Functions, Stored Procedures, Local Variables, etc. We’ll learn what problems… does not exist’ on query. Default database: ‘test’. Query: ‘insert into t VALUES… based replication. Knowing in advances how MySQL works internally can help us …
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
…but the info in a MyISAM table Advance the Innodb tablespace id by creating …MySQL was not complaining, the data was not available. An “alter table tablename engine=InnoDB;” would solve the problem…1 mysql -u root “create database if not exists filler;” while [ 1 ] do CURRENT_SPACEID=`mysql -u root…
