Да ви представя един проект който е реализиран с няколко съвременни технологии:
PHP, MySql, Bootstrap и малко JavaScript.
Понеже предстой спирането на любимия за всички goo.gl е време да работи върху своя шорт система за къси линкове.
Може да я намерите на: https://ilink.ooo защо е https, а сетете се де 🙂
А защо домейн с разширение .ООО ем щото се помни лесно и е готин.
Проверяваме броя като се логнем с root в mysql
|
1 2 3 4 5 6 7 8 |
mysql> SHOW VARIABLES LIKE "max_connections"; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 150 | +-----------------+-------+ 1 row in set (0.00 sec) |
стандарнто са 150.
Сега може да ги увеличим по следния начин
|
1 |
mysql> SET GLOBAL max_connections = 250; |
след това отиваме в конфигурацията на mysql – my.cnf
За Debian базираните системи обикновенно се намира в /etc/mysql/my.cnf
За CentOS и RHEL базираните системи обикновенно се намира в /etc/my.cnf
и добавяме следния ред
|
1 |
max_connections = 250 |
след което рестартираме mysql.
Резултата е
|
1 2 3 4 5 6 7 |
SHOW VARIABLES LIKE "max_connections"; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 250 | +-----------------+-------+ 1 row in set (0.00 sec) |
Качване на база през конзола
|
1 |
mysql -u USERNAME -pPASSWORD DATABASE < file.sql |
сетване с различен енкодинг
|
1 |
mysql -u USERNAME -pPASSWORD --default_character_set utf8 DATABASE < file.sql |
(PHP 4 >= 4.3.0, PHP 5)
mysql_stat — Get current system status
Warning
This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi orPDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
Example #1 mysql_stat() example
|
1 2 3 4 5 |
<?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); $status = explode(' ', mysql_stat($link)); print_r($status); ?> |
|
1 2 3 4 5 6 7 8 9 10 11 |
Array ( [0] => Uptime: 5380 [1] => Threads: 2 [2] => Questions: 1321299 [3] => Slow queries: 0 [4] => Opens: 26 [5] => Flush tables: 1 [6] => Open tables: 17 [7] => Queries per second avg: 245.595 ) |
|
1 2 3 4 5 6 7 |
<?php mysql_connect("localhost", "username", "password"); $array = explode(" ", mysql_stat()); foreach ($array as $value){ echo $value . "<br />"; } ?> |
Outputs something similar to:
Uptime: 698
Threads: 1
Questions: 4
Slow queries: 0
Opens: 19
Flush tables: 1
Open tables: 12
Queries per second avg: 0.5
MySQL „show status“ FAQ: Can you demonstrate how to use the MySQL show statuscommand to show MySQL variables and status information, such as the number of open MySQL connections?
I don’t have a whole lot of time today to give this a detailed discussion, but here is a quick look at some MySQL work that I did recently to show MySQL open database connections.
You can show MySQL open database connections (and other MySQL database parameters) using the MySQL show status command, like this:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
mysql> show status like 'Conn%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Connections | 8 | +---------------+-------+ 1 row in set (0.00 sec) mysql> show status like '%onn%'; +--------------------------+-------+ | Variable_name | Value | +--------------------------+-------+ | Aborted_connects | 0 | | Connections | 8 | | Max_used_connections | 4 | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_finished_connects | 0 | | Threads_connected | 4 | +--------------------------+-------+ 7 rows in set (0.00 sec) |
All those rows and values that are printed out correspond to MySQL variables that you can look at. Notice that I use like 'Conn%'in the first example to show variables that look like „Connection“, then got a little wiser in my second MySQL show status query.