Sponsored Content
Full Discussion: Avoiding "file collision"
Top Forums UNIX for Dummies Questions & Answers Avoiding "file collision" Post 302391021 by treesloth on Friday 29th of January 2010 07:31:49 PM
Old 01-29-2010
Avoiding "file collision"

I don't know if there's a better name for what I call "file collision"... Basically, I have a script that I'm using for quick and dirty MySQL testing. Here's the idea...


Code:
#!/usr/local/bin/bash

for num in `jot $1`  ##  Yep, jot... this is FreeBSD
do
/usr/bin/time mysql --user=root --password=password -e "USE test ; SELECT quote FROM table ORDER BY RAND() LIMIT 1;" > /dev/null &
sleep $2
done

Now, what I'd really like to do is add these time parameters:

Code:
/usr/bin/time -a -o /tmp/mysql_times ...

However, this seems to sometimes result in weird output, such as:

Code:
...snippet...
        3.38 real         0.00 user         0.02 sys
        3.38 real         0.00 user         0.00 sys
        3.34 real         3.35 real         0.01 user         0.00 sys
        0.00 user         0.00 sys
        3.42 real         0.00 user         0.01 sys

It appears that multiple writes are "colliding", resulting in mixed-up data. Any suggestions on the best way to handle this? Many thanks.
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

Hi Friends, Can any of you explain me about the below line of code? mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'` Im not able to understand, what exactly it is doing :confused: Any help would be useful for me. Lokesha (4 Replies)
Discussion started by: Lokesha
4 Replies

2. Shell Programming and Scripting

"sed" to check file size & echo " " to destination file

Hi, I've modified the syslogd source to include a thread that will keep track of a timer(or a timer thread). My intention is to check the file size of /var/log/messages in every one minute & if the size is more than 128KB, do a echo " " > /var/log/messages, so that the file size will be set... (7 Replies)
Discussion started by: jockey007
7 Replies

3. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

4. Shell Programming and Scripting

finding the strings beween 2 characters "/" & "/" in .txt file

Hi all. I have a .txt file that I need to sort it My file is like: 1- 88 chain0 MASTER (FF-TE) FFFF 1962510 /TCK T FD2TQHVTT1 /jtagc/jtag_instreg/updateinstr_reg_1 dff1 (TI,SO) 2- ... (10 Replies)
Discussion started by: Behrouzx77
10 Replies

5. Windows & DOS: Issues & Discussions

Avoiding DOS space related "path not found errors"

Well I have a lot of scripts that require dragging and dropping files in order to define Source files etc. However more often then not it is the case that the path to said file contains NUMEROUS spaces. I know one way to evade this problem is to encase the path in Quotes like this: ... (7 Replies)
Discussion started by: pasc
7 Replies

6. UNIX for Dummies Questions & Answers

Using "mailx" command to read "to" and "cc" email addreses from input file

How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address and column 3 contains “cc” e-mail address to include with same email. Sample input file, email.txt Below is an sample code where... (2 Replies)
Discussion started by: asjaiswal
2 Replies

7. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies

8. AIX

Apache 2.4 directory cannot display "Last modified" "Size" "Description"

Hi 2 all, i have had AIX 7.2 :/# /usr/IBMAHS/bin/apachectl -v Server version: Apache/2.4.12 (Unix) Server built: May 25 2015 04:58:27 :/#:/# /usr/IBMAHS/bin/apachectl -M Loaded Modules: core_module (static) so_module (static) http_module (static) mpm_worker_module (static) ... (3 Replies)
Discussion started by: penchev
3 Replies
BTRFS-IMAGE(8)						      System Manager's Manual						    BTRFS-IMAGE(8)

NAME
btrfs-image - create/restore an image of the filesystem SYNOPSIS
btrfs-image [options] source target DESCRIPTION
btrfs-image is used to create an image of a btrfs filesystem. All data will be zeroed, but metadata and the like is preserved. source is the special file corresponding to the device containing a btrfs filesystem. (e.g /dev/sdXX). target is the image file that btrfs-image creates. When used with -r option, btrfs-image restores the image file from source into target. OPTIONS
-r restore metadump image. -c value compression level (0 ~ 9). -t value number of threads (1 ~ 32) to be used to process the image dump or restore. -o use the old restore method, this does not fixup the chunk tree so the restored file system will not be able to be mounted. -s Sanitize the file names when generating the image. One -s means just generate random garbage, which means that the directory indexes won't match up since the hashes won't match with the garbage filenames. Using -ss will calculate a collision for the filename so that the hashes match, and if it can't calculate a collision then it will just generate garbage. The collision calculator is very time and CPU intensive so only use it if you are having problems with your file system tree and need to have it mostly working. -w Walk all the trees manually and copy any blocks that are referenced. Use this option if your extent tree is corrupted to make sure that all of the metadata is captured. AVAILABILITY
btrfs-image is part of btrfs-progs. Btrfs is currently under heavy development, and not suitable for any uses other than benchmarking and review. Please refer to the btrfs wiki http://btrfs.wiki.kernel.org for further details. SEE ALSO
btrfsck(8),mkfs.btrfs(8) BTRFS-IMAGE(8)
All times are GMT -4. The time now is 11:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy