Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 5

Displaying posts with tag: faq (reset)

Q/A on Kontrollbase slow/gen query logs and processlist
+0 Vote Up -3Vote Down
posted by Matt Reid on Tue 05 Jan 2010 09:47 UTC
Tags:
(edit) mysql, faq, support, general log, slow log, processlist, announcement, Q/A
I recently was asked the following from a Kontrollbase user via email. Since this question might be asked by others I’m posting my response so that the user community can have the answer available right here, right now. Question “I am unable to locate the slow / general queries list as well as processlist. Does [...]
FAQ: Lost connection to MySQL server?
+0 Vote Up -0Vote Down
posted by of team blog SciBit on Wed 15 Feb 2006 06:36 UTC
Tags:
(edit) mysql, faq
This error usually pops up at the most unexpected times and places, and usually in an already working client application/website.

Here are a couple of reasons you get this error on the client-side while communicating with MySQL:

1. BLOBs

Another primary cause for this error, is when you update or select tables containing large blobs. By default MySQL's max_allowed_packet is set to 1MB. Should your update-SQL grow larger than this MySQL parameter, MySQL will simply drop the connection. This can easily happen with even a 512MB blob value, as blob values are usually hexed and thus takes two hex values per byte of the blob.

2. Client Timeouts

Most MySQL servers have at least three primary timeout settings for a client connection, connect, read and write timeouts. These control how long your client should wait for a response from the server when it









  [Read more...]
Docbook XHTML generation with tidy, chapter the third
+0 Vote Up -0Vote Down
posted by C.J. Collier on Mon 01 Aug 2005 18:26 UTC
Tags:
(edit) mysql, work, html, tidy, maxdb, faq, docbook
In chapter the first, I presented a way to install HTML tidy.

In chapter the second, I created a script to install the most recent version of tidy with a single command.

In this chapter, I will show you how to run tidy in a way that cleans up the HTML that was generated by Office™.
Docbook XHTML generation with tidy, chapter the second
+0 Vote Up -0Vote Down
posted by C.J. Collier on Sun 31 Jul 2005 19:21 UTC
Tags:
(edit) mysql, work, html, tidy, maxdb, faq, docbook
In Chapter the First, we presented a set of commands you could run to install HTML Tidy on your system.

In this chapter, we will present a script that you may run on your Linux or OS X system to install the most recent version of HTML tidy.

You may use subversion, wget, or your favorite browser to retrieve the most recent version of this tidy installer.

I'm writing a perl script using Commands::Guarded to automate what I did in the first article.

You may retrieve the source with wget, so:
$ wget -r http://colliertech.org/svn/genDocbook

Or subversion, so:
$ svn co svn://colliertech.org/genDocbook

You may also get the most recent version of the individual files in the distribution using your favorite











  [Read more...]
Docbook XHTML generation with tidy, chapter the first
+0 Vote Up -0Vote Down
posted by C.J. Collier on Fri 29 Jul 2005 03:28 UTC
Tags:
(edit) mysql, work, sysadmin advice, html, tidy, maxdb, faq
So I'm getting the new version of the MaxDB FAQ ready for production. We used Microsoft Word to create the document and manage corrections. And then I exported to HTML. Word did a terrific (note that the root word here is "terror") job of translating to HTML, and Tidy won't touch it unless I fix some issues manually.

So here I go.

Getting most recent build from cvs:

$ cd ~/src/
$ cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/tidy login
$ cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/tidy co tidy


Building said code:

$ cd tidy/build/gmake
$ make

ld: archive: ../../lib/libtidy.a has no table of contents, add one with ranlib(1) (can't load from it)
make: *** [../../bin/tidy] Error 1

$ ranlib ../../lib/libtidy.a
$ make


Running code:

$ cd ../../bin
$ ./tidy -h
$ open














  [Read more...]
Showing entries 1 to 5

Planet MySQL © 1995, 2013, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.