To log or not to log

Hello foremen,

on a large database, trillions of SELECTs and DELETEs are going to be 
performed. After that, the database is going to be unloaded. The database 
uses a transaction log.

Should I keep the log there along this process or "unmount" it after some 
parts of it (or even before the beginning)? In this case, nothing but the 
speed is important.

The database is ASA 7.0.4.3498.

Thanks
Pavel 


0
Pavel
2/22/2006 8:18:39 PM
sybase.sqlanywhere.general 32637 articles. 22 followers. Follow

5 Replies
1350 Views

Similar Articles

[PageSpeed] 36

LOG... ALWAYS LOG. Performance is dependent on the use of the log.

Recommendations:
1) Ensure that the file system is not excessively fragmented
2) Host the db file and log file on different physical disks on the same 
machine -- reducing the contention
3) Optionally, you may consider truncating the log periodically if you 
expect the log to grow very large. If you opt for this, it may impair 
overall performance.
-- 

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer 
Edition =and try out the market-leading database for mobile, embedded 
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions  http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************
0
Chris
2/22/2006 8:29:51 PM
I would also pre-grow your files.

Adaptive Server Anywhere automatically grows database files as needed. 
Rapidly-changing database files can lead to excessive file fragmentation on 
the disk, resulting in potential performance problems. Unless you are 
working with a database with a high rate of change, you do not need to worry 
about explicitly allocating space for database files. If you are working 
with a database with a high rate of change, you may pre-allocate disk space 
for dbspaces or for transaction logs using either Sybase Central or the 
ALTER DBSPACE statement.



Performance Tip
Running a disk defragmentation utility after pre-allocating disk space helps 
ensure that the database file is not fragmented over many disjoint areas of 
the disk drive. Performance can suffer if there is excessive fragmentation 
of database files.


0
Rick
2/23/2006 4:13:53 PM
On 22 Feb 2006 12:29:51 -0800, "Chris Keating(iAnywhere Solutions)"
<NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com> wrote:

>3) Optionally, you may consider truncating the log periodically if you 
>expect the log to grow very large. If you opt for this, it may impair 
>overall performance.

AFAIK there is no performance penalty for occasionally running
dbbackup to rename and restart the log... what method are you
referring to?

Breck

--
breck.carter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
0
Breck
2/23/2006 5:58:54 PM
In addition to what Chris and Rick said, a large number of deletes may
cause internal fragmentation of tables and indexes. This is a database
issue rather than a disk fragmentation issue. Unload/reload certainly
solves it, but REORGANIZE can also be used... *if* you notice a
performance problem.

Breck

On 22 Feb 2006 12:18:39 -0800, "Pavel Karady"
<pavel_ns.ns_karady@ns_kogerusa.com> wrote:

>Hello foremen,
>
>on a large database, trillions of SELECTs and DELETEs are going to be 
>performed. After that, the database is going to be unloaded. The database 
>uses a transaction log.
>
>Should I keep the log there along this process or "unmount" it after some 
>parts of it (or even before the beginning)? In this case, nothing but the 
>speed is important.
>
>The database is ASA 7.0.4.3498.
>
>Thanks
>Pavel 
>

--
breck.carter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
0
Breck
2/23/2006 6:01:05 PM
Thanks to all advices, thanks for all who participated.

Now there's a catch in the above sentence (two words swapped). Can you see 
it?

Pavel

"Breck Carter" <NOSPAM__bcarter@risingroad.com> wrote in message 
news:s4qrv117i7pumkghnu6vcmnfqv792t6g6h@4ax.com...
> In addition to what Chris and Rick said, a large number of deletes may
> cause internal fragmentation of tables and indexes. This is a database
> issue rather than a disk fragmentation issue. Unload/reload certainly
> solves it, but REORGANIZE can also be used... *if* you notice a
> performance problem.
>
> Breck
>
> On 22 Feb 2006 12:18:39 -0800, "Pavel Karady"
> <pavel_ns.ns_karady@ns_kogerusa.com> wrote:
>
>>Hello foremen,
>>
>>on a large database, trillions of SELECTs and DELETEs are going to be
>>performed. After that, the database is going to be unloaded. The database
>>uses a transaction log.
>>
>>Should I keep the log there along this process or "unmount" it after some
>>parts of it (or even before the beginning)? In this case, nothing but the
>>speed is important.
>>
>>The database is ASA 7.0.4.3498.
>>
>>Thanks
>>Pavel
>>
>
> --
> breck.carter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com 


