MySQL Consulting

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