… well fitting in memory and Read Only one to simplify things and get more repeatable results without spending too much time on it…_5_6_10# sysbench –test=oltp –mysql-socket=/tmp/mysql_sandbox5610.sock –mysql-user=msandbox_rw –mysql-password=msandbox –oltp-table-size=1000000 –num…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… question during Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask… for memory available. innodb_additional_mem_pool_size This one does not really affect performance too much, at least on OS with decent memory allocators. Still you might want to have it 20MB (sometimes larger) so you can see how much memory Innodb allocates…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… difference is 3.000 times! It might be a bit too much as there are few completely uncached workloads but 100+ times… using indexes. In fact even MySQL optimizer currently does not take it into account. For In memory workload index accesses might be… dimention tables being small it would not slow things down too much. On other hand join of few large tables, which is…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… common question I guess is how much should I see performance improved in case I increase memory say from 16GB to 32GB… the load is going to be way too much IO bound anyway. Interesting enough because of MySQL scaling issues it is also possible… IO wait we typically do not expect to gain much by increasing the memory. This however have to be watched carefully. Performance…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… where most of the database fits in memory. These days we can get 64G of memory for pretty commodity prices and this… limited by space and how much data we can comfortably put in MySQL Instance without getting in too much trouble with backups etc – because… to show search results which does not require too much IO capacity or high in memory fit. For large number of applications optimizing…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… each thread (thread stack, etc)? Those take memory too. The query cache can use quite a … 100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) | …much, in my opinion. I think it’s far better to use a monitoring tool to watch the actual memory…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
…decide ether to grow system in MySQL+Apache pairs or split MySQL And Web Server and place them…is Web Servers memory. Getting certain amount of memory is pretty cheap, ie 4GB of memory per box costs… being commodity these days you should not worry too much about it, unless you have each page generated…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…up in the PROCESSLIST or will not take too much combined time in the logs to attract your …(“a”,1000000); select sleep(1); … Causes MySQL to “leak” 1MB of memory per second with no apparent good reason…LIST and you can’t really track how much memory was allocated for given session (or restrict this …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… too much autonomy. I must note in this aspect however DRBD goes on par with MySQL Statement Based Replication – it is also well too easy to use MySQL features which break replication. The… penalty DRBD introduce and do not use this option wast memory and CPU cycles on double caching. Even in this case…
