Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /*
- Скрипт оптимизации MySQL БД
- */
- set_time_limit(0);
- $config = parse_ini_file('config.ini', true);
- $mysqlserver = $config['dbhost']; // адрес сервера MySQL
- $mysqldb = $config['dbname']; // имя базы данных
- $mysqlusername = $config['dbuser']; // имя пользователя базы данных
- $mysqlpassword = $config['dbpass']; // пароль пользователя базы данных
- mysql_connect($mysqlserver, $mysqlusername, $mysqlpassword);
- mysql_select_db($mysqldb);
- while (1) {
- mysql_query("DELETE from pages where `propslength`= 0 LIMIT 1000000;");
- if (mysql_affected_rows() == 0) {
- break;
- }
- }
- while (1) {
- mysql_query("DELETE from sapepages where `propslength`= 0 LIMIT 1000000;");
- if (mysql_affected_rows() == 0) {
- break;
- }
- }
- $res = mysql_query('SHOW DATABASES');
- while (list($dbname) = mysql_fetch_row($res))
- {
- mysql_select_db($dbname);
- $rec = mysql_query('SHOW TABLE STATUS');
- while ($data = mysql_fetch_object($rec))
- if ($data->Engine == 'InnoDB')
- {
- echo 'Processing ', $dbname, '.', $data->Name, ' ... '; flush();
- mysql_query("ALTER TABLE {$data->Name} ENGINE=InnoDB");
- echo "Ok.<br/>";
- }
- mysql_free_result($rec);
- }
- mysql_free_result($res);
- exit;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement