Feeds:
Posts
Comments

MySQL command options

So I use MySQL for testing from time to time and I always get frustrated at logging in via command line.

Is it option “P” or option “p”, “U” or “u”. Long story short I chuckled at the option for -U or --i-am-a-dummy. So if you can’t figure out how to log in, maybe you are just a dummy like myself.

Which itself is apparently is a synonym for option --safe-updates

See my official feature request.

When executing processes that have the potential to use a large amount of memory 4D recommends “allocating enough stack size to the process” to be sufficient to do the job.

Well how would we know that?

I propose adding two additional return variables to PROCESS PROPERTIES. Stack Size and Stack Utilized.

This would allow me to get a point in time measurement of what I allocated to the process and how much the process is currently using of that allocated stack.

>Product :4D – 4D Server
>4D : v11 SQL r8
>OS : Mac OS 10.5.7 or Windows

Working on a procedure that dynamically slows or speeds itself up based on demand.

I had wrongly assumed that Delay Process would take a negative number and either throw an error or no longer delay the process.

Solution: check for negative numbers and pass a positive number into the Delay Process command.

` 4D Server v11.8 HF2
` Running on xserve 10.5.6
C_LONGINT($vl_ticks_to_wait;$vl_ticks_elapsed)

` our standard is to to wait 1 second
$vl_ticks_to_wait:=60

` but in this last cycle we took 2 seconds to execute so we don't want to
` pause just go into the next cycle
$vl_ticks_elapsed:=60*2

While (True)
  ` just go with the concept of a loop here
  ` I would think that this would wait a maximum of 60 ticks down to none at all
  ` but when asked to delay a negative number no error is thrown, the process
  ` just becomes permanently "Delayed"
  Delay Process(Current Process;$vl_ticks_to_wait-$vl_ticks_elapsed)
End While
Design a site like this with WordPress.com
Get started