Forums / Install & configuration / log mysql

log mysql

Previous topic

Install & configuration

Next topic

Author	Message
jmcheng jmcheng	Wednesday 12 March 2008 2:25:26 am Hi, on my ezpublish server (3.9.0), i found a lot of log mysql files in /var/log/mysql/ mysql-bin.000001, mysql-bin.000002, mysql-bin.000003, mysql-bin.000004, etc... The size of these files is too big. Could they be deleted without it causing any trouble on the website? Thanks JM
Michael Hall	Friday 14 March 2008 2:02:05 am If they are in fact log files, you should be able to safely remove them. Leave the current one in place, and copy the others somewhere else. If everything is still OK, you can delete the copies, otherwise you can always put them back.

Author

Message

jmcheng jmcheng

Wednesday 12 March 2008 2:25:26 am

Hi,

on my ezpublish server (3.9.0), i found a lot of log mysql files in /var/log/mysql/ mysql-bin.000001, mysql-bin.000002, mysql-bin.000003, mysql-bin.000004, etc...

The size of these files is too big. Could they be deleted without it causing any trouble on the website?

Thanks

Michael Hall

Friday 14 March 2008 2:02:05 am

If they are in fact log files, you should be able to safely remove them. Leave the current one in place, and copy the others somewhere else. If everything is still OK, you can delete the copies, otherwise you can always put them back.

eZ debug

Timing:

Jan 18 2025 16:26:29

Script start

Timing:

Jan 18 2025 16:26:29

Module start 'content'

Timing:

Jan 18 2025 16:26:29

Module end 'content'

Timing:

Jan 18 2025 16:26:29

Script end

Main resources:

Total runtime

0.3345 sec

Peak memory usage

2,048.0000 KB

Database Queries

141

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0069	589.0391	180.8438
Module start 'content'	0.0069	0.0049	769.8828	93.6484
Module end 'content'	0.0118	0.3225	863.5313	521.9766
Script end	0.3343		1,385.5078

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0069

589.0391

180.8438

Module start 'content'

0.0069

0.0049

769.8828

93.6484

Module end 'content'

0.0118

0.3225

863.5313

521.9766

Script end

0.3343

1,385.5078

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0039	1.1555	20	0.0002
Check MTime	0.0017	0.5100	20	0.0001
Mysql Total
Database connection	0.0007	0.2227	1	0.0007
Mysqli_queries	0.2837	84.8099	141	0.0020
Looping result	0.0017	0.5091	139	0.0000
Template Total	0.3217	96.2	1	0.3217
Template load	0.0011	0.3187	1	0.0011
Template processing	0.3206	95.8424	1	0.3206
Override
Cache load	0.0008	0.2335	1	0.0008
Sytem overhead
Fetch class attribute can translate value	0.0008	0.2371	1	0.0008
XML
Image XML parsing	0.0003	0.0947	1	0.0003
General
dbfile	0.0026	0.7642	20	0.0001
String conversion	0.0000	0.0021	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0039

1.1555

0.0002

Check MTime

0.0017

0.5100

0.0001

Mysql Total

Database connection

0.0007

0.2227

0.0007

Mysqli_queries

0.2837

84.8099

141

0.0020

Looping result

0.0017

0.5091

139

0.0000

Template Total

0.3217

96.2

0.3217

Template load

0.0011

0.3187

0.0011

Template processing

0.3206

95.8424

0.3206

Override

Cache load

0.0008

0.2335

0.0008

Sytem overhead

Fetch class attribute can translate value

0.0008

0.2371

0.0008

XML

Image XML parsing

0.0003

0.0947

0.0003

General

dbfile

0.0026

0.7642

0.0001

String conversion

0.0000

0.0021

0.0000

Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

Cache	Type	Packlevel	SourceFiles
	CSS	0	extension/community/design/community/stylesheets/ext/jquery.autocomplete.css extension/community_design/design/suncana/stylesheets/scrollbars.css extension/community_design/design/suncana/stylesheets/tabs.css extension/community_design/design/suncana/stylesheets/roadmap.css extension/community_design/design/suncana/stylesheets/content.css extension/community_design/design/suncana/stylesheets/star-rating.css extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css extension/community_design/design/suncana/stylesheets/buttons.css extension/community_design/design/suncana/stylesheets/tweetbox.css extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css extension/sevenx/design/simple/stylesheets/star_rating.css extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css extension/sevenx/design/simple/stylesheets/main.v02.css extension/sevenx/design/simple/stylesheets/main.v02.res.css
	JS	0	extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js extension/community_design/design/suncana/javascript/jquery.ui.core.min.js extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js extension/community_design/design/suncana/javascript/jquery.easing.1.3.js extension/community_design/design/suncana/javascript/jquery.ui.tabs.js extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js extension/community_design/design/suncana/javascript/jquery.popmenu.js extension/community_design/design/suncana/javascript/jScrollPane.js extension/community_design/design/suncana/javascript/jquery.mousewheel.js extension/community_design/design/suncana/javascript/jquery.cycle.all.js extension/sevenx/design/simple/javascript/jquery.scrollTo.js extension/community_design/design/suncana/javascript/jquery.cookie.js extension/community_design/design/suncana/javascript/ezstarrating_jquery.js extension/community_design/design/suncana/javascript/jquery.initboxes.js extension/community_design/design/suncana/javascript/app.js extension/community_design/design/suncana/javascript/twitterwidget.js extension/community_design/design/suncana/javascript/community.js extension/community_design/design/suncana/javascript/roadmap.js extension/community_design/design/suncana/javascript/ez.js extension/community_design/design/suncana/javascript/ezshareevents.js extension/sevenx/design/simple/javascript/main.js

Cache

Type

Packlevel

SourceFiles

CSS

extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css

extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Usage

Requested template

Template

Template loaded

Edit

Override

pagelayout.tpl

<No override>

extension/sevenx/design/simple/templates/pagelayout.tpl

Number of times templates used: 1
Number of unique templates used: 1

Time used to render debug report: 0.0001 secs