MySQL Design

Budget $25 - $50 USD / hour
Bids 18
Average Bid $42
Status Closed


I'm looking for somebody who is expert in mySQL / Unix

I do have a website, which use database MySQL and i have ALTERED some table into InnoDB.

The server is powerful

Total processors: 24

Intel(R) Xeon(R) CPU E5-2620 0 @ [url removed, login to view]

32GB Ram

SSD Drive With Raid-1

Now, my current design need to have the operations on SQL to be done from Outside the server, we already linked another server via API and it's working .

But as more i have ( crons ) running on 2nd server the first server load get's up and start hanging

I have 2 tables in InnoDB which keep getting fragment as they do 1 update each 3minutes and each table have huge number of records .

The Indexing is not working as it was expected .

I'm looking at somebody who can check the server/sql design give advice's/edit to fix this .


Get Free Quotes For A Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • zillur00 Profile Picture


    Dhaka,  Bangladesh

    I define myself skilled in three categories: Programming, Database Design Administrator and Server Administrator and very good at SQL query. I have completed some projects very successfully relating to MySQL and SQL. As a programmer I works in PHP,UNIX scripting , SQL, MySQL and have an experience of about 8 years. I have designed and developed many MySQL databases and written SQL code (stored procedures, queries, triggers etc) for Oracle Database. I also wrote many Unix scripts and SMS applications for Telecommunications. I am also an Oracle9i certified professional. In addition, my work involves a lot of playing around with data and numbers, comparing and analyzing data and generating reports out of it. I have excellent skills in Regular Expressions, sed and awk. I can handle most data needs by using PHP/Shell/sed/AWK/perl/ and Regular Expression. I have great communication skills and impeccable English. I believe I am dedicated, discipline and honest.

  • datadiggers Profile Picture


    Barlinek,  Poland

    I make websites faster. I optimize for speed MySQL and Magento. I work ONLY on projects related to performance optimization. What I can do for You ================ - speed up Your website (1-2 second complete page loads), - optimize MySQL server (includes complete audit, query rewriting etc.) - make Magento super fast (1-2 second complete page loads), - improve Your GTMetrix or PageSpeed score to 90+/90+ or even 100/100, - install and configure Varnish, Memcached, Redis and more, - explain everything I'm doing with Your site/server, - provide work log and reports with list of all changes I've made. I also work on other types of optimization projects - PHP code optimization (with profiler), general HTML/CSS/JavaScript optimization projects. I'm also Java developer and I can speed up Your Java code too. I can set up and tune for best performance Nginx, Apache and MySQL clusters. I've worked with small, medium and huge databases (from 1MB to 100GB of data). Who I am ================ I always work with caution, making backups before touching anything else. I'm reliable person which will work on Sunday (if needed) to make sure that Your site is up and running. We can communicate through email, Skype, phone or Google Hangouts. My English is quite good (contrary to many other freelancers I didn't hire anyone to write this text for me). I never failed on any project and I have exceptionally high repeat hire rate (at least in terms of standards). How to NOT hire a freelancer ================ Even if You decide to not hire me consider those tips when choosing a freelancer - especially if You don't have much experience: - consider only freelancers who can finish their projects, the ones with 95%+ completion rate, - consider only freelancers with high repeat hire rate ( 20% or more) - if it's lower it means that his/hers clients were not satisfied with their work, - most reviews are SPAM and come from colleagues, - do not be impressed by green score (the one in 0.0 - 10.0 range) - it does not reflect how often freelancer fails on project, his ratings etc.

  • nsplit Profile Picture


    ATHENS,  Greece

    (Note: Guys, it is not possible to post EVERYTHING in my portfolio. Please feel free to discuss with me your case.) Many people say "I'm a 5+ years Linux expert.", but what does "expert" really means? I've been writing Linux shell scripts and I have been administrating Unix/Linux systems since I was 15. I have 15+ years of experience with *continuous* research in the latest technologies. - Wide experience in System Administrating BSD/Linux and all kinds of distributions. - Special Linux distributions development for servers & Embedded ARM,MIPS,x86 microcontrollers. - Device Manufacturing with special hardware and sensors. - Advance Networking , Tunneling, VPN. ===== - Wide experience in Web based applications, Web sites, e-shops, web interfaces of any kind. - PHP, HTML5, CSS, MySQL, Jquery, C, Shell scripting, Graphics design experience. ===== - VoIP applications experience (automations, security, prototype devices). - Video/Audio Streaming

  • nganpho Profile Picture


    Hanoi,  Vietnam

    I have 7 years programmer with C++, C#, Python and MySQL, two years programming with large systems. I have got experience in Linux and Unix system

  • alinaimi Profile Picture


    İzmir,  Turkey

    I am a talented and enthusiastic Assembly Developer ready to work on your jobs. I have good knowledge of Assembly, C Programming and C++ Programming as I have worked in these fields for many years. I have also have sound knowledge of CSS and Drupal as I have worked as a CSS Programmer and Drupal Developer. Now given an opportunity I would like to put in my best effort. I am ready to be hired by you.

  • elboukharimu Profile Picture


    Casablanca,  Morocco

    Now I'm on the top 10 in 10 millions freelancers on the database and SQL field. I work for seven years in a Canadian multinational IT services as a Technical Specialist, I can provide you a very good work, with the best quality and service before the deadline. I'm expert on : Cobol, JCL, DB2 (6 years) SQL (10 years) Visual Basic 6 (VB5,VB6) (3 years) ASP, VB dot net and C# (2 years) MS Excel, Word, Access (7 years) DB2, SQL Server, Oracle, Mysql, MS Access (7 years) Analysis, Modelling, Creating, Manipulating and Administration Databases (7years). I can teach and train you the databases and SQL modules I can speak and write Arabic, English and French

  • sergechernyavsky Profile Picture


    Kiev,  Ukraine

    ## BIO I have BSCS and 10+ years experience in Linux/Unix/FreeBSD servers administration. Have worked with wide range of software and protocols in areas that include: VoIP, ISP networking, web hosting, video streaming, Clustering, RDBMS etc. My primary field is redundant VoIP/Asterisk systems. I do consulting, solution design, implementation, support and troubleshooting. Goals are high work quality and customer satisfaction. I available via email\Skype\SMS\Phone Hourly rate: $40 ## Areas of Expertise **OS:** * **Linux(all kinds)** Expert * **BSD** Good * **Unix** Good **Programming:** * **Perl** Expert * **PHP** Expert * **C/C++** Patching * **JS** Average * **Java** Average * **ActionScript** Average * **Shell** Average * **HTML** Average **Hardware:** * **Routers** Fritz!Box, Cisco, DrayTec, Lancom, D-Link, Astaro * **VoIP cards** Sangoma, Digium, Nortel, Dialogic **Protocols:** * **Physical layer** Ethernet, ISDN, T1/E1, 802.11 * **Low-level** ARP, IP, TCP, UDP, ICMP * **VPN/Tunnelling** openvpn, GRE, IP-IP, L2TP, PPTP, IPSec * **Routing** RIP, OSPF, EIGRP, BGP * **VoIP** SIP, IAX, H323 * **Application level** DHCP, DNS, FTP, HTTP/HTTPS, RTMP, IMAP, NTP, NFS, POP3, SMB, SMTP, SNMP, SSH, TELNET, TFTP **Software:** * **Virtualization** Xen, Qemu/KVM, VirtualBox, OpenVZ * **VoIP/FoIP** Asterisk, SER, GNUGK, oh.323, IAXmodem, HylaFAX * **RDBMS** MySQL/MariaDB, PostgreSQL, Firebird * **DNS** pdns, BIND, djbdns * **FTP** ProFTPD, vsftpd, WU-FTPD * **Mail** Qmail, Exim, Sendmail * **AAA** Radius * **WEB** Apache, nginx, lighttpd, thttpd * **Streaming** FMS, Wowza * **Firewalling** IPtables, IPchains, IPFW * **Misc** Drupal, MediaWiki, GeoIP, Heartbeat, PVM, NFS, NTP, samba, Squid, sshd, Zebra, etc. **Advanced Techniques:** * **Virtualization** * **Load-balancing, High perfomance & High-availability clustering (VoIP, LAMP, etc)** *   * **Complex IVR and AGI scripting** * **Asterisk modules and related software patching/writing** * **RDBMS design** * **Advanced routing, Traffic queuing and Firewalling**

  • icodingtechno Profile Picture


    ahmedabad,  India

    We are an It company have existing since last 5 years. We have development center in India and are experts in mobile application development and website development. We will convert your virtual thoughts to introduce you to this technology freaking world and prove your identity. We have a very good experience in -iphone development -Android development -php -cms -windows phone development and other platforms also. we are here to change ur view for technology.. walk with us and see how world is changing as per ur thoughts

  • Eliteprog Profile Picture


    CPH1,  Pakistan

    .net Windows Azure Php & MySql SqlServer DotnetNuke Content writing Graphics Designing

  • deepgaf Profile Picture


    Kolkata,  India

    Euphorbia Infotech is a software development company headquartered in Kolkata, India. It was established in the year 2009. Euphorbia has grown rapidly expanding in terms of man power, office space and revenue. As a web design and development company we provide expert solutions in lots of areas. Combined with these expertises, we use advanced open source and proprietary tools to provide the cutting edge solutions that our clients demand. Some of the technologies and software that we work with. The primary focus of Euphorbia is to build dynamic, interactive websites using Web 2.0 technologies . WITH EACH PROJECT YOU WILL GET 30 DAYS OF FREE SUPPORT AS WARRANTY.