top of page
Rectangle 19 (2).png

SUPPORT / TECHNICAL ASSISTANCE / TROUBLESHOOTING:

Specialist in the sale of lenses online

Rectangle 27.png

01

Context:

The customer has a server dedicated to its MySQL database, with more than 2 million entries and is experiencing a period of heavy traffic following the launch of its activities. He has a read-only MyISAM table for user search queries whose performance he sees drastically degrading and wants to fix it very quickly and permanently.

Rectangle 27.png

02

Problem solver approach:

Development and testing of several approaches to optimize and improve the performance of searches on the concerned MyISAM table , including:

  1. reducing RAM size

  2. loading all MyISAM indexes in memory (RAM)

  3. the transformation of all VARCHARs into CHARs

  4. caching usage

Rectangle 27.png

03

Result:

Increased read performance by ~25% by fixing table data size (approach 3 -> FIXED CHAR).

Rectangle 27.png

04

Technical stack involved:

MysSQL, Linux

Use case spitzkop (17).png
Rectangle 20 (1).png
← Back | Next →
bottom of page