…Stack: openais Current DC: percona1 – partition with quorum Version: 1.1.7-… but I wanted to simulate the problem): [root@percona3 percona]# crm configure …config… [ OK ] Starting gfs_controld… [ OK ] Unfencing self… [ OK ] Joining fence domain… [ OK ] Starting Pacemaker Cluster Manager: …
Post: Picking datatype for STATUS fields
August 9, 2008 By 24 Comments
… not waste too much space. The other problem you may run into is slower JOIN performance especially for MyISAM Tables. Though it… byte for small sets so it is rather efficient. The problem with ENUM is adding new values using traditional way (ALTER TABLE… and has no problem with adding values to it, however it has also drawback of integer values not being self documenting and can…
Comment: Percona White Paper: Architecting SaaS Applications with XtraDB
October 18, 2010 By 3 Comments
… to 61 tables per join, and people want “tables” with more than 61 “columns”, which requires more than 61 self-joins of the EAV… said “The EAV model *usually* causes serious and immediate performance problems, and simply will not work for *many* types of applications… in frustration at the cost and effort required to work with the systems the non-engineers are boasting about. So although…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…how I do it using PHP: $placeholders = join(“,”, array_fill(0, count($params), “?”)); $sql = “SELECT *…s primarily the responsibility of developers to do self-review and peer review of application code… then see during testing where you have problems with input being interpolated in an unsafe manner. …
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
… more complicated than traditional MyISAM table locks. Let me start with some examples. First lets run SELECT Query: —TRANSACTION 12303, ACTIVE… will not see trx with id >= 12304, sees < 12301 As you can see in this case the query self joins the table so… are two separate beings. You almost never will run into problems with Innodb table level locks because innodb will only set intentional…
Comment: Picking datatype for STATUS fields
December 6, 2008 By 24 Comments
… or INT(2). But to attack the problem of self documentation, I just create a table with fields, and DBAs and DB users… meaning of those numeric values. Heck, they can even make joins with this table to get an understandable query result. What do…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… we can see more benchmarks. The big problems I see so far with this feature are ease of use and… to the user. HT: I favor self tuning. PZ: I also like self tuning in theory. But I really like… database (for example, if ORDER and ORDERLINE tables are joined to form a single table), it might make sense…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… then other transactions could block and fail with a lock wait timeout. The problem is, it can be very …run it in a loop with a 30-second sleep in between. Notice that it self-purges its own data…HOST FROM information_schema.innodb_lock_waits w INNER JOIN information_schema.innodb_trx b ON b.trx_id …
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
…Oops, we forgot to disable foreign key checking. No problem, right? Not exactly…. (root@localhost) [oops4]> set … table back into its former self unless you’re handy with a hex editor and have …bad enough when dealing with JOINs, but they can be an absolute nightmare when dealing with FKs. The …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…per second it may be the problem. The other way to look at… in InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one is quite … you can see IO bound workload with hit rate of 995/1000. ————– ROW OPERATIONS…. Values for “state” field are rather self explanatory. You can also see …
