목록mysql (4)

써리원의 이것저것

mysql 용량 확인

데이터베이스별 용량 SELECT count(*) NUM_OF_TABLE, table_schema, concat(round(sum(table_rows)/1000000,2),'M') rows, concat(round(sum(data_length)/(1024*1024*1024),2),'G') DATA, concat(round(sum(index_length)/(1024*1024*1024),2),'G') idx, concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') total_size, round(sum(index_length)/sum(data_length),2) idxfrac FROM information_schema.TABLES GROUP B..
개발 2018. 10. 1. 14:42
mysql 에서 순서대로 order by 해서 sort 값 집어 넣기

SET @cnt = 0;UPDATE wp_bwg_image SET `order`=@cnt:=@cnt+1 where gallery_id = '12' ORDER BY `id` desc
개발 2018. 6. 22. 17:22
데이터베이스별 용량, 테이블별 용량 확인

데이터베이스별 용량 SELECT count(*) NUM_OF_TABLE, table_schema, concat(round(sum(table_rows)/1000000,2),'M') rows, concat(round(sum(data_length)/(1024*1024*1024),2),'G') DATA, concat(round(sum(index_length)/(1024*1024*1024),2),'G') idx, concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') total_size, round(sum(index_length)/sum(data_length),2) idxfrac FROM information_schema.TABLES GROUP B..
개발 2018. 6. 22. 17:20
HeidiSQL mysql 외부연결

INSERT INTO mysql.user (host,user,password) VALUES ('%','root',password('1234'));GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';FLUSH PRIVILEGES; /etc/mysql/my.cnf=># bind-address=127.0.0.1 mysql 재시작
서버 2018. 6. 22. 17:15
Prev 1 Next