重启MySQL的正确方法
- font size decrease font size increase font size
- Print Email
如果你是从源码包安装的Mysql，那么系统中是没有红帽常用的servcie这个脚本的，
所以只好手工重启
有人建议Killall mysql。这种野蛮的方法其实是不行的，强制终止的话，可能会造成表损坏，损失是巨大的。
这里推荐安全的重启方法
$mysql_dir/bin/mysqladmin -u root -p shutdown
$mysql_dir/bin/safe_mysqld &
mysqladmin和mysqld_safe位于Mysql安装目录的bin目录下，很容易找到的。
/usr/bin/mysqladmin -u root -p shutdown
Last modified onSaturday, 05 January 2013 13:03
| ( ! ) Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 169 | ||||
|---|---|---|---|---|
| Call Stack | ||||
| # | Time | Memory | Function | Location |
| 1 | 0.0009 | 413856 | {main}( ) | .../index.php:0 |
| 2 | 0.0989 | 4718600 | Joomla\CMS\Application\SiteApplication->execute( ) | .../index.php:49 |
| 3 | 0.0989 | 4718600 | Joomla\CMS\Application\SiteApplication->doExecute( ) | .../CMSApplication.php:196 |
| 4 | 0.3142 | 12446696 | Joomla\CMS\Application\SiteApplication->dispatch( ) | .../SiteApplication.php:233 |
| 5 | 0.3149 | 12471216 | Joomla\CMS\Component\ComponentHelper::renderComponent( ) | .../SiteApplication.php:194 |
| 6 | 0.3156 | 12526544 | Joomla\CMS\Component\ComponentHelper::executeComponent( ) | .../ComponentHelper.php:377 |
| 7 | 0.3158 | 12555368 | require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ) | .../ComponentHelper.php:402 |
| 8 | 0.3241 | 12990776 | K2ControllerItem->execute( ) | .../k2.php:64 |
| 9 | 0.3241 | 12990776 | K2ControllerItem->display( ) | .../BaseController.php:710 |
| 10 | 0.3339 | 13715976 | K2ControllerItem->display( ) | .../item.php:78 |
| 11 | 0.3339 | 13715976 | K2ControllerItem->display( ) | .../controller.php:19 |
| 12 | 0.3384 | 14112344 | Joomla\CMS\Cache\Controller\ViewController->get( ) | .../BaseController.php:663 |
| 13 | 0.3403 | 14132712 | K2ViewItem->display( ) | .../ViewController.php:102 |
| 14 | 0.4119 | 17094696 | K2ViewItem->display( ) | .../view.html.php:742 |
| 15 | 0.4119 | 17094696 | K2ViewItem->loadTemplate( ) | .../HtmlView.php:230 |
| 16 | 0.4156 | 17274896 | include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ) | .../HtmlView.php:701 |
- Published in MYSQL
- Read 3308 times
| ( ! ) Notice: Only variables should be assigned by reference in /var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php on line 478 | ||||
|---|---|---|---|---|
| Call Stack | ||||
| # | Time | Memory | Function | Location |
| 1 | 0.0009 | 413856 | {main}( ) | .../index.php:0 |
| 2 | 0.0989 | 4718600 | Joomla\CMS\Application\SiteApplication->execute( ) | .../index.php:49 |
| 3 | 0.0989 | 4718600 | Joomla\CMS\Application\SiteApplication->doExecute( ) | .../CMSApplication.php:196 |
| 4 | 0.3142 | 12446696 | Joomla\CMS\Application\SiteApplication->dispatch( ) | .../SiteApplication.php:233 |
| 5 | 0.3149 | 12471216 | Joomla\CMS\Component\ComponentHelper::renderComponent( ) | .../SiteApplication.php:194 |
| 6 | 0.3156 | 12526544 | Joomla\CMS\Component\ComponentHelper::executeComponent( ) | .../ComponentHelper.php:377 |
| 7 | 0.3158 | 12555368 | require_once( '/var/www/vhosts/shan.info/httpdocs/components/com_k2/k2.php' ) | .../ComponentHelper.php:402 |
| 8 | 0.3241 | 12990776 | K2ControllerItem->execute( ) | .../k2.php:64 |
| 9 | 0.3241 | 12990776 | K2ControllerItem->display( ) | .../BaseController.php:710 |
| 10 | 0.3339 | 13715976 | K2ControllerItem->display( ) | .../item.php:78 |
| 11 | 0.3339 | 13715976 | K2ControllerItem->display( ) | .../controller.php:19 |
| 12 | 0.3384 | 14112344 | Joomla\CMS\Cache\Controller\ViewController->get( ) | .../BaseController.php:663 |
| 13 | 0.3403 | 14132712 | K2ViewItem->display( ) | .../ViewController.php:102 |
| 14 | 0.4119 | 17094696 | K2ViewItem->display( ) | .../view.html.php:742 |
| 15 | 0.4119 | 17094696 | K2ViewItem->loadTemplate( ) | .../HtmlView.php:230 |
| 16 | 0.4156 | 17274896 | include( '/var/www/vhosts/shan.info/httpdocs/templates/gk_publisher/html/com_k2/templates/default/item.php' ) | .../HtmlView.php:701 |