Byte-consult by Bitless

Beyond the bits

  • Home
  • About
  • Ask Me
  • Info
  • Code
  • About
  • Ask Me
  • Info
  • Code

Category: mariadb

Date:November 7, 2011Posted By:glennCategory:mariadb, mysql, Uncategorized

Tuning MariaDB 5.2 with Partitioned tables

If you want to set up a decent MariaDB machine with enough tables to seriously keep you awake at night thinking about backup/restore plans, you need to perform some additional setup to the stock MariaDB configuration file. I just started to load up a backup of a large database and once it had to create…

Read More

Date:September 23, 2011Posted By:glennCategory:debian, mariadb

MariaDB – ERROR 130 (HY000): Incorrect file format

We have had an issue the last 2 days with a table that apeared corrupt. Selecting from this table returns an error all the sudden. Since upgrading to MariaDB 5.2 a few weeks ago we had this twice. So far only moderated panic applies. I’ve never seen this since the start of this project which…

Read More

Date:August 7, 2011Posted By:glennCategory:Cassandra, CouchDB, Gazetteer, mariadb, mysql, OpenStreetMaps, PostgreSQL

PostgreSQL is cool

Hellow Postgres One of the things MySQL forced me into is looking for serious alternatives. Finding MariaDB was an amazing relief. But it’s still not all cake and cookies yet. I experiment a lot with OpenStreetMaps lately, a great project everyone of all makes should look into seeing what it can do for you and…

Read More

Date:June 23, 2011Posted By:glennCategory:mariadb, perlTag:mysql_backup.pl

MariaDB backup problem after turning off InnoDB

In my first post on this blog I try to explain how to run an efficient wordpress setup in terms of performance by going light-weight. Along the way I converted the wordpress database to the Maria database engine. I also explain how to change your tables from InnoDB to Maria. After having it switched off,…

Read More

Developed by Think Up Themes Ltd. Powered by WordPress.