Aaron JonesDevops at FarmCredit
Bio

Serial Actionpreneur. Enjoys mentoring youth in Entrepreneurial quests, contributing to Mastermind meetings, and giving talks on Business & Tech.


Recent Answers


Assessing your IO, Memory & CPU loads is the first step - Knowing where the bottleneck is, is helpful for suggesting strategy.
Often times joins are handy when you first create your DB as it pulls your data back in a tidy normalized result. As your data grows those joins can become troublesome because you are joining multiple large tables (meaning index lookups/loops through all the pertinent indexes), plus you can be bound to a single thread. Sometimes breaking that joined query into multiple queries that leverage separate threads as well as free up memory and the number of combined index's referenced at an instant between calls can be useful. I have not used Percona however, so it may have its own functionality that mitigates these concerns.


Contact on Clarity

$ 1.00/ min

5.00 Rating
Schedule a Call

Send Message

Stats

1

Answers

5

Calls


Access Startup Experts

Connect with over 20,000 Startup Experts to answer your questions.

Learn More

Copyright © 2024 Startups.com LLC. All rights reserved.