Re: InnoDB migration between servers

I can now isolate the problems with the appearing "lock" of some queries. I updated MySQL from 4.1 to 5beta (mysql-standard-5.0.10-beta-linux-x86_64-glibc23) to test if the problem still appears in the newer version. I made a full sqldump on the old server and import it successfully on the new

counting question

Hi, I have three simple tables: user { id int PRIMARY name varchar UNIQUE } skill { id int PRIMARY skill_name varchar UNIQUE } user_skill { user_id int skill_id int UNIQUE KEY id (user_id, skill_id) } Each user can have zero or more associated skills. So you might have these a

Re: MySQL vs XML

MySQL is a relational database. XML is a text file. the biggest difference is that MySQL will let you organize, sort, match/link (joins), and otherwise manipulate the data you have. XML is just text with tags in a heirarchy; anything other than reading it in a text editor will take programming

Good Oracle Forum

This forum has been very helpful. There is always somebody that is willing to respond to queries. Does anybody know of a good Oracle forum? TIA Dan

Re: SELECT by LEFT(col,1)="{letter}" ?? improvements and sarge update to 4.1

Hello. I'm unable to give you suggestions, because I don't see the whole picture of your data structure. Please, next time forward your messages to the list. Chances to receive a good advice are greater. Send good model of your databases (use 'SHOW CREATE TABLE' to represent your tables).

Re: Mysql 4.1. my-large.cnf or my-medium.cnf? Dual Opteron web server 2gb memory

Privet! What hardware does your server have? What version of MySQL have you tested? If key_buffer_size isn't enough for indexes of smacker's table then performance could go bad (in my my-medium.cnf it is only 16M). Thread cache gives performance hint for my-large.cnf. Add SQL_NO_CACHE to q

Re: Blob retrieval from database using shell

Hello. Maybe mysql puts the name of the column (firmwareimage), at the beginning of the output (--skip-column-names should prevent it). Rakesh Gupta <[EMAIL PROTECTED]> wrote: > > > > > Hi There, > I am trying to insert blob in table and then retrieve it from table using > Lin

Kindly help me in generating optimal report in Nessus through MYSQL

hi I have a requirement in generating a report in Nessus, Can you kindly help me on this.I am using nessus in my office.I generated a report through nessusWX in windows HTML format.In the report a column named description having description,solution and warning indicated as *** for each services.

INSTALL-SOURCE is size 0

Hi, I downloaded mysql-5.0.10-beta.tar.gz. INSTALL-SOURCE is size 0. drwxr-xr-x2 fuji user 4096 7月 23 04:50 BUILD -rw-r--r--1 fuji user19071 7月 23 04:42 COPYING -rw-r--r--1 fuji user 195900 7月 23 04:42 ChangeLog drwxr-xr-x3 fuji user

MySQL vs XML

I've been gathering data for an animal kingdom database for quite some time and am now trying to figure out how to organize and display it. So far, I have a table that lists every order, suborder, family, subfamily, genus and species of mammal in a child-parent relationship, like this: NAME | PARE

file in windows TEMP

HI It looks like MySQL has left a 3GB file in WINDOWS/TEMP. The date of last modification was nearly 2 months ago and I use MySQL on a daily basis. Can I remove this ? Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/

Query - question

How can I join two tables looking like this? Table 1: ++---+---+ | Id | Name | Score | ++---+---+ Table 2: ++---+---+---+ | Id | Name | Score | Info | ++---+---+---+ To get output table like this: Table 2: ++---+---+--

Mysql 4.1. my-large.cnf or my-medium.cnf? Dual Opteron web server 2gb memory

Hello. my-large.cnf is twice quicklier, but the description from my-medium.cnf is approaches (such as a web server). It is necessary that Mysql worked twice more slowly on a web server? amd64# uname -r 5.4-STABLE make WITH_XCHARSET=all BUILD_OPTIMIZED=yes BUILD_STATIC=yes install