Consulting Training Blog Careers About Us Contact Us

MySQL Consulting

Discuss Project

Intertech delivers expert consulting on MySQL.  Our professionals help you:

  • Install, configure, and optimize MySQL on Unix and Windows from startup options to tuning the server using system variables to configuring the MyISAM and Falcon storage engines
  • Understand and optimize access MySQL from C, Perl, and PHP including compiling, linking, connecting to the server, handling errors, processing SQL statements and results sets, specifying connection parameters, and debugging
  • Administer MySQL including understand the MySQL Data Directory, the operating system constraints on database object names, factors that affect max table size, and the data directory for system performance
  • Understand internationalization and localization issues including configuring time zone support, selecting the language for error messages, and configuring the character set
  • Manage security including setup of access control and security, securing the install, preventing unauthorized network access, and use of the MySQL grant tables
  • Maintain logs including error, general query, slow query, relay, and binary
  • Understand MySQL syntax, naming rules, character set support, and creating, dropping, and altering databases and tables
  • Understand MySQL metadata
  • Select data across multiple tables via joins and unions
  • Implement transactions including savepoints and transaction isolation
  • Maintain referential integrity with foreign keys
  • Optimize and execute full text searches
  • Understand the MySQL data types including numeric, string, date, time, spatial, Boolean, null, and type conversion
  • Work with sequences including use of AUTO_INCREMENT
  • Implement stored programs including compound statements, stored functions, stored procedures, triggers, events, and security for stored programs
  • Optimize queries with indexes and leveraging the MySQL Query Optimizer with a focus on efficiently loading data, changing statement scheduling priorities, using delayed and concurrent inserts, using correct locking levels, and administrative level optimization
  • Outline a backup and maintenance strategy
  • Troubleshoot MySQL performance issues

Free One Hour Discovery Call?

Learn More About the Intertech Consulting Team

Free Resources

5 Common Mistakes on Software Engineering

Guide to Selecting & Working with an IT Consulting Firm

Guide to Becoming a Full Stack Developer

Meet Our Dev Center

Making any outsourced project work affordable

Recent Case Studies

Web Application for Tracking Attendance and Creating Reports

Provide Remote Diagnostics Using React & D3

Extracting More Value from Customer Data

Free One Hour Discovery Call?

Testimonials

Intertech impresses me as a company. I would recommend the individuals I have worked with and indeed the company as a whole because one can tell the results we have gotten are a combination of the company’s culture and the individuals capabilities.

Brian B