June 18, 2013

Post: How Percona does a MySQL Performance Audit

…post that will both answer their question, so I …what is really being done. I want to look at it without polluting mywhat‘s left out is often more important than what‘s included. For example, the absence of skip-name-resolve is easy to miss, as is…months after Peter helped a client. Now, if Peter

Post: How Percona diagnoses MySQL server stalls

what conditions are observably abnormal when the problem occurs. Gather diagnostic data when the conditions occur. Analyze the diagnostic data. The answernamesis often to ask a more senior person to help. I ask people such as Peter

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

my webinar, I got many questions and I wanted to take this opportunity to answername as an argument. It will join the cluster, but won’t store or serve data. Q: Is the configuration file myis copied when you SST again. Q: Thanx Peter, I loved the webinar!  Especially the fact that that everything is

Post: How to load large files safely into InnoDB with LOAD DATA INFILE

… a lot of costs. To name a few: the big … without splitting the file? The answer lies in the Unix fifo… mentioned in LOAD DATA INFILE is /tmp/my-fifo, not infile.txt!… curves are roughly logarithmic, which is what you should expect for B… this is the undo log entries being written to disk. (Peter