Optimize InnoDB Server / Improve application schema

Ditutup

Deskripsi

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, job application form web server mysql free, optimize linux mysql server, server magento optimize, install application virtual dedicated server linux godaddy, sample windows application workibg sql server, run php application using wamp server, net web application call sql server dts, sample application using sql server reporting services asp, sql server backup file convert mysql, iphone application rss feed server, optimize apache mysql server, windows application database 2005 server, server type sql mysql data transfer, iphone web application quicktime streaming server, access application forms sql server 2005, writing sql mysql, import sql mysql, sql mysql report mysql, mobile application net sql server, sql server parent child sql, smart device application upload file server, optimize large mysql database, osc optimize tables mysql, windows application samples sql server

ID Proyek: #12702699

19 freelancer menawar pada rata-rata $201 untuk pekerjaan ini

$222 USD dalam 10 hari
(95 Ulasan)
6.3
scriptphp87

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)
7.2
karunakartiwari

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)
6.1
fanninson45

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)
5.3
vipinharidas

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)
4.8
vinaysinghh

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)
5.0
OrangeTechsol

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)
4.1
ilmarsparols

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)
3.6
redssr

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)
3.2
ProfSoftStudio

++ 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)
3.3
hawkscodeuk

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)
2.6
israrsoft

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)
3.2
$277 USD dalam 5 hari
(0 Ulasan)
0.0
tsebro

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)
0.0
gaflarry

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)
0.0
$155 USD dalam 3 hari
(0 Ulasan)
0.0
borepstein

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)
0.0
ilatech

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)
0.0
hawkscodeaus

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)
0.0
InextureLLP

'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)
0.0