MySQL Index Analysis Tool

Back in January I posted a simple MySQL duplicate index finder tool. Because I read requests for such a tool on the MySQL Performance Blog I decided to open a new project on Google's code hosting service as well as a new blog to track it.

So if you are interested and maybe even want to contribute to it, go have a look.

Comments

Post a Comment

Popular posts from this blog

SAXParseException: -1:-1: Premature End Of File - Misleading error

Today I had to look at a piece of code a colleague had written, using my XPathAccessor class. She used it in a servlet which gets XML formatted requests. As those are generated by an external 3rd party tool we agreed on some XML schema definitions. Everything they send us needs to conform to its corresponding schema, each reply we send gets validated against a different set.In order to allow independent testing on either side, we provided a little test kit that allows testing our system without having to set up a servlet engine. Basically it just takes a file, reads it into a String and hands that to the handler.First it gets parsed without validation. This is necessary to find out which type of request we were send (the address is the same for all of them). After the root element is known, it will be read again, this time using the right schema to verify the request.Once that is done, some reply is put together and sent back to the client. So far, so good.When I looked at the code I …
Read more

Amiga 500 Restoration: A501 Memory Expansion

Image
The previous posts were mostly about cosmetics. This one is more technical, dealing with the repair and some preventative maintenance of the A501 memory expansion card. If you are curious to learn more about the retrobrighting of the computer’s case, don’t worry — I’ll get back to that at a later time.This is the third post in a series about restoring an Amiga 500 back to its former glory. Here are all of them so far. I’ll try to remember to update this in all related entry.2017-12-24: Amiga 500 Restoration2018-01-05: Retrobrighting I2018-02-05: A501 Memory Expansion2018-02-05: Mouse and Mainboard MaintenanceAmiga Memory — The BasicsWhen the Amiga 500 was first introduced, it came with 512KB of memory. That was already double the amount the original Amiga 1000 had, but still not a whole lot. Especially when developers started to get familiar with the audio and video capabilities of the machine, RAM became a limiting factor in what you could do. Merely copying a single floppy disk with…
Read more

Amiga 500 Restoration

Image
About 6 weeks ago I got the somewhat crazy idea to — just for fun — play some Amiga games. At first, my plan was to set up a Raspberry Pi 3 with an Amiga emulator, after stumbling across Dan Wood’s YouTube channel. Even though I even have a Pi 3 lying around unused at the moment, seeing Dan holding that Amiga 500 in his hands at the beginning of the video, I got all nostalgic and decided I could at least do a quick ebay search to see how much they go for these days.Turns out, I could get my hands on one, including a memory expansion card, mouse and power brick (and a brick it is!) for  just 60€. Turns out, I would end up spending quite a bit more in the end, but still it was (and still is) a fun experience.The whole story is probably way too long for a single post, so I may end up splitting this into at least two parts, but I feel it is necessary to write this down if only to remind myself about it in the future :-)This is the first post in a series about restoring an Amiga 500 back t…
Read more