| |
|
|
| |
|
|
|
An interesting scenario that I came across today was the fact that if you use the same alias as the column name in a formatted string (using DATE_FORMAT) and you also use same alias in ORDER BY or GROUP BY clause then MySQL uses the string output of DATE_FORMAT to sort records rather than the actual date column... (more)
|
| |
|
|
|
|
|
| |
|
|
|
After reading about the query cache mutex contention, scalability issues on multi-cores, and several people recommending disabling query cache on multi-core machines. I decided to give it a try and disable it to improve performance and since I was also seeing a lot of "freeing items" states for my queries (mysql works on query cache for part of the time query is in that state)... (more)
|
| |
|
|
|
|
|
| |
|
|
|
According to Aspersa's user manual,
"Aspersa is a collection of open-source system utilities primarily designed to ease the work of Percona consultants. This manual is the primary documentation for Aspersa tools. Please contribute your improvements.".. (more)
|
| |
|
|
|
|
|
| |
|
|
|
According to maatkit home page,
Maatkit is a toolkit for users, developers, and administrators of open-source databases. It is high-quality, formally tested software that is well documented and has an active open-source developer community... (more)
|
| |
|
|
|
|
|
| |
|
|
|
Before we move on to making class diagram for this problem let’s discuss what is composition relation and how we use it, composition has a solid black diamond symbol... (more)
|
| |
|
|
|
|
|
| |
|
|
|
Purpose of this tutorial is to give you understanding of how to use generalization, include and extend relationships when making use case diagrams... (more)
|
| |
|
|
|
|
|
| |
|
|
|
Alright, like i said we will discuss a different scenario in this tutorial to further clarify the concept of association classes so here is the scenario... (more)
|
| |
|
|
|
|
|
| |
|
|
|
Unified Modeling Language (UML) is a standardized general-purpose modeling language in the field of object-oriented software engineering. The standard is managed, and was created by, the Object Management Group... (more)
|
| |
|
|
|
|
|
| |
|
Click here for more tutorials. |
| |
|
|
Home
News
Tutorials
Videos
Toolbox
Discussions
Help Forums
Search
Members
