Reduce mysql server load jobs
My MySQL server is facing issues like high CPU usage and slow queries due to an incorrect configuration. I need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowle...
...streamline code execution. load testing and profiling to measure the impact of optimizations and ensure system stability under heavy usage. technical guidance and support to other team members on performance-related issues. Key Areas Affected: • Slow response times • High database load • Memory consumption issues It appears these issues are caused by: • Inefficient database queries, • Heavy server-side processing, • Inadequate caching mechanisms. Specific functionalities affected include: • User login/authentication, • Database queries, • Data processing/analysis. Ideal Skills & Experience: • Deep understanding of the Django framework. • Proficiency in database optimization techniques to enhance ...
is a Chinese language teaching web app. We want to show users sample dialog module on page load with sound. Right now, a user has to click anywhere on the page in order for the cartoon characters to speak. (You could try :) What we want is let sound play on page load. What we tried is to place the following code inside the <body> tag, but not work as expected. <script> ("DOMContentLoaded", function(event) { ('hi').click(); }); </script> We prefer not using jQuery if not necessary, as jQuery is not used at any other places in the application. The first correct solution will be paid.
I need a Linux Server expert who can help configure my existing Linux server with a self-signed SSL certificate. Ideal skills and experience for the job: - Prior experience in configuring Linux servers, specifically Apache - Proficiency in setting up SSL certificates, ideally self-signed - Familiarity with server security best practices - Ability to troubleshoot and resolve any issues that may arise during configuration. It's important that you have good communication skills as I would appreciate a clear explanation of the setup process. i currently have Plesk Desk Setup on my server NOTE We shall be connecting through anydesk as our server has alot of data
I'm looking for a seasoned server administrator to set up a dedicated server for container-based provisioning. My web application will be a JavaScript library-based app, such as Node, , or React. Key requirements: - Proficient in Linux server administration, as the operating system is not yet defined. - Experience with container platforms like Docker or Kubernetes since I'm yet to determine my preference. Operating System: You can use Ubuntu Server, CentOS, or any other Linux distribution of your choice. Web Server: Nginx or Apache HTTP Server. Git: Version control system to manage your website's source code. Node.js: If you're hosting static sites or using JavaScript-based build tools. Let's Encrypt: For SSL/TLS ce...
I'm in search of a top-notch developer with a minimum of 10 years of experience to modify my existing event booking ...Revamping the user interface: I want to modernize the website's color scheme and improve the navigation menu for more tailored user experience. * Developing new functionalities: I need your proficiency in integrating a booking calendar and a payment gateway to make the booking process smoother. * Boosting website performance: With my vision for an optimized website, I expect an improvement in website load speed and overall performance. Your creativity will also play a key role in the project, as I appreciate a team member who can suggest ideas to better enhance the website. Experience in UX/UI design, website performance optimization, and e-commerce platf...
need Simple live chat system between 2 users, no designing needed. 1. login using php 2. show list of users fetched from db 3. on clicking a user, initiate chat (if the other user not blocked the requested user) 4. the chat should be live, realtime. and the data to be stored in mysql db 5. option to block user should use php as backend and bootstrap as front end . you can use firebase budget AUD 50 and should be done today please don't bid and ask for more time and money
...with DesignBuilder/EnergyPlus being the suggested tool. The goal is to make it more energy-efficient and resilient to extreme hot weather events. This project will involve utilising an energy simulation tool - preferably DesignBuilder or EnergyPlus. Key Requirements: - The primary focus of the energy simulation should be on improving insulation and thermal performance - The final design needs to reduce energy consumption, lower utility costs, and ultimately improve indoor comfort Ideal Freelancer: - Strong background in architecture, mechanical engineering or building engineering - Extensive experience with energy simulation tools, particularly DesignBuilder or EnergyPlus - Proven track record in designing energy-efficient buildings Please include examples of your past work in...
I urgently need a professional who can access my Windows Server 2016 VPS and enable the execution of custom applications for me. Due to some technical problems, I am currently unable to open any programs. Key Responsibilities: - Access my VPS server and troubleshoot the issue preventing program execution - Enable the successful execution of the custom applications Ideal Candidate Should: - Have extensive experience with Windows Server 2016 - Be proficient in troubleshooting and resolving technical issues - Be able to work quickly and efficiently to resolve the problem ASAP Please reach out if you possess these skills and can assist me with this urgent task.
My MySQL server is facing issues like high CPU usage and slow queries due to an incorrect configuration. I need a professional who can help me optimize my MySQL server by fixing the file and optimizing all bad queries to reduce the high CPU usage and improve the query speed. Key Responsibilities: - Review and modify the file to optimize the server configuration - Identify and optimize all bad queries to improve query speed - Reduce high CPU usage by fine-tuning the server - Provide a detailed report on the changes made and their impact Access: - You will be provided with AnyDesk access to the server for optimization. Ideal Skills and Experience: - Proven experience in MySQL server optimization - Strong knowle...
need Simple live chat system between 2 users, no designing needed. 1. login using php 2. show list of users fetched from db 3. on clicking a user, initiate chat (if the other user not blocked the requested user) 4. the chat should be live, realtime. and the data to be stored in mysql db 5. option to block user should use php as backend and bootstrap as front end . you can use firebase budget AUD 50 and should be done today please don't bid and ask for more time and money
I'm in need of a sharp JavaScript expert with React Framework experience. The task is to develop a JavaScript function aimed at manipulating DOM elements for my custom web appl...with React Framework experience. The task is to develop a JavaScript function aimed at manipulating DOM elements for my custom web application. This function will be run in Chrome Console. Key Requirements: - The function should manipulate DOM elements within the context of a custom web application - It has to be designed to handle dynamic content which might be loaded into the page post initial load Ideal Candidate: - Proficient in JavaScript - Experience working with React Framework - Demonstrable expertise in DOM manipulation - Prior experience in developing scripts to handle dynamic content in w...
I'm seeking a professional who can provide detailed structural drawings and calculations for a residential building in Cold-form steel in Florid...Cold-form steel floors and walls (SEE PDF ATTACHED). Examples of wood, structural steel beams or similar will not be accepted. Drawings: Revit or Autocad Calculation as per any software from USA Key Requirements: - The drawings must be comprehensive, including: - Load calculations - Construction details. Ideal Skills and Experience: - Proficiency in creating detailed structural drawings and calculations - Prior experience working on residential projects, particularly in Florida - Strong understanding of load calculations and construction details - Ability to adhere to project timelines and deliver high-q...
I'm looking for a skilled video editor to work on a short video Only around 3 minutes. The main tasks a...full production as a 1 single video. There will be Text displayed in bottom left showing Name and Title or 2 people speaking for about 5 sec. This should not take you any longer than 1.5 - 2 hours. Zip File is in Google Drive you can download which is less than 1GB. Key Requirements: - Proficiency in video editing software - Experience with adding text or captions - Ability to work on audio to reduce background noise Ideal Freelancer: - Video editor with a portfolio demonstrating previous work on captions and noise removal - Attention to detail and a flair for modern design - Good communication to ensure the final product meets my expectations Turn around 24-48 hours B...
Looking to implement an Elasticsearch Cluster primarily for improved data management and search ability for my app. The system must cater to handling and analyzing large amounts of structured data. Ideal Skills and Experience: - Strong Elasticsearch expertise - The system should integrate efficiently with both Logstash and MySQL. - Previous experience in cluster management - Proficient in tweaking and optimizing performance of cluster and data management
Warning: This project is for advanced developers. Those that can read complex code structures - I mean it. You must be able to understand ReactJS but also understand a large existing project with little help from me. We're looking for a full-time programmer who is hard working, honest, and enjoys learnin...do you have? Read this job description carefully, as it serves as an indicator to me if you pay attention to detail. The project consists of connecting to a Drupal project via REST endpoints. We're saving data to the PWA using IndexedDB, encrypting sensitive data, and by default refreshing the UI only when there's new data via push notifications (which come from the server using Web Push API), we're also using Android to load the PWA. Is this somethin...
I require a skilled expert to install and configure CloudFlare on my IPTV server, with a focus on enabling the DDOS Protection feature. Requirements: - Expertise with handling and setting up CloudFlare, particularly in DDOS Protection - Proficiency in working with standalone Linux servers - Should have prior experience with IPTV server setups The successful completion of this project involves: - Correct installation of CloudFlare on Linux IPTV server - Proper configuration of CloudFlare’s DDOS Protection feature Please ensure that your bid includes your understanding and approach towards achieving these goals. Thank you very much.
I need an expert to assist in configuring a Linux VPS. The main purpose of this server is for database management specifically using MySQL. Key Tasks: - Configure a Linux (Ubuntu) VPS with optimal settings for database management. - Install MySQL and ensure it's fully functional. - Implement necessary security measures to safeguard the server and database. - Documentation of the process and any configurations made. The ideal freelancer for this project should have: - Proficiency in Linux (Ubuntu) server configuration. - Advanced knowledge of MySQL and its management. - Proven experience in setting up servers for database management. - Capable of implementing robust security measures to safeguard the server and database. - Ability ...
Seeking an expert to restore my website stored on an AWS server. The main goal is to recover lost data; specifically, substantial MySQL database information which unfortunately went missing. Key Skills and Experience: - Experience with AWS and MySQL is critical. - Proven track record of effective database recovery. - Proficient in database management and data retrieval. If you are adept in these areas and can ensure a successful recovery of my data, I would be interested in discussing further.
To ensure ongoing productivity within my operations, I'm in need of a talented Python programm...attention to detail - Knowledge or willingness to become familiar with Topaz Signature Pads. - Capture signatures from the Topaz T-LKB755SE-BHSB-R SignatureGem LCD 4x3. Simple gui with 2 buttons, start siging and save image. Image then shown in gui and saved in database. This are the available SDKs /software combine what you need i am on a windows pc with the topaz in front. Python is main but load or do what you need. The captured signatures should be saved in a format that's optimal for database storage and for use in official forms. The preferred database management system for storing these signatures is SQLite3.
...5 RECEIVE YOUR VOUCHERS Get Your Vouchers: Submit your proof of payment through our member portal. We will review it and issue your payment vouchers within 24 to 72 hours. The amount of each voucher corresponds to your monthly car payment, up to a maximum of $800 per month. STEP 6 USE YOUR VOUCHERS Apply Your Vouchers: Apply the vouchers to your future vehicle payments. This can significantly reduce your monthly financial burden, allowing you to save or spend on other important aspects of your life. STEP 7 FINANCIAL FREEDOM Enjoy the Benefits: Take advantage of the financial breathing room provided by our program. Like many of our members, you’ll find managing your finances easier, with less stress and more opportunities for savings or discretionary spending. SEE VIDEO--...
I'm in need of a professional PHP developer to manage back-end services and ensure interchangeability between server and users. Key responsibilities will include the development of all server-side logic, definition, and maintenance of the MYSQL database. This role also requires the optimization of the system for speed and scalability, as well as the integration of user-facing elements developed by front-end developers. The ideal candidate would have: - Solid PHP development experience. - Proficiency in MySQL databases and related operations. - Experience with User Management functionalities. - Expertise in Content Management operations. - Prior experience with Real-Time Data Processing. Your primary focus will be on: - Creating database schemas that rep...
...developer to troubleshoot performance issues and crashes my app is experiencing. Your job will include: 1. Debugging and Fixing App Crashes: - The app is crashing and displays various error messages. Understanding this behavior across different devices will be necessary in developing a solution. 2. Improving App Performance: - The app is showing signs of slow performance such as lagging, load time delays, and slow response. Optimization of these issues for a smoother user experience will be crucial. 3. User Interface Enhancement: - Address some user interface issues, this could be linked to current performance glitches. 4. Uploading the Refined App: - Once all issues are addressed, you will need to upload the updated and optimized app to my Google Play console....
Please read carefully the full project before bidding. I consider and read all bids and bidders. Don't waste my time with a fake bid to get me to message you (I will ignore your bid). This is a seed project with the potential of an ongoing projects. I have questions within the description to make sure it is fully read. Please answer the...effective) - Share a plan to develop and build the website using these AI powered (no code) I'm in need of a competent full stack web developer with a background (experience) in web development and integration. I prefer someone who keeps track and knowledge of recent advancement on using AI solutions (no code). Knowledge in JavaScript Node.js, Python, proficient in working with databases (e.g., MySQL, MongoDB) and APIs. Is there an AI so...
I need an experienced professional to move my existing website from its current subdomain to the live server on WHM. With missing specific information at this moment, it would be best if you are knowledgeable in various platforms such as WordPress, Joomla, or Drupal for versatility. Your responsibility includes: - Safely migrating the site without affecting the existing content - Assuring the website functionalities are working seamlessly after migration - Resolving any potential glitches after migration Essential skills: - Extensive experience in website migration - Familiarity with WHM - Proficient in WordPress, Joomla, and Drupal - Proactive in solving unexpected problems during and after migration - Strong communication skills Make sure to put forward any questions befor...
I need a skilled web developer who is proficient in HTML/CSS, JavaScript, and PHP to help transfer my custom coded website from the test server to the live server using terminal. Having deep knowledge in server migration, DNS and terminal operations is crucial for this task. The key tasks will include: - Safely transfer all site files and databases. - Ensure site layout and functionalities are consistent with the version on the test server. Please only bid if you are confident in your skills to prevent any downtime or data loss during the migration. Experience in similar jobs will be a major advantage.
I am in search of a skilled backend ...proficiency in Python, for a project that necessitates a relational database system for user authentication and authorization. Key Requirements: - Proficiency in Python: The project is built on Python, so the ideal candidate should have a strong command of this language. - Experience with Relational Databases: I am looking for someone with a background in working with relational database systems such as MySQL or PostgreSQL. - Security Conscious: Given the focus on user authentication and authorization, a strong understanding of security principles and best practices is essential. Additional Skills (preferred but not mandatory): - Experience with NoSQL or Cloud-based databases could be a plus, as these might be integrated into the project in t...
I'm in need of a skilled server administrator to manage my Linux server dedicated to web hosting. After moving to Dedicated Server AMD Ryzen 9 we have seen that the server goes down so often and we have to restart it. Key Responsibilities: - Ensure the server is running efficiently and troubleshoot any issues that arise - Manage and maintain the server's security, including setting up a firewall, implementing malware protection, and installing SSL certificates - Monitor server performance and make recommendations for improvements Ideal Skills and Experience: - Proficient in Linux server administration - Experience with web hosting servers - In-depth knowledge of server security measures, including firewall setup, malware ...
I need a skilled web developer who is proficient in HTML/CSS, JavaScript, and PHP to help transfer my custom coded website from the test server to the live server using terminal. Having deep knowledge in server migration, DNS and terminal operations is crucial for this task. The key tasks will include: - Safely transfer all site files and databases. - Ensure site layout and functionalities are consistent with the version on the test server. Please only bid if you are confident in your skills to prevent any downtime or data loss during the migration. Experience in similar jobs will be a major advantage.
The Panel must be developed in PHP8, developed with best practices using PSR. If developed with F...practices using PSR. If developed with Framework, Laravel (latest version + AdminLTE) must be used. All libraries used in the project must be in the public domain and if they are not properly updated, a new fork must be created and updated. Multiple user management is your permissions Manage multiple GRE Tunnels servers - Register, Update, Delete - Each GRE Tunnel server will receive a /40 or up to /29 IPv6 allocation. - Each server can deliver different sizes of IPv6 allocations (/56 to /29), in a configurable way. The professional to carry out this project needs the following characteristics: - Linux Systems Administrator - Network administrator - Extensive knowledge w...
Hi, I'm looking somone to edit my websoftware developped in php/mysql : Add : - field to attach a file per client - add account expiration date - Email notification - Link vehicles by API with our geolocation system
I am seeking a skilled draftsman who can provide structural and architectural drawings for my project. The job involves changing my sunroom's current flat roof into a gable one. This sunroom is medium-sized, approximately 11ft x 19ft. I'm looking forward to transforming this space. Ideal candidates should have experience in drafting for home renovation projects and have an understanding of load bearing design principles. Let's expand this space upward together!
I need an expert freelancer for the migration of my Trend Micro Apex One server. The current Apex One server, running the 2012 version, is located on-premises and operates with Windows Server 2012. Key Task Elements: - On-premises server migration. - Handling Trend Micro Apex One 2012 version. - Compatibility with Windows Server 2012. Ideal Skills: - Previous experience with Trend Micro Apex One Server Migration. - Expertise in handling on-premises server migration. - Ability to ensure seamless transition with zero data loss. - A deep understanding of Windows Server 2012.
I'm currently looking for an expert in hybrid machine learning models, specifically for the ARIMA, GCN, and LSTM components. Key improvements needed: - ARIMA: - Improved accuracy of predictions - Reduced computation time - Better handling of seasonality - GCN: - More effective inte...predictions - Reduced computation time - Better handling of seasonality - GCN: - More effective integration of graph structure - Enhanced extraction of features Skills and Experience Required: - Extensive knowledge in ARIMA, GCN, and LSTM - Proven experience in improving hybrid machine learning models - Proficiency in handling seasonality in data - Ability to work efficiently and reduce computation time. - Skilled in incorporating graph structure and improving feat...
I need a proficient expert to help establish, configure, and visualize data using a Power BI server. The data for visualization will be pulled from several resources such as SQL Server, SharePoint, Excel Spreadsheets, and Teradata. Key Responsibilities: - Setup and configure the Power BI server - Connect the server to mentioned data sources - Implement interactive data manipulation capabilities into the Power BI reports Ideal Skills and Experience: - Proficient in Power BI server setup - Experience with SQL, SharePoint, and Teradata - Excel data management skills - Competence in interactive data manipulation and visual analytics - Familiarity with report generation and data analysis Please note that this project requires an emphasis on interactive d...
...index for fromUser and toUser ({ fromUser: 1, toUser: 1 }); // Index for createdAt for sorting ({ createdAt: -1 }); ({ toUser: 1, createdAt: -1 }); = ('Chat', chatSchema); ` Requirements: Review and Optimize Aggregation Pipeline: We need you to review the existing aggregation pipeline and suggest improvements to reduce the execution time. Indexing: Assess the current index setup and suggest or implement changes to optimize the aggregation. Profile Database: Use MongoDB performance tools to identify potential bottlenecks and propose or implement solutions. Document Changes: Document any changes you make and provide recommendations for future improvements. Skills Required: MongoDB Mongoose Node.js Database Optimization
I need an experienced Node.js developer to create an automation script for my server deployment. - Automation Task: The script should automate routine server deployments, keeping my operations efficient and consistent. - Server Deployment Activities: The core function of the automation is to handle financial transactions, particularly trading activities. Proficiency in financial systems and trading platforms is necessary. - Financial Transactions: The successful candidate should also have experience with the handling of financial transactions within Node.js applications. The ideal candidate should have brilliant knowledge with Node.js, experience in automating server deployments, and a strong understanding of financial trading systems. Looking to kickstart t...
...Software Developer Freelancer who will help us with the integration of Stripe within our systems. We already configured Stripe and are currently using it for our subscriptions but manually updating the payments in our education management software where we manage students, tutors, schedules, and billing). The software developer will mainly need to focus on automating this existing process to reduce the total time we spend and complexity. * Responsibilities ??♀️ 1. Refinement and Planning Refining the integration scope based on the existing setup and automation requirements. 2. Developing the Integration Using Stripe’s API and our Education management system API to integrate the payments and automate the transfer of payment information from Stripe & bookings/Tr...
I'm seeking a savvy web developer with experience in optimizing server response time and page load speed for websites built in Node.js. My current website is facing performance issues. The primary areas requiring attention are: - Server response time - Page load speed The sections of my website significantly affected are: - Homepage - Checkout process An ideal candidate for this task will have a thorough understanding of optimizing Image sliders, as this feature is believed to be causing most of the slow server response time and page load speed. Proven experience in similar projects and knowledge in Node.js are essential for the success of this project. I look forward to enhancing website performance while maintaining our current functi...
As the owner of an existing Laravel website, I'm looking for...website: 1. **User Interface Design**: - Simplify the layout and navigation, making it easier for visitors to find what they're looking for quickly and efficiently. - Update our outdated color scheme and typography, turning it into a contemporary, appealing design that aligns with our brand identity. 2. **Performance Enhancement**: - Improve the website speed by aiming for faster page load times. This must be achieved without compromising the quality and functionality of the site. Proven experience in Laravel, web design, and performance optimization is a must. I expect you to use clean, optimized code that adheres to best practices. If you think you can turn my website into a modern, speedy platf...
I am in need of a MySQL expert to develop advanced queries for my database management tasks. Key Responsibilities: - Writing new queries: You'll be responsible for designing and implementing new, advanced MySQL queries. - Query Optimization: While the focus is on writing new queries, any optimization suggestions to existing queries are welcome. Ideal Skills: - Proficiency in MySQL: You should have advanced knowledge of MySQL language and its various functions. - Query Optimization: Experience in query optimization will be beneficial. This project is suitable for a MySQL developer with a proven track record in creating complex, high-performance database queries. It's important that you're able to work efficiently and effectively in order ...
I'm seeking an expert Laravel developer to replace the data page of my existing website, using the source code from my Laravel site. Your tasks will include: - Redesigning the data page based on my Laravel website's source code. - Improving server response times for better loading speed. - Executing leverage browser caching to optimize the website's performance. - Optimizing images to enhance load speed and overall site performance. - Incorporating search functionality into the new data page. Having experience working with Laravel is critical for this project. Knowledge of website optimization strategies is also highly beneficial. The ideal freelancer should have a proven track record of improving website speed and enhancing user experience. The success of t...
I'm looking for a freelancer who can help me increase sales, improve product visibility, and maximize ROI on my Amazon listings. Ideal candidates should have a deep understanding of Amazon PPC and listi...campaigns and listing optimization strategies. - Ability to understand consumer behavior and effectively target them. - Proven track record of increasing sales and ROI for similar products. - Familiarity with the latest trends and best practices in Amazon selling. - Strong data analysis skills to measure and interpret the results of the optimization efforts To provide ideas about new trending products Reduce advertising cost as much as possible and increase sales for money that we are spending. Please share your relevant experience, and how you plan to tackle these goals in...
I'm seeking a proficient Full Stack Java Developer to create a web application. Even though I haven't specified the use of certain frameworks, familiarity with Spring Boot, Hibernate, and Angular will be useful. Your primary role will focus on: - Developing a highly responsive web application from scratch. - Implementing MySQL as the preferred database management system. Candidates who have prior experience in full-stack development and database management using MySQL are highly desirable. This is a project that demands robust technical skills, so a sound understanding of various Java frameworks and web application development is essential.
Need website speed fixed on both Desktop and Mobile. SCORES MUST BE BASED ONLY ON GOOGLE LIGHTHOUSE SCORES ONLY Scores are currently ~55 Mobile and ~ 67 on PC. Need Mobile: 90+ Score Need PC: 80+ Score Load times are terrible and must be under two seconds globally on any page. Must not effect the website functionality or looks. Testing must be done on your own staging site as to not disrupt the live website. Message me for link to website. Budget $100
I'm urgently seeking a WordPress expert to help me with my site. I'm currently experiencing error messages whenever I try to load the website. This issue is critically impacting the site's functionality, rendering it completely inaccessible. I need someone who can promptly identify and resolve the root cause of these error messages. The ideal candidate should have: - Extensive experience in troubleshooting WordPress errors - A proven track record of quickly and effectively resolving critical site issues - The ability to communicate clearly and provide updates on progress - Excellent problem-solving skills - Availability to immediately start working on the task Your efforts will help to ensure the site is back online and functioning as soon as possible.
I'm in need of an experienced electrical engineer with expertise in power systems and circuit design. I'm l...have a flyback converter developed that can meet the following specifications: - Input Voltage: 24 V DC - Output Voltage: 3 V - Load: 5 Ω - Output Current: 1-3 Amps - Load-Voltage Variation: < ± 3% The primary objectives of this project are to achieve a high level of efficiency and to ensure the device can deliver a consistent 3V to the 5 Ω load, while also being able to handle variations within the specified range. Ideal candidates for this project should possess: - Proven experience in designing flyback converters - Proficiency in power systems and circuit design - Ability to optimize for high efficiency - Experience in delivering stabl...
I need a skilled Java developer specializing in back-end development who can use MySQL as their database technology. The main task for the developer is to work on API development, ensuring the smooth transaction of data between the server and our end users. Ideal Skills and Experience: - Proficient in Java and backend development - Extensive experience with MySQL database technologies - Experience in API development and management
