Advertisement
Guest User

Untitled

a guest
Mar 30th, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
  2.  
  3. MariaDB [mysql]> grant select on mysql.time_zone_name to cactiuser@locahost identified by 'cacti123';
  4. Query OK, 0 rows affected (0.00 sec)
  5.  
  6. MariaDB [mysql]> flush privileges;
  7. Query OK, 0 rows affected (0.00 sec)
  8.  
  9.  
  10. [mysqld]
  11. max_heap_table_size=48M
  12. max_allowed_packet=16777216
  13. tmp_table_size=64M
  14. join_buffer_size=64M
  15. innodb_buffer_pool_size=240M
  16. innodb_doublewrite=OFF
  17. innodb_additional_mem_pool_size=80M
  18. innodb_flush_log_at_timeout=3
  19. innodb_read_io_threads=32
  20. innodb_write_io_threads=16
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement