• Total Source Code: 3
  • Latest Update Code: Jun 20' 14
  • Total Page : 1
  • You currently on page number : 1

Mysql Response too slow accessed from website

  • 2014-06-20
  • 244
  • mysql,resolve,slow,database

Is your MySQL really slow without actually being too busy?Does your scripts take very long time to connect to the database?Do you have lots of RAM, strong CPU, just a little traffic and despite that a very long database response time?Are you seeing connections with “unauthenticated user” while running show processlist in MySQL console?   if you show the proccess list on mysql server by Readmore

Import Large Database File Size

  • 2014-05-01
  • 559
  • dumping,import

Edit your php.ini or .htaccess with code below   php_value upload_max_filesize 120M //file size php_value post_max_size 120M php_value max_execution_time 200 php_value max_input_time Readmore

Dumping MySQL Database Using Command

  • 2014-04-16
  • 667
  • dump,phpmuadmin,database

this is the query line   mysqldump -u root -p DATABASENAME > Readmore