From owner-freebsd-database@FreeBSD.ORG Mon Sep 18 11:19:51 2006 Return-Path: X-Original-To: freebsd-database@FreeBSD.ORG Delivered-To: freebsd-database@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 262E516A403 for ; Mon, 18 Sep 2006 11:19:51 +0000 (UTC) (envelope-from olli@lurza.secnetix.de) Received: from lurza.secnetix.de (lurza.secnetix.de [83.120.8.8]) by mx1.FreeBSD.org (Postfix) with ESMTP id B385243DA1 for ; Mon, 18 Sep 2006 11:19:33 +0000 (GMT) (envelope-from olli@lurza.secnetix.de) Received: from lurza.secnetix.de (mlifor@localhost [127.0.0.1]) by lurza.secnetix.de (8.13.4/8.13.4) with ESMTP id k8IBJQM8092422; Mon, 18 Sep 2006 13:19:32 +0200 (CEST) (envelope-from oliver.fromme@secnetix.de) Received: (from olli@localhost) by lurza.secnetix.de (8.13.4/8.13.1/Submit) id k8IBJPJl092421; Mon, 18 Sep 2006 13:19:25 +0200 (CEST) (envelope-from olli) Date: Mon, 18 Sep 2006 13:19:25 +0200 (CEST) Message-Id: <200609181119.k8IBJPJl092421@lurza.secnetix.de> From: Oliver Fromme To: freebsd-database@FreeBSD.ORG, glenn@mail.more.net In-Reply-To: <20060915152405.GD8776@gkar.earthdome.org> X-Newsgroups: list.freebsd-database User-Agent: tin/1.8.0-20051224 ("Ronay") (UNIX) (FreeBSD/4.11-STABLE (i386)) X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.1.2 (lurza.secnetix.de [127.0.0.1]); Mon, 18 Sep 2006 13:19:32 +0200 (CEST) Cc: Subject: Re: MySQL and FS softupdates X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: freebsd-database@FreeBSD.ORG, glenn@mail.more.net List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 18 Sep 2006 11:19:51 -0000 Glenn Nielsen wrote: > I recently had a server running a MySQL master db lose power. When > the server came back up the mysql binary log used for replication > was missing the last 7-8 minutes of database changes. > > FS softupdates are being used. > > Are softupdates a good thing, a bad thing, or make no difference > for recovery of a mysql database after a server failure? Whether soft-updates "good" or "bad" depends on your requirements. Softupdates ensures that the file system (to be exact: its meta data) is always in a consistent state, modulo write- caching on the drives (which should be turned off). As a side effect it makes the file system faster, because write accesses are buffered and reordered. On the other hand, turning the drives' write caches off lowers the performance noticeably. However, because data is buffered, you can lose some of it that hasn't been written to disk when the machine crashes. Normally the write delay should be no more than 30 seconds, but it's possible that a longer backlog of writes builds up if there's high I/O load. But: A database should issue fsync() calls, and soft-updates should honour them, unless configured otherwise. There problem is that you will always have to trade speed for reliability. You cannot have the best of both (at least with a single machine). Another thing to consider is the fact that soft-updates is not able to ensure consistency of application data, such as SQL databases, because soft-updates doesn't know anything about the inner structure and format of the database files, of course. My personal experience is that PostgreSQL is much more robust against such damage. It detects the un- clean shutdown, replays the necessary WAL entries, and is online pretty quickly. With mysql I've witnessed several pretty bad cases where a database was not recoverable. Another way to prevent damage is to setup a read-only slave to which all transactions are replicated. If the master crashes, the slave database will still be in a consistent state, because it commits only complete transactions. You can then make the slave to a read/write master and continue database services, while you rebuild the old master and configure it to become the new backup slave. It might also be worth a try to use the gjournal feature that has recently been committed to FreeBSD current and 6-stable. With the journal on a separate disk, it should be as fast as soft-updates or even faster, and any complete transaction in the journal will be replayed after a crash, so it should be pretty reliable (and recovery is _much_ faster because no fsck is required at all). Best regards Oliver -- Oliver Fromme, secnetix GmbH & Co. KG, Marktplatz 29, 85567 Grafing Dienstleistungen mit Schwerpunkt FreeBSD: http://www.secnetix.de/bsd Any opinions expressed in this message may be personal to the author and may not necessarily reflect the opinions of secnetix in any way. "Being really good at C++ is like being really good at using rocks to sharpen sticks." -- Thant Tessman From owner-freebsd-database@FreeBSD.ORG Wed Sep 20 06:20:40 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7994D16A586 for ; Wed, 20 Sep 2006 06:20:40 +0000 (UTC) (envelope-from mcnvasajv@classifiedtoday.com) Received: from classifiedtoday.com (cmo116.neoplus.adsl.tpnet.pl [83.31.142.116]) by mx1.FreeBSD.org (Postfix) with SMTP id F324943D76 for ; Wed, 20 Sep 2006 06:20:33 +0000 (GMT) (envelope-from mcnvasajv@classifiedtoday.com) Received: from 83.31.142.116 by classifiedtoday.com Date: Wed, 20 Sep 2006 08:20:31 +0100 From: "felicio Pearle" X-Sender: mcnvasajv@classifiedtoday.com To: Message-Id: <9942817643.wMDzWpA-7203671-420769759@classifiedtoday.com> MIME-Version: 1.0 Content-Type: text/plain Subject: Your in hot water. X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 20 Sep 2006 06:20:40 -0000 HOT ALERT - THIS ONE IS STILL CLIMBING THE CHARTS ALERT -- BREAKING MARKET NEWS REPORT ---- WBRS.PK Company Name: WILD BRUSH ENERGY Lookup: WBRS.PK Current Price: .05 Expected: STEADILY CLIMB FOR THE TOP Breaking News: Wild Brush Acquires Additional Powder River Oil & Gas Lease Wild Brush Energy (PINKSHEETS: WBRS) announces the purchase of an additional Powder River Basin Federal Oil & Gas Lease in the State of Wyoming. The lease is located on the eastern side of the Basin in Weston County. This is the fifth lease the Company now controls in the region. Wild Brush maintains its expansion strategy through acquisition of low risk, high probability oil and gas properties in proven regions such as Powder River basin. Wild Brush will continue to concentrate on the Powder River Basin area, due to the number of lease acre ages it currently controls. The Powder River Basin claims a high probability rate of discoveries and proven production as demonstrated by such companies as Chevron and Western Gas. There are presently over 12,000 gas wells, in addition to nearly 400 new wells monthly, producing over 330 billion cubic feet annually, in an area with an estimated 32 trillion cubic feet of natural gas. About WBRS.PK Wild Brush Energy is a diversified energy company whose primary goal is to identify and develop Oil & Coalbed Methane sites within the State of Wyoming. In addition, Wild Brush Energy continues to evaluate clean air alternative energy producing technologies such as Wind Power. Wild Brush trades in the U.S. under the symbol "WBRS." WATCH THIS STOCK GO HIGHER AND HIGHER -------------------------------------------------------------------------------- Results don't lie once you look you'll want to get in ----------------------- Wet behind the ears. Shit happens. Want my place in the sun. Still waters run deep. Walking on thin ice. What goes up must come down. Your ass is grass. Sweet as honey. To rule the mountains is to rule the river. So hungry I could eat a horse. The stronger the breeze the stronger the trees. Sow dry and set wet. A stick in the mud. You reap what you sow. So hungry I could eat a horse. They're like two peas in a pod. Strong as an ox. We'll hand you out to dry. Your all washed up. Your all washed up. We'll hand you out to dry. Ugly as a mud fence. That's a real stem winder. Wrinkled as a prune. Walking on cloud nine. Water it down. Putting it in a nutshell. The sharper is the berry, the sweeter is the wine. Watered down. Spring forward fall back. Run to seed. Stubborn as a mule. A thorn in my side. Salt of the Earth. Waking up with the chickens. Put to bed with a shovel. You can lead a horse to water but you can't make him drink. Turn over a new leaf. Still water runs dirty and deep. Rough as a cob. To rule the mountains is to rule the river. Shake like a leaf. From owner-freebsd-database@FreeBSD.ORG Wed Sep 20 09:14:36 2006 Return-Path: X-Original-To: database@freebsd.org Delivered-To: freebsd-database@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 15C7916A417 for ; Wed, 20 Sep 2006 09:14:36 +0000 (UTC) (envelope-from cwigpvn@proxad.net) Received: from lns-bzn-27-82-248-14-169.adsl.proxad.net (lns-bzn-43-82-249-151-43.adsl.proxad.net [82.249.151.43]) by mx1.FreeBSD.org (Postfix) with ESMTP id C926143D73 for ; Wed, 20 Sep 2006 09:14:34 +0000 (GMT) (envelope-from cwigpvn@proxad.net) Message-ID: <000f01c6dc95$321cbda0$a90ef852@internet> From: "News Maps" To: database@freebsd.org Date: Wed, 20 Sep 2006 11:14:37 -0200 MIME-Version: 1.0 Content-Type: multipart/related; type="multipart/alternative"; boundary="----=_NextPart_000_000B_01C6DCA5.F5A58DA0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Subject: different keywords. general fewer X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 20 Sep 2006 09:14:36 -0000 ------=_NextPart_000_000B_01C6DCA5.F5A58DA0 Content-Type: text/plain; charset="windows-1250" Content-Transfer-Encoding: quoted-printable Sign in Web Images VideoNew News Maps more raquo Advanced Search = Members: users: Join Alerts Create new group About Searched all groups = Your search did not match any Make sure words are spelled Try different = keywords. general fewer your on can try Answers for all groups Your search did not match any Make sure words are spelled Try = different keywords. general fewer your on can try Answers for expert = help with search. Get the latest messages emailed to Alerts. Terms Help Sign in Web Images VideoNew News Maps more raquo Advanced Search = Members: users: Join Alerts Create new group About Searched all groups = Your search did not match any Make sure words are spelled Try different = keywords. general fewer your on can try Answers for expert help with = search. Get the latest messages emailed to Alerts. Terms Images VideoNew News Maps more raquo Advanced Search Members: users: = Join Alerts Create new group About Searched all groups Your search did = not match any Make sure words are spelled Try different keywords. = general fewer your on can try Answers for expert help with search. Get = the Home Help Sign in Web Images VideoNew News Maps more raquo Advanced = Search Members: users: Join Alerts Create new group About Searched all = groups Your search did not match Images VideoNew News Maps more raquo Advanced Search Members: users: = Join Alerts Create new group About Searched all groups Your search did = not match any Make sure words are spelled Try different keywords. = general fewer your on can try Answers for expert help with search. Get = the latest messages emailed to Alerts. Terms About Searched all groups Your search did not match any Make sure words = are spelled Try different keywords. general fewer your on can try = Answers for expert help with search. Get ------=_NextPart_000_000B_01C6DCA5.F5A58DA0-- From owner-freebsd-database@FreeBSD.ORG Wed Sep 20 13:23:04 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 455D616A6A5 for ; Wed, 20 Sep 2006 13:23:04 +0000 (UTC) (envelope-from knnctd@ostnet.pl) Received: from ppp134234.ostnet.pl (ppp134234.ostnet.pl [62.133.134.234]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6015143D5D for ; Wed, 20 Sep 2006 13:22:58 +0000 (GMT) (envelope-from knnctd@ostnet.pl) Message-ID: <000e01c6dcb8$0558b2b0$ea86853e@cklxa47crm1mjh> From: "expert" To: freebsd-database@freebsd.org Date: Wed, 20 Sep 2006 15:23:54 -0200 MIME-Version: 1.0 Content-Type: multipart/related; type="multipart/alternative"; boundary="----=_NextPart_000_000A_01C6DCC8.C8E182B0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: keywords. general fewer X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 20 Sep 2006 13:23:04 -0000 ------=_NextPart_000_000A_01C6DCC8.C8E182B0 Content-Type: text/plain; charset="windows-1250" Content-Transfer-Encoding: quoted-printable more raquo Advanced Search Members: users: Join Alerts Create new group = About Searched all groups Your search did not match any Make sure words = are spelled Try different keywords. general fewer your on can try = Answers for expert help with search. Get the latest messages emailed to = Alerts. Terms of oogle Groups Home Help Sign in Web Images VideoNew News Maps more raquo = Advanced Search Members: users: Join Alerts Create new group About = Searched all groups Your search did not match any Make sure words are = spelled Try different keywords. general fewer your on can try Answers = for expert help with search. Get the latest messages emailed to Alerts. = Terms News Maps more raquo Advanced Search Members: users: Join Alerts Create = new group About Searched all groups Your search did not match any Make = sure words are spelled Try different keywords. general fewer your on can = try Answers for expert help with search. Get the latest messages emailed = to Alerts. oogle Groups Home Help Sign in Web Images VideoNew News Maps more raquo = Advanced Search Members: users: Join Alerts Create new group About = Searched all groups Your search did not match any Make sure words are = spelled Try different keywords. general fewer your on can try Answers = for expert help with search. Get the latest messages emailed to Alerts. = Terms of Service Privacy Policy copy Alerts Create new group About Searched all groups Your search did not = match any Make sure words are spelled Try different keywords. general = fewer your on can try Answers for expert help with search. Get the = latest messages emailed to Alerts. Try different keywords. general fewer your on can try Answers for expert = help with Get the latest messages emailed to Alerts. Terms of Service Privacy ------=_NextPart_000_000A_01C6DCC8.C8E182B0-- From owner-freebsd-database@FreeBSD.ORG Fri Sep 22 23:22:41 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0EE1916A47B; Fri, 22 Sep 2006 23:22:41 +0000 (UTC) (envelope-from itetcu@FreeBSD.org) Received: from it.buh.tecnik93.com (it.buh.tecnik93.com [81.196.204.98]) by mx1.FreeBSD.org (Postfix) with ESMTP id 23D6443D62; Fri, 22 Sep 2006 23:22:37 +0000 (GMT) (envelope-from itetcu@FreeBSD.org) Received: from it.buh.tecnik93.com (localhost [127.0.0.1]) by it.buh.tecnik93.com (Postfix) with ESMTP id 7613818181; Sat, 23 Sep 2006 02:22:36 +0300 (EEST) Date: Sat, 23 Sep 2006 02:22:34 +0300 From: Ion-Mihai "IOnut" Tetcu To: freebsd-emulation@FreeBSD.org, freebsd-database@freebsd.org Message-ID: <20060923022234.3ce46236@it.buh.tecnik93.com> X-Mailer: Sylpheed-Claws 2.4.0 (GTK+ 2.8.20; i386-portbld-freebsd6.2) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_vkgP/KTaNfqK3z2CkCc/Jxv"; protocol="application/pgp-signature"; micalg=PGP-SHA1 Cc: Subject: php*-oci8 or an alternative ? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 22 Sep 2006 23:22:41 -0000 --Sig_vkgP/KTaNfqK3z2CkCc/Jxv Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Hi, // Background info: I'm migrating a site from a Linux shop. I have an working installation (soon to be a port) of Oracle 10g XE on my 6-STABLE box. I need some way to connect to it from php. Ideally (since the site it's already done and runs OK on Linux) I should use: php4 + php-oci + ZendAccelerator + Smarty + pear-* I'm already behind the schedule. I don't really care if I have to switch to php5 to use oci8 or whatever (even if this means I have to write some wrapper functions in php); I wouldn't object right now to run everything under linuxulator, provided it works. 1. Trying to apply the same trick from php5-oci8 port to make a php4-oci8 port: for lib in ${LOCALBASE}/oracle8-client/lib/libclntsh /usr/lib/libpt= hread; do \ /usr/bin/ar x $${lib}.a; \ done; \ /usr/bin/ar rcs liboci8.a *.o results, at run-time in: PHP Warning: Unknown(): Unable to load dynamic library '/usr/local/lib/php= /20020429/oci8.so' - /usr/local/lib/php/20020429/oci8.so: Undefined symbol = "pthread_kill" in Unknown on line 0 # objdump -TR /usr/local/lib/php/20020429/oci8.so | grep pthread_kill 00000000 D *UND* 00000000 pthread_kill 0040d00c R_386_PC32 pthread_kill 004fb188 R_386_JUMP_SLOT pthread_kill 2. php5-oci8 port doesn't work: On a FreeBSD 7.0-CURRENT #1: Thu Oct 12 15:41:06 EEST 2006 box: > php PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/p= hp/20050922/oci8.so' - /usr/local/lib/php/20050922/oci8.so: Undefined symbo= l "__h_error" in Unknown on line 0 On my 6-STABLE: > php -r '$conn =3D oci_connect("hr", "hr", "//localhost/XE");' Segmentation fault (core dumped) > gdb php php.core ... Core was generated by `php'. Program terminated with signal 11, Segmentation fault ... #0 0x48a771eb in ?? () from /usr/local/lib/php/20050922-debug/oci8.so [New LWP 100093] (gdb) bt #0 0x48a771eb in ?? () from /usr/local/lib/php/20050922-debug/oci8.so #1 0x48746b25 in __sigsetjmp () from /usr/local/lib/php/20050922-debug/oci= 8.so Previous frame inner to this frame (corrupt stack?) Same if using databases/pecl-PDO_OCI. Same for php-cli or when running from a threaded apache22. So ... does php5-oci work for you ? If so, could you please share your configuration ? (uname -a, php config, apache config, ...). Many thanks for your help, --=20 IOnut - Un^d^dregistered ;) FreeBSD "user" "Intellectual Property" is nowhere near as valuable as "Intellect" BOFH excuse #198: Post-it Note Sludge leaked into the monitor --Sig_vkgP/KTaNfqK3z2CkCc/Jxv Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (FreeBSD) iD8DBQFFFHA7BX6fi0k6KXsRArXqAJ9MSDUCRQ4t8yUuOGxgk4Cv96H1pQCaA+1Z f2kKis2cImfB7i6SQYYnUSc= =YLxG -----END PGP SIGNATURE----- --Sig_vkgP/KTaNfqK3z2CkCc/Jxv-- From owner-freebsd-database@FreeBSD.ORG Sat Sep 23 09:16:13 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D779516A9FA for ; Sat, 23 Sep 2006 09:16:13 +0000 (UTC) (envelope-from iobtxvykzml@est.it) Received: from est.it (cjm79.neoplus.adsl.tpnet.pl [83.31.62.79]) by mx1.FreeBSD.org (Postfix) with SMTP id 006E843D46 for ; Sat, 23 Sep 2006 09:16:12 +0000 (GMT) (envelope-from iobtxvykzml@est.it) Date: Sat, 23 Sep 2006 11:16:12 +0100 From: "Zuzana trstram" To: Cc: Message-Id: <7032347340.xRimbovv-53279-7643646@est.it> MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit Subject: Stock to Consider Right Now? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 23 Sep 2006 09:16:13 -0000 Company- A L L I A N C E E N T E R P R I S E Symbol - A E T R (Pink Sheets) C u r r e n t P r i c e: $ 0.48 Estimated Target - $ 2.00 + S T R O N G B U Y AE TR is undergoing a massive promotion and NOW is the time to get in. Add this Gem to your Watch list. Watch it Start a run monday About A L L I A N C E E N T E R P R I S E (.TaeCorp.) TaeCorp's vision is to be the recognized leader in providing Aerial Detection Systems including global de-mining, clearing a path to a safer planet for all humankind. TaeCorp's mission is to reclaim lands around the globe embedded with landmines that victimize countries and their stakeholders. N E W S TaeCorp Appoints TAM Oilfield Services as Representative in Sudan The A L L I A N C E E N T E R P R I S E Corporation ("TaeCorp") (AETR - News) is pleased to announce that it has appointed TAM Oilfield Services ("TAM"), of Khartoum, the capital of Sudan, as its representative to introduce and establish business relationships with oil and related companies interested in TaeCorp's unique landmine detection, location, mapping and removal systems and services. TAM Oilfield Services, established in 2001 under the laws and regulations of the Sudan government, has forged strong relationships with the leading petroleum companies that operate in the Sudan. "TAM's experience in the petroleum field, both with government and operating companies, will allow TaeCorp to 0ffer its services more efficiently and effectively and we are very pleased to have TAM join our team," says Ralph Proceviat, CFO of TaeCorp. Read more A C T N O W on this great news and get in before the move starts. You never miss the water till the well runs dry. Sitting on the fence. Say it with flowers. Save it for a rainy day. They're like two peas in a pod. Tossed around like a hot potato. Slow as molasses in January. Wait and see. Water under the bridge. The sharper is the berry, the sweeter is the wine. Putting the cart before the horse. Survival of the fittest. She's the apple of my eye. Your ass is grass. Root it out. Sweating blood. Read the tea leaves. You feel like a fish out of water.