June 19, 2013

Post: Understanding the maximum number of columns in a MySQL table

April 8, 2013 By 5 Comments

… named UNIREG. UNIREG was a text-based program for entering records …fields, you were going to need more than one 80×24 screen to enter in all… called this due to either something UNIREG specific or it’s just …will use less space in the FRM than if you had one with ‘Y’ and ‘N’ and the other with…

Filed Under: MySQL Tagged With: , , , , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… configuration of InnoDB full-text search and discovered a little bit of quirky behavior; here, we are going to run some queries and compare the result sets. Our hope is that the one of two things will happen… restriction that just needs to be better documented or if it’s a limitation with the InnoDB FTS feature that will be removed in…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… was originally planning to cover everything I wanted to discuss with respect to InnoDB full-text search in this…to be the case (or at least not in the way that I had thought), so I will need to look through the source to figure out what’s going on there…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Shard-Query adds parallelism to queries

November 15, 2010 By 18 Comments

… not going to diverge into a discussion of how OLAP varies from OLTP, it suffices to …normal;font-style:normal;color:#000000;text-decoration:none;text-align:right;vertical-align:bottom;…or more shards, or if possible, I could add more CPU cores. Regardless, even with a single server Shard-Query will…

Filed Under: Insight for Developers, MySQL Tagged With: , , , ,

Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1

October 15, 2009 By 16 Comments

…to lookup up a row in another table based on a text…will focus on these same benchmarks in Tokyo tyrant. All to often people force themselves into using a database like MySQL with…to go into the database.” is often the battle cry. But hold on to your hat, I am going to…

Filed Under: Benchmarks, Cloud and NoSQL, MySQL Tagged With: , ,

Post: Percona XtraDB Cluster reference architecture with HaProxy

June 20, 2012 By 63 Comments

… If you want to use a different username or password, you have to modify them in the…text/plain Node is running. We will use xinetd to daemonize the script. If xinetd is not installed yet, you can install it with…, haproxy stats will show us that the all the threads are going to hit the c1 server….

Filed Under: MySQL, Percona Software, XtraDB Cluster Tagged With:

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

… love to share it all with you. But that’s a huge job; it will take many pages, and I’m not going to write… decide to continue on to a longer relationship with Percona, which is reasonably common; in that case you will establish a solid relationship with the… them in a text file. I’ll attach this text file to the issue in our CRM system so I (or someone else) can…

Filed Under: Insight for Developers Tagged With:

Post: Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 11 Comments

… certain columns only, or against all of them – the fewer results your full text query matches, the faster the query will be. That…, it is going to be a lot of work to do this. However with just a few hundred thousand records it is going to be much… that matched the full text search query. For few hundred thousand of matched records, checking attributes is not going to slow down performance…

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Post: Sphinx search performance optimization: multi-threaded search

January 16, 2013 By 10 Comments

…with 32 CPU cores and 16 disks, the maximum that is going to be used to…or the other. Seriously, if query is CPU intensive, it is only going to…will improve most types of search queries, there are some that aren’t going to…source src1p1 : src1 { sql_query = SELECT id, text FROM table WHERE id % 3 = 1; …

Filed Under: MySQL Tagged With: , , ,

Post: Heikki Tuuri Innodb answers - Part I

October 26, 2007 By 19 Comments

…favour database “self tuning” or prefer to expose tuning options to be available to the user. HT…text fields (needs more info) According to the documentation, InnoDB put first 768 chars of each text/blob in the page and will…are going to be common place. We’re considering buying 40 8-core boxes with…

Filed Under: Insight for Developers Tagged With: ,
« Older Posts