Category: MySQL

Use pv as your MySQL progress indicator

Photo of a bored dog in bed

There is only one relief for the pain of a long running command – a progress indicator, but commands only may or may not show their progress – and this is by design. They are good at one thing, and through regular pipes, the data

Posted in MySQL Tagged with: , , , , ,

Will ideas of the Massachusetts law spread?

On reddit, I found this article regarding a new law i Massachusetts that is to increase the security of personally identifiable information. If you have personally identifiable information (PII) about a Massachusetts resident, such as a first and last name,

Posted in MySQL, Open Source, Software design, Web Tagged with: , , ,

MySQL query/indexing tip

I originally learned about this MySQL shortcoming in the book High Performance MySQL, and luckily I remembered it for an issue that struck me today. I have two tables – one containing blog-posts, and one containing a record for each

Posted in LAMP, MySQL, Open Source, Performance