… to know how MySQL scales as you add more memory to the server. Vadim recently benchmarked the effects of increasing memory and CPU… Virident, is that as you add CPUs and increase memory size, MySQL doesn’t scale as well as we would like, and… increase the utilization of the tachIOn drive, Vadim sharded the database into smaller instances and colocated them on the same machine…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… to, either individually as you add new data to the MySQL database or else periodically batch-insert data that has changed since… comparisons would not be meaningful. Since MemSQL is an in-memory database, you can get a lot of speed improvement because you… the webinar: We evaluated MySQL vs Solr. I was able to index all the data from the database into Solr and make…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… until a later date. For example, if a database isn’t owned by MySQL, you won’t have any problems until you… the database, it will fail. These things tend to happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL… pmp-check-unix-memory plugin checks for a single process consuming too much memory and/or for too little free memory in general…
Post: Flexviews is a working scalable database transactional memory example
May 19, 2011 By 3 Comments
… MySQL data sets. The tool is for MySQL, but the methods are database agnostic. A materialized view is an analogue of software transactional memory. You can think of this as database…
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…_scanblogpercona.commanual server_idblogpercona.commanual shared_memoryblogpercona.commanual shared_memory_base_nameblogpercona.commanual show_slave_auth_infoblogpercona.commanual skip_…
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
… memory consumption by various database operations is reasonable. For example if some INFORMATION_SCHEMA query were to take couple of GB of memory… memory allocation and help to get MySQL on the memory diet. It would be easy to extend QA suite to check for peak memory… able to limit memory usage by individual MySQL users or even track how much these users are using. Now as MySQL 5.6…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with multiple threads. Not all databases are architected this way; some have multiple processes that communicate through shared memory or other means. It… it were, it wouldn’t be a great OLTP web database too. MySQL replication is one of the core, fundamental features — and…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… replication ? Not really this is great solution which offers great MySQL Performance in many cases. It is good however to understand… using simple master slave replication ? – Small database size. Small meaning working set fits in memory. This reduces waste of storage, removes problem…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on … 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: 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 …0 0 0 0 0 0 0 # String: # Databases # Hosts localhost # InnoDB trxID 3BBF3B55 (1/0%), 3BBF3B5A …
