|
|
|
Thursday, 15 December 2011 00:32 |
Clear the transaction Log if you are facing a low disk space on the database server.
To truncate log, use the following commands:
DBCC SHRINKFILE('logfilename', 1)
BACKUP LOG redeoba WITH TRUNCATE_ONLY DBCC SHRINKFILE('logfilename', 1)
where log filename is usually database name, i.e., northwind.log.
 Read more: |
|
|
Saturday, 22 October 2011 01:46 |
// A cron to send extract of slow query log of 3 different servers by mail every day. Change the email address. It is assumed that the keys are saved to login to different servers.
35 23 * * * (ssh 192.29.0.214 mysqldumpslow /var/log/mysql/mysql-slow.log | head -200; echo "#########################"; echo "Slow query log from 121"; echo "#########################"; ssh 192.29.0.121 mysqldumpslow /var/log/mysql/mysql-slow.log | head -200; echo "#########################"; echo "Slow query log from 213"; echo "#########################"; ssh 192.29.0.213 mysqldumpslow /var/log/mysql/mysql-slow.log | head -200 ) | mailx -s "My City slow query log from 214, 121 and 213" shantanu.oak+
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
> /root/shantanu/dumpslowsuccess.txt 2> /root/shantanu/dumpslowerror.txt
 Read more: |
|
Monday, 20 June 2011 09:03 |
We can't calculate the Log for 10 in js.
function calculate() {
var log1 = document.getElementById('log').value;
var base1 =10;
var dn=1;
dn=Math.log(base1);
var ans=Math.log(log1)/dn;
alert(ans);
}
This is the tool which calculate the log for any base from this tool. Log calculator Read more: |
|
|
Sunday, 15 August 2010 20:38 |
# parse ruby log message
# customize as needed
LOG_EXPRESSION = /([\w]+),\s+\[([^\]\s]+)\s+#([^\]]+)]\s+(\w+)\s+--\s+(\w+)?:\s+(.+)/
# sample log output from this call:
# logger.info("Ubiquitously") { "[dequeud] #{JSON.generate(params)}"}
string = 'I, [2010-08-15T16:16:46.142801 #81977] INFO -- Ubiquitously: {"title":"Google","url":"google.com","tags":"search, google, api","services":["meta_filter","mixx"],"description":"a search engine!"}'
string.gsub(LOG_EXPRESSION) do |match|
severity = $1
date = $2 # Time.parse(date)
pid = $3
label = $4
app = $5
message = $6
end
 Read more: |
|
Tuesday, 18 May 2010 07:00 |
 | About HoudahGPS
Allows you to transfer track log and waypoint data from your Garmin, Magellan or Wintec GPS devices. It connects via USB to the Garmin and Magellan devices. It interfaces with the Wintec WBT-100, WBT-101 and WBT-201 devices using Bluetooth.
HoudahGPS may also be used to convert between the GPX, NMEA and KML log file formats. The Sony GPS-CS1 track logger uses a special variant of the NMEA format which may also be read.
Possible uses of HoudahGPS include:
- Creation of backup copies of track log files for later use with HoudahGeo
- Conversion of track logs to KML for visualization in Google Earth. |
Read more: |
|
|
|
|
|
|
|