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

Displaying posts with tag: mysql performance (reset)

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...]
How to Kill Mysql Performance
+0 Vote Up -0Vote Down

Check out this SlideShare Presentation: How to Kill Mysql PerformanceView more presentations from techdude.



  [Read more...]
European Lunchtime Webinar: MySQL - Top 5 Performance Sins
Employee_Team +2 Vote Up -0Vote Down

Next Thursday Oracle University will be hosting a lunchtime webinar, between 13.00 and 14.00 CET, to help you better understand the common MySQL mistakes impacting performance that you should avoid.

 

Oracle's senior MySQL instructor and consultant Kai Voigt will review the MySQL "no no's" and advise on what simple solutions should be used instead. Kai will also provide an introduction to indexing, rewriting of queries, monitoring the use of temporary tables, and other things you should know about.

 

You can register …

  [Read more...]
European Lunchtime Webinar: MySQL - Top 5 Performance Sins
Employee_Team +0 Vote Up -0Vote Down

Next Thursday Oracle University will be hosting a lunchtime webinar, between 13.00 and 14.00 CET, to help you better understand the common MySQL mistakes impacting performance that you should avoid.

 

Oracle's senior MySQL instructor and consultant Kai Voigt will review the MySQL "no no's" and advise on what simple solutions should be used instead. Kai will also provide an introduction to indexing, rewriting of queries, monitoring the use of temporary tables, and other things you should know about.

 

You can register …

  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 57 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.