블로그
- Why SELECT COUNT(*) FROM TABLE Is Sometimes Very Slow in MySQL or MariaDB https://www.percona.com/blog/why-select-count-from-table-is-sometimes-very-slow-in-mysql-or-mariadb/
- old_passwords=1 에러시 비번 재 설정 방법 old_passwords=1 에러시 비번 재 설정 방법 PHP Warning: mysqli_connect(): (HY000/2000): mysqlnd cannot connect to MySQL 위와 같이 나올경우 mysql root로 접근후 1. use mysql 2. SET old_passwords=0; 3. .......
- Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. and manual loading of the driver class is generally unnecessary. ■ 내용 - MySQL 연동 시, 버전에 따라 Driver 값이
- Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons/ 톰캣 lib 폴더에 commons-pool-1.5.6 를 넣으니 없어졌다 다행 이 에러는 mysql 연동건에 대해서 나타나는 에러라 한다.
- The server time zone value '���ѹα� ǥ�ؽ�' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utiliz The server time zone value '���ѹα� ǥ�ؽ�' is unrecognized or represents more than one time zone. String url="jdbc:mysql://localhost:3306/mysql?useSSL=false&serverTimezone=Asia/Seoul";
- JDBC Introduction What is JDBC - JDBC = Java Database Connectivity = Java API for database-independent connectivity between range of databases - JDBC's library APIs (1) Making a connection to a database (2) Creating SQL or MYSQL
- MySQL Storage Engine Architecture MySQL Storage Engine Architecture, Part 1: An OverviewBy Arjen Lentz, MySQL AB 2 April 2004 출처: http: Programmatically this is nothing special, it.......
- Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server /2010/10/using-mysql-as-nosql-story-for.html Most of high scale web applications use MySQL + memcached One of the biggest reasons for such a movement is that it is said that NoSQL performs better than MySQL
- Percona XtraBackup Percona XtraBackup출처: http://www.percona.com/docs/wiki/percona-xtrabackup:start Percona XtraBackup is an open-source hot backup utility for MySQL that doesn't lock your database during the backup.
- mysql root 비밀번호 잊어 먹었을 때 - mysql root 비밀번호 잊어 먹었을 때[root@localhost local]# killall mysqld[root@localhost local]# /usr/local/mysql Commands end with ; or g.Your MySQL connection id is 2 to server version: 4.0.20-log Type 'help;' or