… and mysql and is also much faster (resilient in-memory database). It is 100% compatible with any browser (does not need anything client-side) and you can hack virtually anything the server send to the browser. I run it with heavy in-memory databases but you can use MySQL if you want to.
Post: Rebuilding MySQL with same options
April 8, 2010 By 4 Comments
…=/var/db/mysql‘ ‘–without-debug’ ‘–without-readline’ ‘–without-libedit’ ‘–without-bench’ ‘–without-extra-tools’ ‘–with-libwrap’ ‘–with-mysqlfs’ ‘–with-low-memory‘ ‘–with-comment=FreeBSD port: mysql-client-5.0.67_1′ ‘–enable-thread-safe-client‘ ‘–with-charset=cp1251′ ‘–with…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 3 Comments
… lack of these features in the MEMORY storage engine (also known as HEAP) in MySQL has been one of the long-standing… Igor Chernyshev of eBay implemented true-VARCHAR support for MEMORY tables for MySQL 5.0. Although this patch did not add the… MEMORY implementation has changed significantly with this patch–for the fixed-length records too. Default sysbench 0.4.12 schema, one client…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just… shared_memoryblogpercona.commanual shared_memory_base_nameblogpercona.commanual show_slave_auth_infoblogpercona.commanual skip_character_set_client_handshakeblogpercona.commanual skip_…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with… instance, which is listed as “High-Memory Quadruple Extra Large DB Instance: 68 GB of memory, 26 ECUs (8 virtual cores with… a table+index data size approximately twice as big as memory, so the workload should be somewhat IO-bound. My goal…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… which appeared in MySQL 4.0 Query Cache was designed to work with single core systems and relatively small memory amounts, both…. Query Cache Storage Engines MySQL Query Cache now stores queries in local memory, which is great however memory amount might be limited especially… directly from storage and only de-compress it on the client. Delayed Updates Delayed Updates is complement to delayed invalidation. In…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 …this information is to compare systems with different memory amount having same workload. You will often see…mk-query digest (I omit queries text for client privacy) # Query 1: 0 QPS, 0x concurrency, …
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 6 Comments
… the serial version as run by the native database interface (MySQL): mysql> select word, md5(word), md5(reverse(word)), count(*) from words2… in set (5.00 sec) Since the data fits in memory speed is near constant and the single threaded operation burns… only one dimension for the first example, just like the MySQL client. This will be a linear operation because Shard-Query has…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… information on the box’s hardware, including RAID controllers, installed memory, and so on in the boot output. In addition, at… the MySQL server. I mean, let’s just assume the physical hardware and the machine setup is fine, and the client has… might not be.) Or maybe the client is doing queries like “… WHERE client IN (SELECT id FROM clients)” which is a really bad…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… have seen this kill clients is in apps that do some sequential scanning and do not have enough memory for memcached.Â… what I have seen many clients do. Using this application I can then compare using MySQL to using MySQL + Memcached, and then to… have seen this kill clients is in apps that do some sequential scanning and do not have enough memory for memcached. For…
