… is not done automatically. Even more – the operating system error are often mixed with MySQL errors and in some cases error code… think you have some kind of strange file system/OS error until you run perror: [pz@sl1 ~]$ perror 150 MySQL error code 150… may or may not use same error codes for same kind of error complicating automatic handling. When we tested different transactional storage…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… ( Graph 1) reduces dataset and decreases the amount of IO operations. The benefit of small size is also that TokuDB can keep in… good practical usage of TokuDB for log analyzing and log reporting queries. By log analyzing I mean any kind of log producing application, it can be from simple apache logs put into mysql, application performance logs to…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… defined as the number of misses per unit of time, with the units of operations per second. The …result towards “this ratio looks great!” The second kind of time information you’re lacking is how …-all of MySQL performance, and people frequently obsess over it far out of proportion. But again, 99% of …
Post: Data mart or data warehouse?
July 15, 2010 By 14 Comments
…. (this post) Introduction to MDX and the kind of SQL which a ROLAP tool must generate …of data to the source tables. The goal of this methodology is the 100% accurate description of historical data from the operational…are ways in which can add some of these features to MySQL as well, but that is …
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… qucikly following one another are kind of worse because they explore many less tested code paths in MySQL and so problem potential is… use tiny script which moves out all MyISAM tables out of MySQL database directory, checks them with MyISAMchk and moves them back… nasty things may happen, not to mention such potentially multiple operation DDL statements as RENAME TABLE – these are most vulnerable. master…
Post: Percona Server 5.5.18-23.0: Now with Group Commit!
December 19, 2011 By 3 Comments
…and from the Percona Software Repositories). Based on MySQL 5.5.18, including all the bug fixes…users of Percona Server 5.5. See the Testing the Group Commit Fix blog post for the kind of…data dictionary mutex for the full duration of the import operation. This allows queries accessing other InnoDB …
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 2
October 16, 2009 By 8 Comments
… boosting performance of the application by buffer MySQL with memcached. Our test application is simple and requires only 3 basic operations per… performance! Using Memcached::Fast was kind of a mixed bag when looking at the benchmarks for mixing MySQL and Memcached in my tests… performance! Using Memcached::Fast was kind of a mixed bag when looking at the benchmarks for mixing MySQL and Memcached in my tests…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… goal of having more than 2 nodes, in fact an odd number is recommended in that kind of … the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL… splits from several slaves it still remains operational. Use with extreme caution even in master-…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…content here is applicable for any kind of virtualization technology (for example VirtualBox). …77c9da88-b965-11e1-0800-ea53b7b12451): 1 (Operation not permitted) at galera/src…mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql…
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
… makes sense for large number of applications. In fact using MySQL Replication for failover we’re operating with kind of similar situation, just with a lot less automation. The good question of course…
