i spent last night adding 75% of the next step for our
multi-threaded datanode.
and got new numbers...
the config is the same as earlier post, with the exception
that
MaxNoOfExecutionThreads=8
flexAsynch -ndbrecord -temp -con 4 -t 16 -p 312 -a 2 -l 3 -r
2
insert average: 461584/s min: 451928/s max: 474254/s stddev:
2%
update average: 533083/s min: 530950/s max: 537351/s stddev:
0%
delete average: 564388/s min: 559265/s max: 567143/s stddev:
0%
read average: 948954/s min: 937288/s max: 959262/s stddev:
0%
also tried using SCI instead of gigabit ethernet
flexAsynch -ndbrecord -temp -con 4 -t 16 -p 256 -a 2 -l 3 -r
2
insert average: 568012/s min: 550389/s max: 578367/s stddev:
2%
update average: 599828/s min: 598480/s max: 602175/s stddev:
0%
delete average: 614036/s min: 612440/s max: 616496/s stddev:
0%
read average: 1012472/s min: …
Visual database design is very essential. Almost every web application needs database. And by designing visual representation, relation of tables makes an developer easy to understand on the database. There are many tools to design database like DBDesigner, SQLYog. Recently I found another application that is called MySQL Workbench. It can be used to efficiently design, manage and document database schemata. After using it’s functionality, I found this is a really good tool for design database specially for MySQL.
It is available as both, open source and commercial editions. The Community (OSS) Edition is available from this page under the free software/opensource GNU General Public License (commonly known as the “GPL”)
[Read more]Our customers or prospective customers often ask us how we do a performance audit (it's our most popular service). I thought I should write a blog post that will both answer their question, so I can just reply "read all about it at this URL" and share our methodology with readers a little bit. This fits well with our philosophy of openness. It also shocks people sometimes -- "you're giving away the golden goose!" Not really. What you hire us for is our experience, not a recipe that anyone can follow.
A full performance audit is far more extensive than this article can cover, and might wander into Apache, networking config, caching layers, etc. Wherever the problem is, we'll track it down. I won't talk about that. That's not because I want to keep secrets from you. To the contrary, I'd love to share it all with you. But that's a huge job; it will take …
[Read more]INFORMATION_SCHEMA, in particular by favorite TABLES table is not only helpful to understand tables you have on the system, but I have also found it to be very helpful as a scripting language for variety of database administration tasks. It can be more straightforward compared to using shell or Perl when the operation is database specific.
For example if you would like to MySQLDump only Innodb table in one file per database you can do the following:
PLAIN TEXT SQL:
- mysql> SELECT concat("mysqldump ",table_schema," ",table_name, ">> ",table_schema,".sql") FROM TABLES WHERE engine='innodb' LIMIT 5;
- +------------------------------------------------------------------------------+
- | concat("mysqldump ",table_schema," ",table_name, ">> …
I'm not planning on a Part IV! :) I wrote these articles last summer and decided to post them to the blog so they didn't get lost.MySQL DBA & Programming Blog by Mark Schoonover
I'm not planning on a Part IV! :) I wrote these articles last summer and decided to post them to the blog so they didn't get lost.MySQL DBA & Programming Blog by Mark Schoonover
Introduction
Using the tools and techniques from Part II, we'll look at the
areas of Drupal that can be improved. We'll go over queries,
indexes and mysql configuration. This will be based upon loading
the home page only.
Initial Load
Looking at a single loading of the home page produces a total of
122 SELECT queries, 3 SET commands, and 2 UPDATES. Only 30
SELECTS are unique, so there's plenty of duplicated queries. The
slow query log contains 5 queries when the system is loaded with
10 concurrent connections for a 30 second period. The queries in
the slow query log could also be queries that are not using
indexes. We'll start with these queries first.
Slow Query Log
mysql» SELECT name, filename, throttle FROM system WHERE type =
'module' AND status = 1 ORDER BY weight ASC, filename ASC;
…
Introduction
Using the tools and techniques from Part II, we'll look at the
areas of Drupal that can be improved. We'll go over queries,
indexes and mysql configuration. This will be based upon loading
the home page only.
Initial Load
Looking at a single loading of the home page produces a total of
122 SELECT queries, 3 SET commands, and 2 UPDATES. Only 30
SELECTS are unique, so there's plenty of duplicated queries. The
slow query log contains 5 queries when the system is loaded with
10 concurrent connections for a 30 second period. The queries in
the slow query log could also be queries that are not using
indexes. We'll start with these queries first.
Slow Query Log
mysql» SELECT name, filename, throttle FROM system WHERE type =
'module' AND status = 1 ORDER BY weight ASC, filename ASC;
…
Adam has been in IT now for more than a quarter of a century, variously as a programmer, systems analyst, database admin and consultant. The first job Adam had was writing software for cash registers in assembler, and back end software in C and COBOL on UNIX. Adam is active in a number of open source projects and is the admin of dotProject. He now works in the web team which is responsible for maintaining the mysql.com web sites.
Introduction
This paper will outline my test environment, software used
and procedures for benchmarking and profiling. This process can
apply to both scaling up and scaling out architectures. Scaling
out will require a slightly different approach due to the fact
that the entire webserver suite and/or MySQL will be split across
multiple servers.
Test System
My test system is an AMD 2100 with 2GB RAM and single PATA
harddrive. (Stop laughing.) It has XAMPP 1.6.6 installed which
contains Apache 2.2.8, PHP 5.2.5 and MySQL 5.0.51a with
eAccelerator turned off. Drupal 5.7 and the devel module have
been installed. The test Drupal site contains 5000 nodes, with
50,000 comments, 5000 vocabulary and terms with a max length of
12. These first attempts at improving Drupal performance will be
done with Drupal core only. The only nonstandard module that has
been …