June 19, 2013

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

… Solr and Sphinx, do indexes stay up to date with changes (inserts, updates and deletes)? That’s … index may require reindexing the whole dataset from time to time. Mike W. asked: Q: If the Sphinx …-memory database, you can get a lot of speed improvement because you’re searching data without touching …

Filed Under: Events and Announcements, Insight for Developers, MySQL

Post: How much overhead DRDB could cause ?

June 2, 2008 By 4 Comments

… it is still not fixed in 5.1 to date. So this is the access pattern which is often …settings. So overhead can vary a lot depending on the speed of the disk subsystem and network. If you do … for requests. This means DRBD slow down things 3 times+ writes. There is nothing wrong with DRBD, it is …

Filed Under: Uncategorized Tagged With:

Post: Should we give a MySQL Query Cache a second chance ?

April 10, 2011 By 64 Comments

… we could track versions for tables (increment each time table is updated) and check whenever version …MySQL application do not need absolutely up to date data, something which is couple of seconds or…compression can compress results at faster than wire speed for 1Gb networks. Plus if we can get…

Filed Under: Insight for DBAs, MySQL

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

February 26, 2013 By 1 Comment

… can speed up bulk loading into an InnoDB FT index by declaring a column called FTS_DOC_ID at table creation time… us that we can keep our FT indexes up to date by setting innodb_optimize_fulltext_only = 1 and then running… | | | deleted_doc_count | 0 | | total_word_count | | | optimize_start_time | | | optimize_end_time | | | stopword_table_name | | | use_stopword | 1 | | table_state | 0…

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

Post: Using any general purpose computer as a special purpose SIMD computer

May 16, 2011 By 5 Comments

… operation over a set of integers or dates can be transformed into one or more ….00 sec) Since the data fits in memory speed is near constant and the single threaded …numbers are wall clock time (as calculated by microtime()), SQL execution time, and parse time, respectively. Actually performance …

Filed Under: MySQL

Post: Is there room for more MySQL IO Optimization?

January 3, 2013 By 11 Comments

… snippet: # Percona Toolkit System Summary Report ###################### Date | 2013-01-03 22:29:39 UTC… | physical = 1, cores = 2, virtual = 2, hyperthreading = no Speeds | 2×1200.000 Models | 2xIntel(R) Pentium(…increment: NULL Create_time: 2012-12-31 16:24:54 Update_time: NULL Check_time: NULL …

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

Post: Using index for ORDER BY vs restricting number of rows.

February 16, 2007 By 8 Comments

… which sorting can be performed on such as seller, price, date added etc. Such configuration often causes serious challenge choosing proper… rows to generate result. The speed difference between these two example queries is about 100 times so it may be quite serious… sorting and retrieval which I should explain in details some time in the future.

Filed Under: Insight for Developers Tagged With:

Comment: Thoughts on MySQL Replication

October 17, 2008 By 18 Comments

… gets properly inserted into the database successfully and timely? Or does it mean both? Clearly, a query … of order, but this is not optimized for speed or performance. It only takes one very long …is it more important to keep replication up-to-date in spite of slow queries? Granted, there might …

Filed Under: Insight for DBAs Tagged With: ,

Comment: Why MySQL could be slow with large tables ?

July 30, 2008 By 141 Comments

… every time you do an update actually uipdate bith table etc. (forget duplicating data as this is cheap enough) I want speed… in sinc or somthing, meaning search would be out of date by one hour – which I can live with in my…

Filed Under: Insight for DBAs Tagged With: ,
Newer Posts »