Steps to make MySQL produce optimized results
» Identify the queries that execute slowly
» Watch for Opened Sql connections
» Carry benchmark test on Queries
» Execute queries with Explain statement to the performance of each queries
(more…)
Posts Tagged ‘MySQL datatype’
Jan
30
2009
MySQL – Steps for Better SQL Performance
Last updated: January 30th, 2009
Dec
29
2008
MySQL database optimisation series – Right MySQL Data type
Last updated: December 29th, 2008Numeric Data type in MySQL
Choosing the right data type can create significant improvement in application performance.
Many programmers/developers who opt to choose MySQL as the backend for their operations often fail miserably in choosing the most efficient data types. (more…)
- How to check if linux server can send out email via command line?
- Reverse DNS and Junk Email
- Linux: How to upgrade PHP from 5.1 to 5.2 in CentOS5?
- Linux: How to list or allow access to ports ?
- MySQL: ‘Access denied for user ‘root’@'localhost’ (using password: YES)’
- MySQL: How to stop, start or restart mysql?
- Linux: Case sensitive MySQL table names
- Apache: [warn] NameVirtualHost *:80 has no VirtualHosts
- JAVA: public class naming
- MySQL: Default collation latin1_swedish_ci (swedish case insensitive)
-
.htaccess
Apache
Apache installation
Apache Server
asterisk
cakePHP
CentOS
CGI
command prompt
Configuration error
CSS
Fedora
Gunzip
http
httpd.conf
java
jQuery
LINUX
Linux Beginner
linux notes
Linux Run Level
linux tricks
mplayer
my.cnf
MySql
Nagios
OpenVPN
Operating System
Perl
PHP
php.ini
PHP error
phpMyAdmin
RedHat
Run Level
SELinux
shell scripting
ssl
subversion
svn
ubuntu
virtual hosting
windows
xml
zend
