Home / user-1415

Tim Meers's questions

Martin Hope
Tim Meers
Asked: 2012-03-01 11:23:03 +0800 CST
  • 8

If you alter a table to add an index, what could happen if that thread was killed during processing?

Accroding to MySQL:

During ALTER TABLE, the kill flag is checked before each block of rows are read from the original table. If the kill flag was set, the statement is aborted and the temporary table is deleted.

Edit: Just making sure that it's not going to cause any additional issues.

mysql
Martin Hope
Tim Meers
Asked: 2010-10-30 05:03:45 +0800 CST
  • 2

I'm trying to get a little more usefulness out of my MySQL backups. I'm wanting to gzip my backup when it's completed from a cron job. Here's the script I have so far to do the backup. 

#!/bin/sh
date=`date -Iminutes`
mysqldump --all-databases > /var/sqlbackup/sqlbackup-$date.sql -pmypassword
find /var/sqlbackup/ -mtime 3 | xargs rm

Any help would be beneficial, even if it's a pointer on how to do it better.

mysql gzip
Martin Hope
Tim Meers
Asked: 2010-04-16 08:48:15 +0800 CST
  • 1

I recently added a new modem (a plain ol consumer grade one) to a fax server thats been up and running for years running on Microsoft Server 2003 fax services. The server currently has two modems, the new one is identical to one of the existing. After installing the new modem it showed up in the Fax Server Manager as a device but was not doing outbound faxes. (The server by default does not handle incoming.)

So after a reboot the server no loger sees the modem in the Fax Server Manager but is listed as a device in device manager. I've attempted to restart just the fax service and even the whole box again but to no avail.

Any one have any ideas on this one? Or any one with good links to resources for the fax service?

windows-server-2003 fax
Martin Hope
Tim Meers
Asked: 2010-04-10 19:03:09 +0800 CST
  • 7

I'm about to start switching some networks around for multiple small offices. Each office has about 10 to 15 users and 10 to 15 computers. Each office has a spread of generic routers and access points. The routers vary from being used as routers, to just being an access point for wireless. Nothing formal has really ever beem implemented for each of the 10 offices.

What I'm wanting is to set up a pfSense box for each office to configure things like:

  • traffic shaping (for VoIP QOS)
  • URL Filtering
  • DHCP
  • static routing
  • multiple VLANs

I'll then use some of the existing hardware for wireless. Maybe even integrate the wireless right into the firewall depending on the office layout.

So my question, would this be better to do a full blown firewall box, or but a new business class or high end consumer class Linksys router to do the URL filtering, QOS and DHPC?

Each option could allow for remote access and VPN for remote maintnance and each would only cost a nominal about of money for something decent, i.e. under $250.

firewall small-business cisco linksys pfsense
Martin Hope
Tim Meers
Asked: 2010-01-16 07:39:01 +0800 CST
  • 3

I've been trying to really figure out what my IOPS are on my DB server array and see if it's just too much. The array is four 72.6gb 15k rpm drives in RAID 5. To calculate IOPS for RAID 5 the following formula is used: (reads + (4 * Writes)) / Number of disks = total IOPS. The formula is from MSDN. I also want to calculate the Avg Queue Length but I'm not sure where they are getting the formula from, but i think it reads on that page as avg que length/number of disks = actual queue.

To populate that formula I used the perfmon to gather the needed information. I came up with this, under normal production load: (873.982 + (4 * 28.999)) / 4 = 247.495. Also the disk queue lengh of 14.454/4 = 3.614.

So to the question, am I wrong in thinking this array has a very high disk IO?

Edit
I got the chance to review it again this morning under normal/high load. This time with even bigger numbers and IOPS in excess of 600 for about 5 minutes then it died down again. But I also took a look at the Avg sec/Transfer, %Disk Time, and %Idle Time. These number were taken when the reads/writes per sec were only 332.997/17.999 respectively.

%Disk Time: 219.436
%Idle Time: 0.300
Avg Disk Queue Length: 2.194
Avg Disk sec/Transfer: 0.006
Pages/sec: 2927.802
% Processor Time: 21.877

Edit (again)
Looks like I have that issue solved. Thanks for the help. Also for a pretty slick parser I found this: http://pal.codeplex.com/ It works pretty well for breaking down the data into something usable.

sql-server windows-server-2003 io
Martin Hope
Tim Meers
Asked: 2009-08-04 07:33:08 +0800 CST
  • 0

Just for clairity I'm wondering what the best practice is for giving the IUSR_ account write access under IIS 6.0 to a folder. I gave searching on Google a try and on here a try but nothings really pointing me in either direction. From my understanind giving that account write access to a folder in an Internet site would be a bad idea. This site would be a mix of Classic ASP and ASP.NET.

Any one want to chime in on this?

asp.net iis-6 asp-classic
Martin Hope
Tim Meers
Asked: 2009-07-23 05:37:33 +0800 CST
  • 1

I have a stored procedure that is being executed by an unknown job. So I'm trying to figure out where the data is stored in SQL 2000 that shows which jobs belong to which database. The reason is that I have a job running that the job name does not have the database name in it. All of the jobs should be something like 'Job name - dbName'.

But for some reason I'm either A: not able to see it frmo Enterprise Manager, or B: the sproc is being executed by another job. Though when I search all the procedures for that procedure name in source control I only find it's name in that one sproc.

I've looked in the msdb.sysjobs table and that gives me jon names, job id's, and other info, but not the database name that it is executing against. I'm just strugling to figure this out.

sql-server