0
Pavel
2/24/2006 10:52:45 AM
Reply:

Similar Artilces:

Logging log
Hi! I try to accomplish task described in http://forums.novell.com/novell-product-support-forums/zenworks/configuration-management/zcm-server-install/422609-mixed-login.html?pagenumber= and wonder I don't know how to keep log of logging? I mean, does ZCM is capable to keep logging log? As Altiris NS does? More thanks, Alar. -- NovAlf ------------------------------------------------------------------------ You look like you want to log in to your zone as a user from either a eDIR or AD. And yes this is possible, it will search both Directories. http://www.theurbanp...

Logged In As: Not Logged In
I installed ZCF 10.0.1 on a Win 2K3 server and when I install the ZEN client on a workstation the ZENWORKS client login comes up and I cannot log into it. It shows me the realm name of my tree and Zenworks Zone and I have tried both to no avail. When I look at the details of the adaptive agent it says, "Logged In As: Not Logged In" Any ideas? On Fri, 11 Jan 2008 14:55:21 GMT, Jayson E. Hahn wrote: > Any ideas? Debug logs in ZCM http://www.novell.com/support/search.do?cmd=displayKC&docType=kc&externalId=3418069&sliceId=SAL_Public&dialogID=51010132...

Event Log not Logging ??
 Hi All, On my dev machine when I log errors to the event log all works great however when I move the web application to the test server the events are not being logged... I am hoping it is some configuration issue with IIS however I am totally lost.The code writing the events: EventLog.WriteEntry("xxxxx", err, EventLogEntryType.Error);   Any help will be appreciated. Thanks,Neil  are you getting an error? Sometimes, its a permissions issue, if the log name doesn't exist, it tries to write the new value to the registry. Check the application log...

Logging to httpservlet.log
Anyone have any examples on how to log to this file? I know you need to use the ServletContext interface but I have been unable to find any real examples of how. Thanks for your help. Don Flannagan ...

Log files not logging
I have been given responsiblity for running our BorderManager 3.6 system. The server is no longer doing any logging. The last log file is dated August 13 2004. I just took this over. It is BM 3.6. Does anyone have any ideas where to look? Thanks Scott The administration of the log files is located in NWAdmin - select the Bordermanager Setup Tab - highlight HTTP Proxy - click on details - there is a Logging tab there that will tell you where the files are located and for how long, etc. Somtimes I have to go in and clean the logfiles out of the volume - if the volume ...

Filter log not logging
I have upgraded to TB 2.0.0.6, but it was doing this before. I set up a whole mess of new filters using the fancy new tagging. New filters definitely tagging incoming mail properly. I cleared out the old filter logs. I somehow managed to turn off logging. Yes I checked the little box. It's still not logging. I have tried turning off filter logging, exiting the program, starting up again and turning filter logging back on. Filterlog.html file exist, but empty. How do I get the filter log working again? Thank you. Charlie wrote: > I have upgraded to TB 2.0....

Transaction Logs And Logging
I work in a shop that does not keep the Sybase transaction logs. We have been mandated to research archiving our logging. The Sybase documentation does not go into great detail about how to do this. Can anyone give me pointers on this, or point me in the way of decent documentation? I understand setting the 'dump transaction' command on the Last Chance thresholds. We have 65 active databases, and the nightmare I have is trying to deal with 65 logs being constantly dumped. Without overwriting each other before they can be copied to tape. Is there an easy way to rename the ...

Application Log logging
Shaun, I have been getting complaints from our techs here about the huge amount of entries Patchlink is writing to the Application log. The problem is when they are trying to troubleshoot a problem on a PC, the application log has filled up with the Zenworks Patch Management Agent entries, pushing out the entries they need for troubleshooting. Aside from increasing the size of the Event logs, is there a way to "throttle" down the entries Patchlink is making? 6.3.2.700 server 6.3.2.858 agent Bob -- bstayskal Bstayskal, what level do you have the agent ...

User Log in Log
I need to keep a daily record of network logins Being Auditcon does not work with NW6, is there a way I can enable Logging on a server/tree to capture user login? Install NSURE Audit. Configure it to record logins and out for both the server and eDir. The Nsure Audit starter pack 1.0.3 is downloadable from the website. ~+~^~+~^~+~^~+~^~+~^~+~^~+~^~ Jim Gosney Netware/Groupwise Admin./Eng. Genesco, Inc. Nashville, TN Currently reading: fiction: Lord of the Rings: Return of the King -- J.R.R. Tolkien non-fiction: George Washington -- James Burns and Susan Dunn rel...

