{"id":1376,"date":"2009-01-29T10:36:53","date_gmt":"2009-01-29T00:36:53","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/?p=1376"},"modified":"2009-01-29T10:36:53","modified_gmt":"2009-01-29T00:36:53","slug":"maximum-number-of-columns-hard-limit","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2009\/01\/29\/maximum-number-of-columns-hard-limit\/","title":{"rendered":"maximum number of columns (hard limit)"},"content":{"rendered":"<p>#define MAX_FIELDS\t4096\t\t\t\/* Limit in the .frm file *\/<\/p>\n<p>I should be able to remove this limitation soon. Although if you come anywhere near it, you probably have already lost (and written your own engine).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>#define MAX_FIELDS 4096 \/* Limit in the .frm file *\/ I should be able to remove this limitation soon. Although if you come anywhere near it, you probably have already lost (and written your own engine).<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[75],"tags":[],"class_list":["post-1376","post","type-post","status-publish","format-standard","hentry","category-drizzle-work-et-al"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-mc","jetpack-related-posts":[{"id":702,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/05\/16\/new-laws-to-limit-use-of-tv-recording-theagecomau\/","url_meta":{"origin":1376,"position":0},"title":"New laws to limit use of TV recording &#8211; theage.com.au","author":"Stewart Smith","date":"2006-05-16","format":false,"excerpt":"New laws to limit use of TV recording - Breaking - Technology - theage.com.au Not at all promising.","rel":"","context":"In &quot;life, the universe and everything&quot;","block_context":{"text":"life, the universe and everything","link":"https:\/\/www.flamingspork.com\/blog\/category\/life-the-universe-and-everything\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2041,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/06\/29\/enum-now-works-properly-in-drizzle\/","url_meta":{"origin":1376,"position":1},"title":"ENUM now works properly (in Drizzle)","author":"Stewart Smith","date":"2010-06-29","format":false,"excerpt":"Over at the Drizzle blog, the recent 2010-06-07 tarball was announced. This tarball release has my fixes for the ENUM type, so that it now works as it should. I was quite amazed that such a small block of code could have so many bugs! One of the most interesting\u2026","rel":"","context":"In &quot;drizzle&quot;","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":906,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/10\/18\/problems-with-tracker-and-why-im-back-to-beagle\/","url_meta":{"origin":1376,"position":2},"title":"Problems with Tracker (and why I&#8217;m back to Beagle)","author":"Stewart Smith","date":"2007-10-18","format":false,"excerpt":"If you have more than 8192 directories, it can't monitor them (max inotify limit) No search results access(), stat() and then lstat() called on *every* file that it's going to index... this takes a long time. Did I mention that search doesn't actually give you any results? Even when you\u2026","rel":"","context":"In &quot;GNOME&quot;","block_context":{"text":"GNOME","link":"https:\/\/www.flamingspork.com\/blog\/category\/gnome\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":446,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/08\/03\/fancy-shortcuts-to-mysql-bugs\/","url_meta":{"origin":1376,"position":3},"title":"Fancy shortcuts to MySQL Bugs","author":"Stewart Smith","date":"2005-08-03","format":false,"excerpt":"So Elliot Murphy is talking about QuickSearch shortcut for bugs.mysql.com which is quite useful if you use Firefox. However, I'm using Epiphany (which is based on the same rendering engine, but is a bit more GNOMEy - and besides, i've been using it for a while, i have all my\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":850,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/06\/27\/things-that-have-recently-stalled\/","url_meta":{"origin":1376,"position":4},"title":"Things that have recently stalled&#8230;.","author":"Stewart Smith","date":"2007-06-27","format":false,"excerpt":"compressed backup patch actually works rather well... and restoring from compressed backup too. need to modify the rate-limiting code though... may as well rate limit the writing of the *compressed* data stream... otherwise the option isn't nearly as useful compressed LCP patch well... the *restoring* of compressed LCPs.... can write\u2026","rel":"","context":"In &quot;life, the universe and everything&quot;","block_context":{"text":"life, the universe and everything","link":"https:\/\/www.flamingspork.com\/blog\/category\/life-the-universe-and-everything\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":63,"url":"https:\/\/www.flamingspork.com\/blog\/2003\/03\/13\/transactions\/","url_meta":{"origin":1376,"position":5},"title":"transactions","author":"Stewart Smith","date":"2003-03-13","format":false,"excerpt":"I'm thinking that I can easily do multiple FS ops in one transaction with some careful structuring of the journal. The only problem with this is the old problem of journal size. Unlike a normal journaled FS, with user transactions, we may be dealing with a lot more data in\u2026","rel":"","context":"In &quot;hons-project&quot;","block_context":{"text":"hons-project","link":"https:\/\/www.flamingspork.com\/blog\/category\/hons-project\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/1376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=1376"}],"version-history":[{"count":1,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/1376\/revisions"}],"predecessor-version":[{"id":1377,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/1376\/revisions\/1377"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=1376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=1376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=1376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}