googling didn't bring anything useful up.
Hopefully someone got some ideas to solve this problem :-)
Thank you in advance
Hannes Rohde
¯
incoWEB.de - agentur für neue medien
Stapenhorststr. 10
D-45329 Essen
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http
Hannes Rohde
¯
incoWEB.de - agentur für neue medien
Stapenhorststr. 10
D-45329 Essen
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.incoWEB.de
Phone Fax 0700-0-4626932
0700-0-INCOWEB
Diese E-Mail enthält vertrauliche Informationen, die nur für den o.g
status information basically showed that
the I/O Thread has been up to date and the SQL Thread of the slave lagged.
Thank you,
Hannes Rohde
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 10. Februar 2005 13:15
An: [EMAIL PROTECTED]
Cc: mysql
it wouldn't
speed up the SQL thread on the slave a whole lot. It would be excellent if
you could run two or more SQL threads on the slave you priories them
somehow.
Anyway I will try your last paragraph's suggestion.
Thanks,
Hannes
-Ursprüngliche Nachricht-
Von: Marc Slemko [mailto
as the
master is? In this case we are talking about one replicated database on a
dedicated slave system.
Thanks,
Hannes
-Ursprüngliche Nachricht-
Von: Mechain Marc [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 10. Februar 2005 12:04
An: Hannes Rohde; Marc Slemko
Cc: mysql@lists.mysql.com
Betreff
= 1M
query_cache_type = 2
max_connections=900
innodb_data_file_path=ibdata1:2G:autoextend
innodb_buffer_pool_size=1200M
innodb_additional_mem_pool_size=20M
P.S.: I hope I have given you enough information - it's my post on the
list...;-)
I appreciate your help,
Hannes Rohde
--
MySQL
on the server I'd like to connect to,
everythings fine.
MySQL seems to be able to connect to the other machine and the query is
started, but the error says it failed during query...
Thanks a lot for any hints!
Cheers,
Hannes.
---
Alles Kaufen und Verkaufen! eBay.at - der eigene Marktplatz für
I was wondering whether somebody on this list has successfully installed
MyODBC on AIX 4.3.3. I tried it today using the 3.51 binaries and could not
get it to work with either the latest iODBC or unixODBC driver manager. I
someone has experience I happy to post more detailed error messages.
On 3/29/03 7:55 AM, Marc Bakker [EMAIL PROTECTED] wrote:
Hello,
I am working on a PHP/MySQL/Apache website. I have a MySQL table with 5
rows. I want to select a patricular row using it's absolute row number. How
can I do this? I found mysql_row_seek() n te MySQL docs but this requires me
to
That is all ok but what do you suggest? Row level privileges are not
available in MySQL (yet). Or did I miss something?
Cheers/h
On 3/24/03 12:18 PM, Shawn P. Garbett [EMAIL PROTECTED] wrote:
On 3/24/03 10:37 AM, R. Hannes Niedner [EMAIL PROTECTED] wrote:
On 3/24/03 7:41 AM, Shawn P. Garbett
The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of
messages ago):
Functionality added or changed:
* `SHOW PROCESSLIST' will now include the client TCP port after the
hostname to make it easier to know from which client the request
originated.
I guess whenever
On 3/14/03 9:31 AM, Paul DuBois [EMAIL PROTECTED] wrote:
At 8:04 -0800 3/14/03, Thomas Knight wrote:
How do I change Mysql default database location?
Please explain what you mean by that?
Maybe you need to look at the commandline options or the my.cnf files. You
can specify the data
On 3/13/03 6:47 AM, Tom Norwood [EMAIL PROTECTED] wrote:
I am currently looking at building a Perl object to handle data from a
a database.
I'm not really sure if it is best to have one connection to MySQL and
let the object just deal with its own properties.
Or to allow the object to
On 2/7/03 2:20 AM, Vikram Vaswani [EMAIL PROTECTED] wrote:
Hello all,
My name is Vikram Vaswani, and I'm currently working on the outline for a
MySQL reference book. This is supposed to be a comprehensive reference to
MySQL 4, covering all aspects of the software, including the new
Soares [EMAIL PROTECTED] wrote:
Hi,
The MATCH() column list must exactly match the column list in some
FULLTEXT index definition for the table, unless this MATCH() is IN
BOOLEAN MODE.
from:
http://www.mysql.com/doc/en/Fulltext_Restrictions.html
On Thu, 2003-01-30 at 21:40, R. Hannes
If I create a FULLTEXT index for 2 or more columns in a table will I be able
to use it for a MATCH only against a single column (of the above) or do I
have to create additional FULLTEXT indices for each of these columns?
Thanks/h
sql,query,queries,smallint
On 1/28/03 3:42 PM, Jon Miller [EMAIL PROTECTED] wrote:
Warning: Access denied for user: 'root@localhost' (Using password: NO)
in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255
Warning: MySQL Connection Failed: Access denied for user:
'root@localhost' (Using password: NO) in
On 1/29/03 5:13 AM, Inbal Ovadia [EMAIL PROTECTED] wrote:
Hi All,
I have MySql on Windows.
Today i had an electrical power interruption in the middle of working.
The database remain not consistent and i could not continue working with it.
Is there any Recovery after crash mechanism in
On 1/28/03 8:26 AM, Christopher Lyon [EMAIL PROTECTED] wrote:
I am trying to do an sql query and am trying to select the last x rows
from the database. I see the limit function but that seems like that is
from the first row down. I want to start from the last row to the first
row. So,
. Hannes Niedner [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 11:50 AM
To: Christopher Lyon; MySQL Mailinglist
Subject: Re: sql query using select and row functions
On 1/28/03 8:26 AM, Christopher Lyon [EMAIL PROTECTED] wrote:
I am trying to do an sql query and am trying
Iwhat am I doing wrong:
After downloading the binary for mysql 4.09-max for Mac OS 10.2 safe_mysql
complains:
% sudo bin/mysqld_safe
The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
Please do a cd to the mysql installation directory and restart
this script from there
On 1/20/03 6:18 AM, Ram Kumar [EMAIL PROTECTED] wrote:
greetings
can anyone help to get mySQL on Mac OS X (entropy pkg), work on TCP/IP
rather than unix socket, please ?
Is Marc Liyanage on this list ?
regards, ram
I don't know if Mark is on the list, but I might have some suggestions
If you download the binary, there is nothing to compile. Just follow the
instructions in the file INSTALL_BINARY and you are ready to go. I did the
same on 10.2.2 server and it worked great.
Hth/h
On 1/20/03 2:21 PM, James LaFountain [EMAIL PROTECTED] wrote:
I've been trying to compile
On 1/8/03 8:34 AM, Rick Tucker [EMAIL PROTECTED] wrote:
I just imported a .csv file and one of the columns of data was websites
addresses. Those addresses aren't being recognized as links when I output
an html table from my queries. I'm scratching me head on how to make the
conversion. I
On 1/8/03 8:34 AM, Rick Tucker [EMAIL PROTECTED] wrote:
I just imported a .csv file and one of the columns of data was websites
addresses. Those addresses aren't being recognized as links when I output
an html table from my queries. I'm scratching me head on how to make the
conversion. I
On 1/1/03 8:43 PM, Jason Steig [EMAIL PROTECTED] wrote:
./myqld: Can't find file : './mysql/host.frm' (errno:13)
does anyone know how to solve this problem?
This file is part of the host table in your mysql database 'mysql'. Did you
by any chance copy the mysql data directory or parts of
On 1/1/03 5:46 PM, Richard Nagle [EMAIL PROTECTED] wrote:
Well it would appear that I finally have a connection
Congrats.
q. since I am root, do I still need to GRANT a database to myself?
or just a to a new user. aka: bob@localhost
If you are the only person using the computer that the
, we're looking at a permissions issue. Hannes needs to
look at the permissions on his data and logging directories to make sure
that they are set to the default mysql:mysql.
-Original Message-
From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 02, 2003 10:45 AM
On 1/1/03 2:31 PM, Richard Nagle [EMAIL PROTECTED] wrote:
Well after 3 times installing mysql, finally
got it working (tks to those whom help)
now I need to take care of user and root.
first root.
mysql mysql -u root mysql
just want to confirm this is correct before I push enter.
On 12/31/02 8:11 PM, JamesD [EMAIL PROTECTED] wrote:
lists work, and faq's work, some like to call...etc.
personally, I'd prefer a search engine style...
like google, but only for mySQL topics, and with
a visible list of most popular search terms.
something that can be based upon pages of
Scott Ambler recommends in his publication Mapping Objects to Relational
Databases not to do joins but to traverse tables. He claims that 'several
small accesses are usually more efficient than one big join'.
Is that true for mysql? I am particularly interested in a scenario where I
would
I am looking for an expert opinion on the speed difference between fetching
related data from 2 tables with a join and fetching them in to single
selects.
The scenario is kind of the following:
SELECT a , b, c FROM table1 WHERE a='x'; # gets b='y'
SELECT b, d , e, f FROM table2 WHERE b='y';
On 12/18/02 9:48 AM, Qunfeng Dong [EMAIL PROTECTED] wrote:
But I am indeed seeing
not-so-good performance (join on tables much smaller
than yours takes minutes even using index) and I seem
to read all the docs I could find on the web about how
to optimize but they are not working for me
Why
-- Forwarded Message
From: Joseph D [EMAIL PROTECTED]
Date: Wed, 18 Dec 2002 13:55:47 -0800 (PST)
To: R. Hannes Niedner [EMAIL PROTECTED]
Subject: Re: Can MySQL handle 120 million records? - Impressive! How do you
guys do that?
thanks i actually can't post anything to the newsgroup because
On 12/4/02 9:04 AM, Mike At Spy [EMAIL PROTECTED] wrote:
How can I tell what port number mysql is running on? I need it for a chat
program. :)
Thanks,
-Mike
Default is 3306
/h
-
Before posting, please check:
ALTER TABLE town_db1 DROP PRIMARY KEY;
ALTER TABLE town_db1 ADD PRIMARY KEY(town, subcity );
On 12/5/02 10:31 PM, kayamboo [EMAIL PROTECTED] wrote:
sql, mysql, query
Hello folks
This is my table structure with MySql 4.0.3-beta-max-nt with InnoDB
On 12/3/02 11:37 PM, Brian Radford [EMAIL PROTECTED] wrote:
Hello all,
Could someone be so kind and share with this newbie where he might find
crystal clear step-by-step instructions on how to install MySQL v3.23
on Mac OS X 2.2. I've looked through the manual and all I could find
was one
Maybe it's just to late for me to think clearly but there are NO INTEGERS
between 0 and 1, try FLOAT or DECIMAL.
Best/h
On 12/3/02 1:08 AM, Achille M. Luongo [EMAIL PROTECTED] wrote:
Dear subscribers,
MySQL seems to support the CHECK() clausole in the implementation of CREATE
TABLE
.
Thanks in advance for any other suggestion.
Achille.
R. Hannes Niedner wrote:
Maybe it's just to late for me to think clearly but there are NO INTEGERS
between 0 and 1, try FLOAT or DECIMAL.
Best/h
You are certainly correct, I tried all kinds of expressions and datatypes
and couldn't
On 11/27/02 1:24 PM, Tim V [EMAIL PROTECTED] wrote:
I am trying to create a new db in phpmyadmin with
MySQL 3.23.53a running on localhost.
SQL-query :
CREATE DATABASE `` gulf ``
MySQL said:
You have an error in your SQL syntax near 'gulf``' at
line 1
Why am i getting
On 11/24/02 4:30 PM, Bruno Batarelo [EMAIL PROTECTED] wrote:
The question is what does Access do in order to perform subqueries on MySQL
via MyODBC driver since it is obvious that they work? What can I do, but I
do not want to use access database as a layer between my application and
mysql
On 11/22/02 4:32 AM, Stu Duncan [EMAIL PROTECTED] wrote:
Try going to
http://www.entropy.ch/software/macosx/mysql/
It's the best Mac MySQL reference around (but seems to be down this
Friday AM). I've used version 3.23.52-entropy.ch on a low bandwidth
website with no problems at all.
HTH,
I am planning on setting up mysql server on a Mac OS 10.2.2 Server running
on a Xserve machine. It will be a development system for now, but I still
want end up with a good usability status. The server will run Perl, PHP,
Apache/Tomcat, Mysql to start with.
Are there any recommendations or
On 11/12/02 12:41 PM, tmb [EMAIL PROTECTED] wrote:
2 - In MS Access you have to graphically connect the
table id fields to tell Access how the tables relate.
How do you do this In MySQL... from the command line
I'm sure... just a code snippit or reference to one
would be nice...
You join
On 11/12/02 12:43 PM, Charlie [EMAIL PROTECTED] wrote:
I can't seem to come up with a solution to the following SQL query, and have
a project dependent on a solution. I'd rather not load the whole database
and then parse it in the code.
With the following Database structure:
Field0 Integer
On 11/12/02 5:36 PM, Alan McDonald [EMAIL PROTECTED] wrote:
You can't count the join?
Alan
Hello all,
Does anybody have a SQL string to count the rows in two different
tables and
give you a total number of rows? I have been trying to find an
answer for a
couple of days and seems like
On 11/12/02 7:05 PM, Daniel Griggs [EMAIL PROTECTED] wrote:
Hi there,
I am having trouble with connecting to a Mysql host, the host version is
3.23.51 on debian stable. After countless re-
reads of the documentation and checking the permissions all I get when I try
to connect regardless of
On 11/12/02 8:59 PM, Phillip Rhodes [EMAIL PROTECTED] wrote:
I can not find anywhere that says that mysql supports table name synonyms.
For example, I have two databases (test1 and test2) in the same mysql
instance.
In test1 schema, there is a table called table1
I would like to create
I try to access thesearchable documentation with user comments:
http://www.mysql.com/doc/en/index.html
And get:
Forbidden
You don't have permission to access /doc/en/index.html on this server.
Apache/1.3.26 Server at
On 11/11/02 9:10 AM, Inbal Ovadia [EMAIL PROTECTED] wrote:
Hi all
I am working with mysql, in windows, visual c++.
I am trying to run this query from c++ program:
select * into outfile 'table_name.txt' FIELDS TERMINATED BY '\t' ESCAPED BY
'\0' LINES TERMINATED BY '\r' from table_name
On 11/11/02 9:26 AM, Victoria Meza [EMAIL PROTECTED] wrote:
I've a problem whit some tables in mysql, you know how repair damages
tables?
this is the message error:
Didn't find any fields in table 'criterios_evaluacion'
Didn't find any fields in table 'mensaje'
Didn't find any fields in
On 11/10/02 1:50 PM, Allan J Horwitz [EMAIL PROTECTED] wrote:
Hi there -- I'm relatively new to LINUX (I have RedHat 8.0 on my system)
and I just downloaded MySQL-GUI and can't seem to get it working. It
keeps telling me that it cannot connect through the socket (111). Can
someone tell me
On 11/10/02 9:14 PM, daniel [EMAIL PROTECTED] wrote:
running on localhost using the socket connection (as supposed to
tcp/ip ).
what are you saying that mysql can connect another way other than through
mysql.sock ?
If I am not mistaken the socket works only for a connection between server
On 11/10/02 9:42 PM, daniel [EMAIL PROTECTED] wrote:
i've made connections to a remote mysql from one server to our main one and
the main one is running socket connections ?
I guess I lost you.
All I wanted to say is this:
If you run mysql (client) and mysqld (server) on the same computer you
On 11/9/02 3:01 AM, Bruno Batarelo [EMAIL PROTECTED] wrote:
Greetings
I have problems executing very simple UPDATE query. I do not know whether it
is a bug or not, but it works in Access and also works with mySQL, but only
from access using linked tables.
Query is as followes:
UPDATE
On 11/9/02 3:14 PM, 3mip1s4la-Emilio Pisanty [EMAIL PROTECTED]
wrote:
hello everyone:
to begin with, I apologise for asking a question which is probably
obvious. My name is Emilio Pisanty and I and one of the two makers of my
school's website. recently we updated the database system (on
On 11/10/02 5:12 AM, Robert Macwange [EMAIL PROTECTED] wrote:
I am bothers me.
It bothers me that that the MySQL people have a bias towards PHP.
PHP is an inferior language. Deal with perl instead.
Robert
Ouch.Death to all fanatics!!!
Do you have any
On 11/9/02 11:31 PM, Georg Richter [EMAIL PROTECTED] wrote:
Looks like you're not very familar with the spirit of Open Source:
Perl, PHP, Python, Ruby etc. are very excellent languages. They all have
benefits and of course some disadvantages. But this competition helps each
one to improve
On 11/9/02 11:04 PM, Paul DuBois [EMAIL PROTECTED] wrote:
I agree. It's really a drag that you can't use databases very well from
within Perl very easily. I wish that someone would invent a database
inferface for Perl. And it'd be really cool if they'd do it in such
a way that the general
On 11/9/02 11:04 PM, Paul DuBois [EMAIL PROTECTED] wrote:
I agree. It's really a drag that you can't use databases very well from
within Perl very easily. I wish that someone would invent a database
inferface for Perl. And it'd be really cool if they'd do it in such
a way that the general
-length
columns and reverts the changed column back to VARCHAR to save space. To
deal with this, change all the VARCHAR columns at the same time:...
ALTER TABLE branch MODIFY codebase CHAR(32) NOT NULL DEFAULT 'Ipriori',
MODIFY other_varcharfield CHAR(?) ;
Hope that helps
Hannes
On 8/1
Eric Chan
You could escape the the double quotes before sending them to mysql like so:
$formdata =~ s//\/sg; #this is valid for perl
Hope that helps.
Hannes
-
Before posting, please check:
http://www.mysql.com/manual.php
) ^ = start of the line: $ end of the line
12) . = any character except a new line (\n)
13) # = comment
I hope that gets you started.
Hannes
And remember clicking just the reply button in response to messages from the
MySQL list will send just to the person who posted the message, you have to
add
for
your goal.
Hannes
On 7/28/01 10:46 AM, Kit Kerbel [EMAIL PROTECTED] wrote:
Hello,
I was wondering if anyone could give any advice on how to go about parsing a
plain text file into a mysql database. I have a class Roster table that I
need to parse a text file into. I already have
.
Although there might well be smarter methods out there.
Hannes
On 7/4/01 8:19 AM, Graham Nichols [EMAIL PROTECTED] wrote:
Hi,
Can I copy a table (structure only) to another database? I've searched
though my manuals without success so far.
kind regards, Graham
greatly appreciated.
Hannes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
Thanks Karel,
This worked almost out of the box, just needed to find out that 'len+1' has
to be replaced with the actual number and is not automatically set (like len
= length('CONSTANT%'). But the manual also explains this very well, I just
didn't think of substring.
Hannes
On 7/3/01 9:13 AM
Has anybody successfully compiled MySQL GUI on the Mac OS X platform (or
rather Darwin)?
Hannes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
hannes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
Sorry, for quoting the manual but this might be just another example where
it could have the answer right away:
Hannes
http://www.mysql.com/doc/D/A/DATETIME.html
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date
you could assign a combined primary key from those columns). But you are
certainly right that this is not needed if you don't need the feature to
access the differences created by extra fields among these identical tuples
by using count(), max(), min() and so on.
Cheers Hannes
Try this:
CEATE
Thomas
You might want to consider to post a sample select from the table, some
things become apparent just then.
Hannes
On 6/27/01 3:35 AM, Thomas Michael Koch [EMAIL PROTECTED] wrote:
Hey Hans - it didn't work (damn) but thank you for your reply and sorry
about the accidental mail you got
/SELECT.html
Hannes
On 6/27/01 1:13 PM, Pete Kuczynski [EMAIL PROTECTED] wrote:
Hi,
How would a word a select statment, to search a database for duplicate
entries in one field.
For example, the fields: device, hostname, IP, comments
I want to find all instances where there my be two
it was first thing in the morning.
Hannes
On 6/26/01 4:05 AM, Thomas Michael Koch [EMAIL PROTECTED] wrote:
Hello there - I have this weird problem using MySql (version 3.23.39).
It seems that MySql interpretation of a SELECT statment using HAVING is
completely random.
I have a table called RobotRun
Could it be that you have two mysql client binaries accessing two different
config files - some remainders of a previous MySQL installation?
Hannes
On 6/26/01 9:02 AM, Peter Matulis [EMAIL PROTECTED] wrote:
Just installed 3.23.37 on Red Hat 7.0 from source. I've done this a few
times
;
table_distinct_records
field_1 field_2 field_3
a b c
a b d
f g h
d j k
k i o
Got the idea?
Hope that helps
Hannes
On 6/26/01 4:00 AM, tom harrow [EMAIL PROTECTED] wrote:
Hi Hannes
I saw your reply to a question
in the 'select' and in the 'group by' part. More in the really good manual).
I hope that accomplishes what you wanted.
Hannes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Just if somebody is interested:
I solved the mystery with Error 19. All I needed to do was introducing a
second statement handle for the update query.
(BTW, the script runs probably faster using '$sth = $dbh-do' instead of
'$sth = $dbh-prepare', followed by '$sth = $dbh-execute').
Hannes
be delighted to learn about.
Thanks Hannes
-snippet-
#issue query
$sth = $dbh-prepare ( SELECT primary_id, other_id
FROM merge
ORDER BY other_id
integrity rules.
Thanks Sinisa,
So is there any command suffix in mysql that sends the query in the
background (letting the server doing the query without talking back to the
client) like using the on the unix commandline - resulting in any query
being completed after quitting the client.
Hannes
with mysqladmin which doesn' give
me any clue how long I still have to wait.
Comments appreciated
Hannes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
a unique index for that field?
Details in the manual.
Good luck
Hannes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
database hosting to developers
Visit http://www.freesql.org
- Original Message -
From: Hannes Niedner [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 5:48 PM
Subject: Select query
What do I do wrong? The query result is not supposed to be an empty set
| int(10) unsigned | | | 0 | |
| mol_wt | float(10,2) | YES | | 0.00| |
+-+--+--+-+-+---+
Thank you
Hannes
-
Before posting, please check
.
I am running out of ideas.
Hannes
mysql select sequence_id, mol_wt from sequence_protein limit 1;
+-+--+
| sequence_id | mol_wt |
+-+--+
| 100368 | 53211.62 |
+-+--+
1 row in set (0.02 sec)
mysql select sequence_id from
. Thanks for your input.
Gene Sanborn
Standard port is 3306
Hope that helps Hannes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
with the same data (1 row of the file) everything is
fine.
Thanks Hannes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
Hi List, I'm new to the list
and I have a BrainTeaser for all of you.
I have yet lots to learn about sql and mySQL so any suggestions are very welcome!
Thanx in advance
Hannes
I have following select over a Database that I cannot setup myself, but have to take
on as is:
SELECT
88 matches
Mail list logo