Showing posts with label MySQL. Show all posts
Showing posts with label MySQL. Show all posts

Tuesday, September 20, 2011

To Cache or Not to Cache That is the Question?? Memcached

Memcached is a technology that uses the HEAP stack to access data more quickly than disk I/O in a traditional MySQL database. This functionality is built into the enterprise edition of the MySQL Server.

In a Memcached Client, the tables that are most frequently used in a highly utilized database are inserted into memory of the Memcached Server where they are stored and queried from by the application layer. This is useful where the application is in high demand and data is considered a necessity for the user-base and performance is key to retaining users.

Financially Feasible

From a technical stand point, one can see that this technology would be a memory hog. However, that is an added benefit when considering performance and finances. Since it uses memory for speed, you could have one or more budget server(s) to handle your cached system. The CPU and HD is in less of a demand for Memcached to be enabled than a traditional database.

Wednesday, February 2, 2011

MySQL Temporary Table Bug ERROR #1137

Apparently you can not reference two temporary tables in 5.1 using a simple join.

I was trying to create test environment based on my tables so that I could have a place to advance on this stored routine. The MEMORY storage engine provided me the comfort of performance and the fact that

Saturday, May 22, 2010

MySQL MATCH AGAINST Query ERROR 1191

I came across this problem when I ran into a client who needed Boolean search functionality on his site. The previous query he had was using LIKEs to do the searching on 6 columns. I told him about using a new query that used FULLTEXT indexes and continued about the performance benefits and also overhead this might cause as their data changes overtime. Naturally, I gave him a cronjobs script that basically optimizes the table to help him with maintenance. The problem arose when I implemented the query (Match..Against) I kept on getting:
ERROR 1911 (HY000): Can't find FULLTEXT index matching the column list.

Monday, March 1, 2010

Validating by White List approval

White listing refers to having input compared to an approved list and then rejecting what ever isn't on it. Like when you go to a concert and you are trying to get backstage, if you're name isn't on the VIP list or you don't have a pass you cant get in. In this instance, your name is compared to the list of valid people allowed backstage. If your name doesn't appear you tossed aside. Sucks right but when your talking about building a web app it can be one of the methods that separate you from being attacked.

Friday, February 19, 2010

MySQL Replication Explained

One of the many features of MySQL to keep your database live and productive is MySQL Replication.

Note: this entry will cover asynchronous replication

So whats this technology all about anyways?

Replication is data that is reproduced in one or more locations. It consists of two or more servers, normally, in its simplest form, one master server and its slave server(s).