how to use percona-tookit to verify mysql data
Read this PDF : mysql_checksum
|Showing entries 1 to 6|
MySQL Tcpdump system : use percona-toolkit to analyze network packages
We can identify problem SQLs with high execution frequency.
With DBMON system and AWR system we can find problem SQLs in a special time (high frequency, occurs over a period of time)
View this PDF:
We can use iopp tool to monitor process io performance
download from github : https://github.com/markwkm/iopp
pid: The process id. rchar: The number of bytes which this task has caused to be read from storage. wchar: The number of bytes which this task has caused, or shall cause to be written to disk. syscr: Count of the number of read I/O operations. syscw: Count of the number of write I/O operations. rbytes rkb rmb reads: Count of the number of bytes which this process really did cause to be …[Read more...]
Today I read a nice article , which give a new design for mysql database . In this article , Author (Mr.lou) uses OneSQL (a branch of MySQL) for the whole test.
you can read from : http://www.onexsoft.com/?page_id=378
This article explain how to use mysql in seckilling scenario (especially for E-Commerce commany )
If you want to use transaction in RDBMS database, you must manual
start transaction and commit in the end of your operation.
So,commit will be cost of the total process, round-trip …
This Thursday (February 19th, 14:00 UTC), MC Brown
& Trond Norbye will give a MySQL University session on
Developing MySQL on Solaris. MC works on the
MySQL Documentation Team and has been involved with quite a few
Solaris things, for example porting MySQL to openSolaris. Trond
has been involved with many things, including openSolaris,
as you can
see from his blog.
For MySQL University sessions, point your browser …[Read more...]
The VM for Linux prefers system cache over application memory.
What does this mean? The best way I can explain is by
Imagine you have 32 GB of RAM
MySQL is set to take 20 GB of RAM for a process based buffer and up to 6M for the various thread buffers.
Over a period of time the box swaps. The only thing that is running is mysql and its memory size is around 21GB for resident memory. Why does swap grow when there is plenty of memory? The reason is when a memory alloc is needed (thread based buffer is tickled) the VM will choose to use swap over allocating from the system cache, when there is not enough free …
|Showing entries 1 to 6|