Tag Archives: MySQL
MySQL Could not find first log file name
When MySQL shows the error “Could not find first log file name in binary log index file” it means that mysql is looking for a bin-log file that is not shown in the bin-log index file. This does not necessary mean the replication is completely broken. Continue reading
Restore MySQL replication after error
When you have a replication error that does not allow you to fix it as described in Fix MySQL replication error you need to repair it by restoring the replication completely. Continue reading
Fix MySQL replication error
When you setup replication you need to make sure that no other data is available in the slave that can cause the data to be inconsistent. But if you run into problems like I had, you might notice that the … Continue reading
Setup mysql master slave replication
MySQL server provides replication functionality to replicate data from a master server to multiple slave servers. The concept behind it is that there is one master server that allows read and write access and one or more slave servers that … Continue reading
WordPress performance tuning
While migrating from one server to a Amazon AWS i noticed a huge decrease in performance on the AWS instance. While the Wordpress blog took a second or so to load on the old server (dedicated server) the processing time went up to about 5-10 seconds for one page load. At first you might immediately think of the server as the bottle neck. But a slow server will just bring the problem to light. Continue reading
Is MongoDB always faster then MySQL?
This is another classic question you might have come across, but can this question simply be answered with a YES or NO? Well, I would not write about it if the answer was that easy! Continue reading
From what size of data MySQL is not performant any more?
Is this the right Question? Somebody asked me this question and I told myself to write about that topic. This questions are always lacking of of context, but there might be a correct answer. Usually you don’t reach the performance limit of MySQL very easily. Its the wrong questions you ask…
Continue reading
