Innovatoria Web | Ideas and Solutions

Professional Web Design

Innovatoria team considers the specific needs of the clients, connected to web design and online marketing, in order to develop effective and attractive web sites. We offer complete solutions, which answer our clients’ requirements and improve their relations with business partners and clients.

Home arrow Useful arrow SEO (Search Engine Optimization) arrow MySQL Errors - ERROR MESSAGES
MySQL Errors - ERROR MESSAGES Print E-mail
HOW TO IDENTIFY THE REASON FOR A CERTAIN PROBLEM?

When you realize that you have problems with MySQL, first you must check if the reason for the problem is in some program or hardware.
If the problem has some of the below mentioned symptoms, most probably you have hardware problem.

1. Your keyboard does not work. The easiest way to check the keyboard status is by pushing the button "Caps Lock", which switches on writing with capital letters. If the lamp of the keyboard does not shine, most probably your keyboard doesn’t work and you must change it. The other possible reason is the case when your keyboard cable is unplugged and then you should plug it and restart your PC. If the problem remains, change your keyboard.
2. The mouse does not work.
3. The computer does not respond to pings.
4. Some programs, which are not connected with MySQL don’t work.

In order to eliminate such problems, try the following:
1. In all these cases you should check your cables and hardware. Check also if your PC has some installed patches or updates of the programs and operational system, which could solve the problem. Verify whether all the libraries are updated (like glibc for example).
2. If your keyboard is blocked you could try to fix it by logging your PC to another computer and execute the kbd_mode.
3. Study your system log-files (they are in the directory /www/logs), in order to detect the possible reason for the problem. If you think that the problem is in MySQL, you should study also MySQL log-files. For more information check the page about the log-files on dev.mysql.com: http://dev.mysql.com/doc/mysql/en/log-files.html.
4. If you think that this is not a hardware problem, then you should find which part of the software has caused the problem.Use Task Manager or other similar program for diagnostic and fixing of software problems in order to find out which program creates problems in your PC.  Verify whether you have exceeded the disk space limit, whether you have broken files or other errors, which interrupt the normal work of your computer.

After you have done all the enlisted actions and the problem still exists, you must send a bug report to http://bugs.mysql.com/, describing the problem clearly and comprehensively, its symptoms, etc., and also why you think the problem is caused by MySQL .

If you decide to send a bug report, first you must read the information on the link below:
http://dev.mysql.com/doc/mysql/en/asking-questions.html

Sources of information:
http://dev.mysql.com/doc/mysql/en/what-is-crashing.html

COMMON MISTAKES IN MySQL USE

One of the most frequent mistakes is the exceeding of the maximum number of requests to the database. In this case you receive the following message:
SQL Error : 1226 User 'username' has exceeded the 'max_questions' resource (current value: 150 000)

The maximum number of requests to the database for every user is limited up to 150 000 per hour. If this limit is exceeded MySQL starts to cancel the requests. In order to exceed the limit your site must generate a huge traffic of hundreds of thousands visitors per day. Usually the problem is not in the traffic, but in the non-optimized scripts. One of the possible reasons for overloading is the rotation of mysql_query in some inner cycle. The request counter restarts at every round hour.

The most frequent errors when using MySQL are described in the section Common Errors When Using MySQL Programs на http://dev.mysql.com/:
  •     Access denied
  •     Can't connect to [local] MySQL server
  •     Client does not support authentication protocol
  •     Password Fails When Entered Interactively
  •     Host 'host_name' is blocked
  •     Too many connections
  •     Out of memory
  •     MySQL server has gone away
  •     Packet too large
  •     Communication Errors and Aborted Connections
  •     The table is full
  •     Can't create/write to file
  •     Commands out of sync
  •     Ignoring user
  •     Table 'tbl_name' doesn't exist
  •     Can't initialize character set
  •     File Not Found
Links to the pages with similar description for each one of the problems and the ways to solve them are available on this address:
http://dev.mysql.com/doc/mysql/en/common-errors.html

List of MySQL Error Messages you can find on the following address:
http://dev.mysql.com/doc/mysql/en/error-handling.html

Information about MySQL Error Log File is available here:
http://dev.mysql.com/doc/mysql/en/error-log.html
 
< Prev   Next >

Polls

How did you learn about us?
 

Who's Online

We have 3 guests online