error log logs
Hi all, In the script I have to stop sybase, I use two instructions for log rotate. su sybase -c 'mv -f $SYBASE/$SYBASE_ASE/install/sybase.log /backup2/logs/sybase-`date +%y%m%d-%H%M%S`.log' su sybase -c 'touch $SYBASE/$SYBASE_ASE/install/sybase.log' But when I start ASE, the server don�t write in this file (sybase.log) it uses to write $SYBASE/errorlog Why????? What can I do to write in $SYBASE/$SYBASE_ASE/install/sybase.log The RUN_file is: #!/bin/sh # # Adaptive Server name: sybase # Master device path: /dev/md/dataset/rdsk/d3 # Error ...

ExceptionPolicy logs differently to event log than to text log
I am implementing an exception policy in the business layer and in the presentation layer of my web application as per the block below.  When an exception happens in the business layer, it bubbles on up to the aspx, which in turn throws the error, thus invoking the default error page defined in web.config.  All well and good.  The strangeness is that only one exception is logged to the event log, but both throws are caught in the text log.  Why the discrepancy? Thanks.    Catch ex As Exception Dim rethrow As Boolean re...

Logging in without logging in...
Help! I've been asked to integrate a dotnetnuke site with another corporate site to present the user with a seamless transition between the two. The user will login to the corporate site (behind a firewall) and at some point be passed over to the dotnetnuke site (hosted externally). Is there anyway to log the user (who came form the corporate site) into the dotnetnuke site without the user having to retype his / her username / password? I'd prefer not to pass the username / password in the url - something more secure would be preferred. If anyone has any ideas or has done it b...

Who to Validate log in and log out...
Hi, I'm doing a couple of Asp VB .Net 1.x  pages and a wanna know how to validate when a user logs in that web site... just like e-mail accounts do. Plus, how to avoid that after been logged in, the user copies the URL address, then closes all IE windows and opens a new one, paistes the URL address and the web site opens... without asking for logging in...   Is that why people use cookies??? As you can see, I'm a newby with Asp stuff.. Please help, or some controls for me to investigate, or archicles... Thanx a lot! ~ Luisco_____________________________________Programador ...

Logging Out & Logging In
Ok this might be a terribly simple one but its really baffeling me...Quick overview - I am creating a Web Application using Visual Web Developer 2008 (vb) ASP.NET 3.5 Ok, so say if I log in to the application from login.aspx as User1 and then once authenticated I am taken to default.aspx. I then navigate to another page, for arguments sake call it page1.aspx.Now I log out as User1 and log back in as User2. Instead of being shown default.aspx as earlier I am taken back to the page that the previous user was on - page1.aspx.How do I set what page is show once a user logs out and back in a...

Web resources about - To log or not to log - sybase.sqlanywhere.general

Log bucking - Wikipedia, the free encyclopedia
Bucking is the process of cutting a felled and delimbed tree into logs. This can be a complicated process because logs destined for plywood , ...

Can Facebook Page Admins Boost Scheduled Posts Via Activity Log?
Some Facebook page administrators now have the option to use Facebook’s boost post feature for scheduled posts via their activity logs . continued… ...

Forget to Log Out? Help is on the Way
... Facebook. Control isn’t just about deciding what you share and with whom you share it; it’s also about being able to keep your Facebook login ...

Facebook Promotes Mobile Services to Users Who Log Off the Web Site
It’s already clear that Facebook believes mobile devices are a key way for users to access its service, and the company has occasionally tested ...

Log in to Twitter!
Log in to Twitter! Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter ...

Philip McRell - Log - Quora
ad astra. just my $.02 - what's yours?

Remembering Catherine Coulson, the Log Lady on Twin Peaks
... Coulson became a stage actor. But years later, fans who were drawn to her strange Twin Peaks character were still asking her to sign logs for ...

Build-A-Rig Round 2, SilverStone vs Crucial: The $800 PC Build Logs
After starting our second Build-A-Rig project a couple of weeks ago the build logs are in and we can see what it is like to work hands on with ...

Today’s apps gone free: Shadowmatic, Walk Log, IQ Mission 2 and more
See whats in the shadows, log your daily walks, and solve complicated puzzles with todays collection of apps and games. All app prices are subject ...

RIP, Log Lady
Catherine Coulson, the actor who portrayed the inscrutable Log Lady on the cult classic TV series “Twin Peaks,” has died. According to the NYT ...

Resources last updated: 11/27/2015 2:08:29 PM