Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 60 10 Older Entries

Displaying posts with tag: mysql performance (reset)

MySQL 5.6.3 Performance improvements
+0 Vote Up -0Vote Down

 Mark Callaghan at facebook tested the test release of MySQL 5.6.3 and he has found some performance improvement with InoDB feature. Read below...

Mark tried two of the previews for MySQL 5.6.3 at http://labs.mysql.com/. His first attempt with the multi-threaded slave preview was not successful. Parallel apply on the slave is serial when the master does not also run 5.6.3. He said (I hope this changes as a typical …

  [Read more...]
Reduced contention during datafile extension
+0 Vote Up -0Vote Down

Another performance problem found by PoorMansProfiler
Innam rana said in his blog post on innodb blog:



InnoDB has an internal file system management module that primarily manages the space in the data files. One of the pain points was the coarse level of locking used when a data file has to be extended. More about this issue can be found …




  [Read more...]
When does InnoDB compress and decompress pages?
+1 Vote Up -1Vote Down


There are two sections for rows in the page format for InnoDB compressed tables. The compressed section has one or more rows and must be decompressed to access individual rows. The modification log has uncompressed rows and rows can be accessed without decompressing. The modification log is used to avoid decompressing and then possibly recompressing the compressed section on every row change. The buffer pool also has separate uncompressed copies of some pages so that every row read does not require a page decompression.


  [Read more...]
MySQL Cluster Architecture
+4 Vote Up -0Vote Down

Introduction:

MySQL Cluster is a write-scalable, real-time, ACID-compliant transactional database, combining 99.999% availability with the low TCO of open source. Designed around a distributed, multi-master architecture with no single point of failure, MySQL Cluster scales horizontally on commodity hardware to serve read and write intensive workloads, accessed via SQL and NoSQL interfaces.

MySQL Cluster's real-time design delivers predictable, millisecond response times with the ability to service millions of operations per second. Support for in-memory and disk-based data, automatic …



  [Read more...]
mysql optimizer Index strategy
+0 Vote Up -0Vote Down

If the table has a multiple-column index, any leftmost prefix of the index can be used by the optimizer to find rows. For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (col1, col2), and (col1, col2, col3). MySQL cannot use an index if the columns do not form a leftmost prefix of the index. Suppose that you have the SELECT statements shown here: SELECT * FROM tbl_name WHERE col1=val1;SELECT * FROM tbl_name WHERE col1=val1 AND …

  [Read more...]
Connecting to HandlerSocket with localhost vs. 127.0.0.1
+0 Vote Up -1Vote Down

Using Net::HandlerSocket, here are some fun numbers for a single connection (open & close). When connecting to “localhost”, here’s the strace: open("/etc/hosts", O_RDONLY) = 3 fcntl(3, F_GETFD) = 0 fcntl(3, F_SETFD, FD_CLOEXEC) = 0 fstat(3, {st_mode=S_IFREG|0644, st_size=187, ...}) = 0 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2b909a1a3000 read(3, "# Do not remove the following [...]

Partitions Performance with MySQL 5.1 and 5.5
+0 Vote Up -0Vote Down

Check out this SlideShare Presentation: Partitions Performance with MySQL 5.1 and 5.5View more presentations from Giuseppe Maxia.



  [Read more...]
10x Performance Improvements
+0 Vote Up -0Vote Down

Check out this SlideShare Presentation: 10x Performance ImprovementsView more presentations from Ronald Bradford.



  [Read more...]
MySQL Monitoring 101
+0 Vote Up -0Vote Down

Check out this SlideShare Presentation: MySQL Monitoring 101View more presentations from Ronald Bradford.



  [Read more...]
Top 20 Design Tips for MySQL Data Architects
+0 Vote Up -0Vote Down

Check out this SlideShare Presentation: Top 20 Design Tips for MySQL Data ArchitectsView more presentations from Ronald Bradford.



  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 60 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.