Optimize InnoDB Server / Improve application schema

I have a large database that uses MySQL Procedures & Triggers, and the application seems to be getting drastically slower and slower the more items that are in the database. The schema for the database (as well as the triggers & procedures) can be found in this folder: [url removed, login to view] . While adding items to the database, MySQL seems to utilize 100% of one core, and no more. Need someone to help improve the schema & speed up inserts on this database. Ubuntu [url removed, login to view] & MariaDB 10.1 are used.

Keahlian Administrasi Basis Data, Pengembangan Database, Linux, MySQL, SQL

Lihat lebih lanjut: optimize sql server table, optimize linux mysql server, server magento optimize, optimize apache mysql server, writing sql mysql, import sql mysql, optimize large mysql database, osc optimize tables mysql, sync sql mysql

Tentang Pemberi kerja:
( 0 ulasan ) Hendersonville, United States

ID Proyek: #12702699

18 freelancer menawar pada rata-rata $200 untuk pekerjaan ini

$222 USD dalam 10 hari
(95 Ulasan)

Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer https://www.freela Lagi

$222 USD dalam 7 hari
(99 Ulasan)

Hello Sir, Greeting for the day, Hope you are doing well We are Group of professional having more than 8 years’ experience in Windows/Linux Server administration , Website Hosting migration, Mail server configurati Lagi

$277 USD dalam 7 hari
(58 Ulasan)

SHOWCASE An experienced Microsoft Certified Professional with Database Programming and Administration skills across both MS SQL and Business Intelligence Development. Having the ability to take the technical lead in p Lagi

$155 USD dalam 3 hari
(10 Ulasan)

i am mysql dba having more then 10 yrs of experience....................................................................you can review my project comments . always perfect

$111 USD dalam 3 hari
(40 Ulasan)

Hi, I can help you to optimization . Please find my previous project reviews in the following freelancer profile link: https://www.freelancer.com/u/vipinharidas.html . Will complete the project quickly and perfectly. Lagi

$155 USD dalam 3 hari
(37 Ulasan)

Hello Sir, I have 4+ years’ experience of DBA work supporting Microsoft SQL server,MYSQL and Oracle DB's. I am already supporting 24*7 on call DBA support services. If you have any questions about my expertise o Lagi

$200 USD dalam 3 hari
(6 Ulasan)

This can be done within next couple of hours, the dictionary might have gone wrong, so ill probably need to setup a new schema, which then can be replaced.

$250 USD dalam 3 hari
(3 Ulasan)

Dear Employer, I would like to work on your project 1) what's the config of your server RAM and CPU 2) Are you using default settings of MySQL About myself https://www.freelancer.com/u/redssr.html

$180 USD dalam 3 hari
(8 Ulasan)

++ This is my job. I'm ready to begin now. Pm for me. Thanks Looking forward to hear from you, Feel free to talk about this interesting stuff, give us any questions you have to know more about us ;-) Thanks Oleg! P.S:: Lagi

$277 USD dalam 7 hari
(9 Ulasan)

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following skills Lagi

$200 USD dalam 3 hari
(1 Ulasan)

Hello there, Monali this side from India. Thank you for posting the project, I have studied your requirements I Have 8+ years of exp in the same field and I Have a great portfolio as well. Skills: - Asp.ne Lagi

$155 USD dalam 3 hari
(4 Ulasan)
$155 USD dalam 3 hari
(0 Ulasan)

Hello there, I believe I can help you out here. I have done some interesting things with MySQL: http://technonutsnbolts.blogspot.com/search/label/MySQL so this may be right up my alley. I have extensive pro Lagi

$155 USD dalam 5 hari
(0 Ulasan)

Hello, I am keenly interested in the job which you have posted. I am willing to start your work ASAP! I am expert in getting websites on top page of Google and other major search engines. This will help to increa Lagi

$200 USD dalam 3 hari
(0 Ulasan)

Hi, I'm a french software engineer, and I new to this website. I just create my compagny, and I develop software for compagnies. I worked for 10 years as a software developer, and for the last 3 years I worked with Lagi

$222 USD dalam 3 hari
(0 Ulasan)

'm a Cloud Services Expert with extensive experience of Network and Security Services, Migration Services, Architecture Redesign and Development on various popular platform such as AWS, Microsoft Azure, Google Cloud, C Lagi

$250 USD dalam 3 hari
(0 Ulasan)

Hi, After carefully reviewing your request, I am ready to help you with Technical Support because I have 15 years experience in system administration and programming. I would like propose partnership with our compa Lagi

$210 USD dalam 3 hari
(0 Ulasan)
$277 USD dalam 5 hari
(0 Ulasan)

The first thing you need to do is change all the varchar to char. This alone will speedup table reads and writes. I have been using MySql for many years. My largest databases are over 20 GB in size. Assuming you Lagi

$155 USD dalam 3 hari
(0 Ulasan)