… easy to shoot yourself in the foot if you use it incorrectly. So how do you safely disconnect a replication slave? In short… fails. However, I don’t like the error message, specifically the ‘fix in config file’ part. What happens if we specify the… binary log file on the master, which is probably not what you want. So never set master-xxx variables in my.cnf…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
… caused by different alignment by default. Vadim – when you‘re saying “Original FusionIO” do you mean the first generation IoDrive ever released ? I think specific model number would really help to understand it. What I… seems like the lowest. Anyway results are truly amazing. It is great to leave at times when amount of IO you can…
Comment: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
…’m no sure what exactly do you disagree with ? My point is you publish with 8 threads and multiple of them because you are running… I understand you correctly. The point I’m making is what performance with low concurrency does matter and I’d like to encourage people not to start measuring performance at higher concurrency. Which of these do you disagree with ?
Comment: 10 years of MySQL User Conferences
April 13, 2013 By 6 Comments
… planet.mysql.com. He wrote how he likes my blogging and that he happens to …you meet me tomorrow morning (Tuesday) just before the keynote?”. Weird. Spent my sleepless jetlag night wondering what… would you please come sit with us? OK, sitting next to Giuseppe & Dups. “Just how do you pronounce your…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… far simpler and far easier to use. It’s basically what you expect from such a tool. Moreover, it has a really… options built-in, like other tools: –user, –host, –port, –password, –socket, –defaults-file. So now the command line is what you expect: pt… some options and clobbered others, resulting in no way to do repeated collections at intervals. Now –no-stalk means only that…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…. So why do I say that the graph is misleading? Obviously we can say that InnoDB is faster, but you should look… review different workload (which actually is closer to what I need). Tables looks like: CREATE TABLE `sbtest1` ( `hid` int(10) unsigned NOT… produces 4 INSERTs and workload is very write intensive. So what are results in this case: InnoDB gradually declines as data…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… any other of the MySQL branches/forks, you get to have these odd limitations. Why do I discuss the FRM file? If… specified what fields where on what screen for entering, as well as any constraints as to what could be entered. For example, if you… to enter in all the data! You could also have things like NEXT_NUMBER fields (what we know today as auto_increment), CASEUP…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…queue global status variable). Donor/Desynced nodes do not apply flow control, though they … make certification more expensive replication conflicts more likely and therefore time-consuming to the application….are two global status variables you can check to see what flow control is happening: wsrep…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…corrupt table with Percona Data Recovery Tool for InnoDB you need two things: media with records(ibdata1, *.ibd, … recover the table structure from InnoDB dictionary. Why do we need a new tool anyway? It is …a value. I’m not sure what `PREC` is used for. It sounds like a short from “precision”, but …
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…http://www.ebaydba.net/?p=101, and gives you an indication of the numbers of database … by saying this I will have started a likely flame war discussion. The purpose behind the …what are “connections” and what are “active connections” when determining a thread pool size. FYI, it was really hard to do…
