Jump to content

Linux on Unix Action Hero

Members
  • Content Count

    10
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Linux on Unix Action Hero

  • Rank
    novice
  1. Are there any tools out there for Mac which enable me to get into a FM file to reset or retrieve existing passwords? I need to get into a FM solution from 5 years ago and nobody remembers the passwords. I found a couple freeware/shareware/etc. apps, but they're all for Windows (which isn't available at this time). Anything available for Mac?
  2. What is the purpose of the colors in the entity relationship graph? Is there some sort of accepted standard in how colors are applied to TOs? I've recently come into management of a solution where colors were liberally applied to the TOs (blue, green, grey, red, etc.) and I've yet been able to determine what criteria was assessed when selecting their colors. Any input on different techniques used would be helpful. I would like to re-colorize them to fit the situation as I understand the underlying relationships better, but I don't want to start changing things if there's a reason behind the existing colors. Thanks.
  3. I've been looking around and have yet been unable to find any information on what kind of hardware FileMaker Server can utilize. Is it designed for use on multi-core processors? Multiple processors? Multiple processors with multiple cores? Will it utilize the power, or will it only end up using a single core?
  4. I've got an older server running FileMaker Sever 9. It's under the necessary spec for FMS9. However, I've got little choice but to use it until the new server requisition comes in. So, I'm wondering what I can do to help improve the performance. As essentially everything important can be performed from the fmsadmin console tool, I was wondering if Java could be disabled: it's using 800+ Mb of swap and 100Mb of resident private memory, amongst other things. I'm not able to see how FMS actually uses it, directly. So, can I disable/shut down the java process, and if so, is there a 'clean' way to do so?
  5. We're experiencing very similar symptoms in a purely FM environment, with the same kind of functionality. My suspicion is that it's largely due to an underpowered host server (ie, the one that runs FileMaker). Our FM db is about 40k rows, about 45 tables, and running on a 1.2GHz G4 w/ 1.5G (10.4 w/ FMS9). The system gets fairly heavily stressed during a pretty simple query.
  6. I'm looking at doing something similar, albeit with an separate host serving the MySQL. Is there much/any performance difference on a FileMaker server in such an environment, vs. with FileMaker and the SQL server on the same host?
  7. I've no experience in the matter, but the only thing I can offer (based on research) is that OS X is poor at thread handling/scheduling on a per-core basis, and that adding additional cores -should- make the performance (specifically of filemaker, due to the fact that it's a db which utilizes a large numbre of threads) better. I've yet to figure out if filemaker is designed to utilize multiple cores, however... -/
  8. I'm currently in a situation where I've, basically, just jumped in head-first into the world of FileMaker and Macs with a new position (as of Monday). I'm an experienced Windows and Linux administrator, but I'm fairly unfamiliar with both the PPC arch and OS X. I mention PPC because I've currently got a 1.25GHz G4 Powermac with 1.5G RAM running FileMaker Server 9. There's an average of 12 connected users at any one time, and 16 user max, though this is likely to change in the weeks to come. Current performance of the database can be described as really, really slow, and the coming weeks will see an increase in the amount of use due to deadlines in 6 weeks. The server really needs to be more responsive than it is. I am aware of the thread handling issues OS X seems to have, and that is part of my concern/consideration. My problem is complex. I'm aware of some database problems (for instance, it needs to be normalized), but this is crunch time and I'm really unable (and unwilling) to mess with the internals of FileMaker's db this soon into the game. So while that needs to be done to increase performance, it's not something that can be done immediately. So, I'm basically stuck with throwing hardware at the problem. The problem is that when the fmserverd process reaches around 65 processes (from an 'idle' 56 or so), it seems to get into a user-interruptible deadlock condition, where performance all but ceases (ie, table lookups of simple stuff take forever) until thread count/user connections decrease. I'm unable to use the FM admin console during the day as a result of this. Queries will take 30 seconds or so (albiet, returning quite a few rows) when more than one person performs such a search at a time - and so on and so forth. Current system utilization is pretty thorough. Of the 1.5Gb memory and 7.5Gb swap, fmserverd is using 325Mb ram, 455 vm, and java (owned by the fmserver user, which I can only assume is necessary and associated to FM) is using 100 and 800 megabytes, respectively. Total picture is only about 50Mb of RAM free - and we're seeing the occasional lag in FM from system paging as a result, I believe. Aside from that, processor use tends to remain fairly constantly over 50% utilization, and people are complaining about performance. (I should note, an upgrade to FMS9 from FMS7 was made about 2 weeks prior to my arrival here, and this may partially be a symptom of that move.) My question(s) is/are: how much of a performance boost will I realistically get from migrating to a new server? This seems like the only realistic, immediate course of action which can be taken for me. I'm looking at the load on the existing server and trying to find hardware comparisons, all while wondering if OS X would perform sufficiently better on (say) a Quad Core Xeon or 2 Dual Core Xeons with 4Gb+ to help mitigate the issue. I believe I could easily see a 2x performance boost with even a low-end (refurb) server, but I'd like some input before I commit my new employer (of under a week) to a $5,000 purchase! Any/all advice would be appreciated.
  9. If we're looking solely at the performance of the OS (as the hardware is, for all intents and purposes, the same), I'd highly recommend -against- OS X. There have been studies done on OSX's ability to handle applications which utilize a large number of threads - such as any database application. Short This article talks about it more: http://www.anandtech.com/mac/showdoc.aspx?i=2436&p=8 I have no idea how Windows compares to OS X with respect to thread handling, but my personal experience is that Windows isn't that much worse than Linux in most instances, but for the cost of an Xserve, I'd say use what you're familiar with, from a vendor you normally use.
  10. I'm not too familiar with FM yet, but I might be able to offer some input/things to check. - What is the processor load during use? - Does the system swap out to disk? - How big is the database/how many db rows are getting returned at once? - How many users are accessing remotely? - Do you have local access speed problems? The thing is, compared to pretty much every other OS out there, MacOS X falls a bit short when doing with threading due to how many kernel locks it allows at once, and its general signal handling ability. DBs usually require a fair number of threads, and as OS X compares (for instance) roughly 1/7th as well as Linux with thread/process signal handling, you're going to hit a bottleneck pretty quickly. Network server roles also generate a fair number of threads on a system due to the additional forking of data over interfaces. This is, unfortunately, a fault of OS X itself, in part due to its "kernel within a kernel architecture" design. (IE, the difference between OS X on PPC and Intel is marginal - they both suffer about 7-8th the performance after only about a concurrency of 2).
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.