May 24, 2012

Post: Troubleshooting MySQL Memory Usage

I also wanted to share some troubleshooting techniques I use. Plot Memory Usage First I would like to see MySQL memory consumption plotted. Inoabout how memory is used. II‘m very hopeful future releases of MySQL, MariaDB or Drizzle bring improvements in this space allowing us to

Post: How Percona does a MySQL Performance Audit

future performance, scalability, ability to recover from disasters? We also want tome information about LVM devices, volume groups, and logical volumes. At this point, unless I‘ve seen something that I want to investigate further, I

Post: Distributed Set Processing with Shard-Query

to understand the performance: I will shortly release another blog post focusing on ICE performance at 20 nodes, but before that, I want tono data shipping, as only aggregated sets are sent over the network. In the future you will be able to

Post: State of MySQL Market and will Replication live ?

about future of MySQL Replication by Brian Frank and Arjen. I think it very interesting toto mention Web vs Open Source component here. I think there is an interesting split – some companies I talk to are committed tonowant to care about database and caching they just want their application to

Comment: Air traffic queries in InfiniDB: early alpha

… reasonably well up to about 1 million rows. …to LOAD DATA INFILE. cpimport separators: I wanted to let you know that you can specify another separator value to…varchar(250) column is no more wasteful than a… to MySQL to perform the aggregation. q4: For future reference,…. Please let me know what else I

Post: Give me 8 hours, and I'll help you build a better application

to archive or purge data that is no longer needed. Everybody wants to know how to deal…future, you are going to be very grateful that you have historical metrics toabout your application. All of the above are quite simple and fast to do once you’ve gone through the process a few times. I

Post: linux.conf.au 2012 roundup

to better serve us. This talk is merely an introduction. I also suggest you check out Anki if you want to improve your ability toto start learning! While it’s unlikely to be suitable for database workloads anywhere in the near future, II both know Greg and have talked to him about

Post: Monty unviels Maria and starts Blogging

me think it will be stabilizing rapidly, and the best thing you can do toto keep low profile about Maria (there was almost no…does not want distractions. Not to mention …to be transactional storage engine of choice for future MySQL. Again, Congratulations Monty, these are both great news ! UPDATE: I

Post: MySQL for Hosting Providers - how do they manage ?

I have written over a year ago about 10+ ways to crash or overload MySQL and since that people have come to meI have not seen significant changes in fresh our MySQL 5.1 GA or even something major on the roadmap for futureto know you stay up just because nobody wants