Hi,
First of all thank you all for the quick replys.
Now here's:
select * from events limit 10;
+--+--
--+++--+-+---+--+---+--
+
| id | user_id | dep_id | event_id | year | day | month | ev_status |
ev_type | ev_priority |
| 12
- Original Message -
From: "Michael J. Pawlowsky" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>;
Sent: Wednesday, April 06, 2005 7:51 PM
Subject: Re: I need some help
> Rhino wrote:
>
> >- Original Message -
> >From: "iNFERNo" <[EMAIL PROTECTED]>
> >To: "mysql"
> >Sent:
I am looking for a nice OS X GUI client, can be java for osx that works
w/ mysql 5.x.
(these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but
I want a bit more, like Maestro for OS X).
what should I use?
tia,
.V
--
MySQL General Mailing List
For list archives: http://lists.mysql
I am looking for a nice OS X GUI client, can be java for osx that works
w/ mysql 5.x.
(these don't work MacSQL, CocaMySQL, YouSQL. MySQK admin does work, but
I want a bit more, like Maestro for OS X).
what should I use?
tia,
.V
--
MySQL General Mailing List
For list archives: http://lists.mysql
Dear All,
Just to get a better understanding of how indices work in MySQL - If I
have a Innodb table with a composite primary key (fld1,fld2,fld3,fld4,fld5),
then my understanding is that MySQL optimizes just the leftmost primary key
(fld1 in this case).
Hence a query like select * from tbl1 w
On Wednesday 06 April 2005 20:05, jon wrote:
> Normal recovery seems to grab 490 rows... but, originally there were
> some 22 million rows in there.
Seems your data file was corruped too not only the indexes. and probably broke
when updating the 491st registry... try use myisamchk -e
-e, --ext
Rhino wrote:
- Original Message -
From: "iNFERNo" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Wednesday, April 06, 2005 5:23 PM
Subject: I need some help
Hi,
I have a problem: I am using mysql 4.0.24 and I need to make
some reports from a database:
mysql> describe events;
+--
Hey folks...
While we weren't paying attention, one of the tables we were logging to
got big. Really big... like over 2 gigs... and then the server crashed
and the data became corrupt.
'Course, we'd like that data back...
Normal recovery seems to grab 490 rows... but, originally there were
some
- Original Message -
From: "iNFERNo" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Wednesday, April 06, 2005 5:23 PM
Subject: I need some help
> Hi,
>
> I have a problem: I am using mysql 4.0.24 and I need to make
> some reports from a database:
>
> mysql> describe events;
>
> +---
Hi,
I have a problem: I am using mysql 4.0.24 and I need to make
some reports from a database:
mysql> describe events;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--
On Apr 6, 2005, at 2:12 PM, Michael Stassen wrote:
On Apr 5, 2005, at 11:37 PM, Matt Wagner wrote:
Hi,
A new version of MySQL Community Edition 4.1.11 Open Source database
management system has been released. It is now available in source and
binary form for a number of platforms from our download
> Does Debian package preserve a master.info and relay-log.info files?
I'll check with some Debian experts.
> Do you stop slave before the upgrade?
No.
> What does the 'SHOW SLAVE STATUS'
> statement report?
Before that everything is ok, after I don't know now that it is
running ok, but I'll
I have looked around in the documentation but I do not have a clear
idea of log_bin vs ib_lofile for innodb.
Regarding only INNODB tables, am I right if I say that:
log_bin are the commit transactions and it is what is use in an
automatic recovery or are to be apply in a manual recovery fro
On Wed, 2005-04-06 at 09:55 -0500, Robert Citek wrote:
>
> Is using MyODBC the accepted way to connect to a MySQL database from
> within an ASP/VBScript page? Or is there some other way? For example,
> PHP has a connector that can directly connect to a MySQL database.
I believe it's the only
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
For the nams. tables the badge is the primary key, and since the
stored procedure and the dynamically generated function generate the
same queries, it shouldn't matter as to performance.
I am using Solaris 8, JDK1.5, mysql 5.0.3
I haven't tested
According to perror:
perror 9
Error code 9: Bad file number
This is an operating system error code:
http://dev.mysql.com/doc/mysql/en/operating-system-error-codes.html
Out of curiosity, have you tried running myisamchk or some CHECK TABLE
commands yet?
http://dev.mysql.com/doc/mysql/en/table-ma
At 10:07 AM 4/5/05, Frank Bax wrote:
At 04:27 PM 4/4/05, Frank Bax wrote:
Cannot execute query.
Can't find file: './donor/list_lst.frm' (errno: 9)
- -
I got the same error last week on a different table. Today I notice that
there is a table in another database on same system producin
I tried the query defined in the Go Example queries:
and added some filtering on t.term_type, t.is_root and t.is_obsolete
Finding all ancestors of a term:
SELECT p.*
FROM
graph_path
INNER JOIN
term AS t ON (t.id = graph_path.term2_id
and t.term_type="biological_process")
INNER JOIN
term A
On Apr 5, 2005, at 11:37 PM, Matt Wagner wrote:
Hi,
A new version of MySQL Community Edition 4.1.11 Open Source database
management system has been released. It is now available in source and
binary form for a number of platforms from our download pages at
http://dev.mysql.com/downloads/ and mirror
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
It would appear, based on my testing, so far, that using stored
procedures is some between 25% slower and 10x slower, depending on the test.
I am using jdk1.5, on Solaris 8, and mysql 5.0.3.
I hope that when 5 comes out of beta that the performance i
After executing de command make I have the next error
make: Fatal error: Don't know how to make target `ctype-big5.lo'
Current working directory /2ndhd/MYSQL/one/mysql-4.0.21/libmysql_r
*** Error code 1
make: Fatal error: Command failed for target `all-recursive'
Current working directory /
Unless something has radically changed since 4.1.2 then prepared
statements (at least from c) are 50% slower than executing statements as
required. Search for posts by me on the subject from last year.
Kevin Cowley
Product Development
Alchemetrics Ltd
SMARTER DATA , FASTER
Tel: 0118 902 9000 (swit
Hi all
Suppose that I want to create a table with a column named "DETAILS" that
will contain textual data. Performance-wise, does it matter if I represent
this column with, say, a 200-char varchar or a larger type like text or
mediumtext but be sure that only textual data smaller than 200 chars
Robert Citek <[EMAIL PROTECTED]> wrote on 04/06/2005 10:55:07
AM:
>
> On Monday, Mar 7, 2005, at 16:04 US/Central, [EMAIL PROTECTED] wrote:
> > It would be happy to try to help if I worked in or on either of those
> > platforms (Apache + Java). I am Win32(IIS), ASP (VBScript/JavaScript)
> > usi
I think they are sorted by how many draws each word has.
Zhi
"Shuming Wang" <[EMAIL PROTECTED]> wrote:
>
>mysql 4.1.x :Latin1, the select resualt is disorder:
>shoud be axx
> Â Â Â Â bxx
> Â Â Â Â hhh
>
> Â Â Â Â Â ...
> Â Â Â Â Âzxx
> Â Â Â Â Âääæ
> Â Â Â Â Âæé Â Â Â Â
> Â Â Â Â Âéç
> Â Â Â
mysql 4.1.x :Latin1, the select resualt is disorder:
shoud be axx
bxx
hhh
...
zxx
保丽来
普通
铜片
but actual:
axx
bxx
hhh
铜片
...
zxx
There was a magazine "Database Programming & Design", now defunct...too
much detail for the average IT Manager so it didn't sell well...that did
a nice multi-part series on the subject. Including the SQL3 connection.
I could only locate a couple of fragments online...it used to be all
online if you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Are prepared statements cached on the server side? When I create a
prepared statement with one connection, and another connection tries to
create the same prepared statement, will the cached one be used?
I am trying to see when prepared statements wo
Yes, but not in the way you're thinking. I believe what you
want is one slave with multiple masters, which AFAIK is not
supported.
==> STOP READING NOW UNLESS YOU ARE A GENIUS/MADMAN/IDIOT <==
That said, I suppose you could theoretically set up multiple
servers on your slave machine, where:
- All s
On Monday, Mar 7, 2005, at 16:04 US/Central, [EMAIL PROTECTED] wrote:
It would be happy to try to help if I worked in or on either of those
platforms (Apache + Java). I am Win32(IIS), ASP (VBScript/JavaScript)
using MyODBC as my connection library.
Is using MyODBC the accepted way to connect to a
3000 rows are no big deal. 7 to 8 seconds seems long. Most likely,
there is either something wrong with your query, or you are missing a
needed index.
We can't tell you how to improve your query, however, without seeing
the query. We can't tell you if the table structure is the problem
with
Hi,
I have a problem with mysqldump when I want to copy a table from a database.
I have mysql Ver 14.7, Distrib 4.1.9, for pc-linux-gnu.
I use the following command:
mysqldump -h host -u user -ppassword database_name table_name >
table_name.sql
And get the following error message:
mysqldump: m
At 18:35 01.04.2005, Gleb Paharenko wrote:
Hello.
I don't have any ideas at least now. But additional information could be
helpful. Do you connect from JBoss to the slave or master server? Please use
We are conecting to the active mysql (normaly master).
SHOW PROCESSLIST to find in what state the s
> >>Sorry, I don't use windows 8-) except when I have to. All my servers are
> >>unix/linux and I can build them at will. I think there are instructions
> >>in the manual for building it but I think you would probably have to
> >>purchase a C++ compiler or similar.
> >
> >
> > Exactly the reason wh
Martijn Tonies wrote:
Sorry, I don't use windows 8-) except when I have to. All my servers are
unix/linux and I can build them at will. I think there are instructions
in the manual for building it but I think you would probably have to
purchase a C++ compiler or similar.
Exactly the reason why I
Hi!
MySQL/InnoDB-4.1.11 is a bugfix release of the stable 4.1 branch. This
branch is recommended for production use. There are no important bug fixes
in 4.1.11, for most users there is no need to upgrade from 4.1.10.
InnoDB is the MySQL table type that supports foreign key constraints,
transact
thanks for the hints date_format() solved my problem my select query in php is
now
the following:
$query = "SELECT id, calltt, date_format(calldate, '%d-%b-%Y') AS calldate2,
date_format(calltime, '%H:%i') AS calltime2,area, problem, solution, assignto,
status FROM ticketing ";
hans
Rhino wrot
On Wednesday, April 06, 2005 02:30, Martijn Tonies wrote:
>> Sorry, I don't use windows 8-) except when I have to. All my servers
>> are unix/linux and I can build them at will. I think there are
>> instructions in the manual for building it but I think you would
>> probably have to purchase a C+
- Original Message -
From: "Hans Bernard" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, April 06, 2005 6:06 AM
Subject: DATE & TIME
> Hello,
>
> i need to have the time in this output. in MySQL database
> phpmyadmin always puts -00-00
>
> i need it to be like this
> 01-APR-2005 >> DD-M
On Wed, Apr 06, 2005 at 12:06:37PM +0200, Hans Bernard wrote:
> i need to have the time in this output. in MySQL database
> phpmyadmin always puts -00-00
>
> i need it to be like this
> 01-APR-2005 >> DD-MMM-
Use date_format(, "%d-%b-%Y %H:%m") in your SELECT?
bye,
-christian-
--
hi All,
I am trying to fech some data from some interrelated tables. I am using
inner joins to relate tables. but mysql takes 7-8 sec to execute the query.
What could be the reason of such delays ? I would like to specify that one of
the interrelated table contains around 3000 rows.
Ken
Looks like you used a medium int field on the mysql table - if you import a
figure that is too big for the medium int to handle - on overflow it places
a value of 8388607 into the colum. You need to change to an integer column.
Regards
Tim hayes
-Original Message-
From: [EMAIL PROTEC
Hello.
When the server starts, it initializes all global variables to their
default values. These defaults may be changed by options specified in
option files or on the command line. After the server starts, those
global variables that are dynamic can be changed by connecting to the
server
Hello.
For your situation a slow query log might be suitable. See:
http://dev.mysql.com/doc/mysql/en/slow-query-log.html
[EMAIL PROTECTED] wrote:
>
> It has been a rough day today. I am using mysql with coldfusion. Something
> somehwere on my site is causing mysql to take up 10
Hello.
Replication should work with MERGE tables. You may make a test
setup and check your scenario.
Eric Anderson <[EMAIL PROTECTED]> wrote:
>
> Here's a question for you guys: is it possible to have a replicated
> table of type MERGE?
>
> Scenario:
>
> Server: WWW1
> Table:
Hello.
Does Debian package preserve a master.info and relay-log.info files?
Do you stop slave before the upgrade? What does the 'SHOW SLAVE STATUS'
statement report?
Jacob Friis Larsen <[EMAIL PROTECTED]> wrote:
> I use Debian Sarge as my Linux distribution on two servers who replicate
Hello,
i need to have the time in this output. in MySQL database
phpmyadmin always puts -00-00
i need it to be like this
01-APR-2005 >> DD-MMM-
the time needs to be like this
22:55 >> HH:MM
can somebody help
hans
--
MySQL General Mailing List
For list archives: http://lists.mysql.
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes:
> I have loaded a large *.csv spreadsheet into mysql and one number, the
> grand total, changes from 16996941 on the Excel spreadsheet to 8388607
> in the mysql database. The numbers surrounding this number are
> correct at all stages. I
Gleb Paharenko wrote:
Hello.
Among other things check that you correctly process lock timeouts.
I've check this, but it seems fine.
I'm testing it this way with 3 applications on the same computer (2
processors) :
- 2 clients applications with an open connection to the DB (which is
remote with si
> Sorry, I don't use windows 8-) except when I have to. All my servers are
> unix/linux and I can build them at will. I think there are instructions
> in the manual for building it but I think you would probably have to
> purchase a C++ compiler or similar.
Exactly the reason why I do NOT want t
Sorry, I don't use windows 8-) except when I have to. All my servers are
unix/linux and I can build them at will. I think there are instructions
in the manual for building it but I think you would probably have to
purchase a C++ compiler or similar.
Regards
David Logan
Database Administrator
HP
Ah David,
> >From the documentation referred to in the link
>
> 14.8. The CSV Storage Engine
>
> The CSV storage engine was added in MySQL 4.1.4. This engine stores data
> in text files using comma-separated-values format.
>
> To enable this storage engine, use the --with-csv-storage-engine option
>From the documentation referred to in the link
14.8. The CSV Storage Engine
The CSV storage engine was added in MySQL 4.1.4. This engine stores data
in text files using comma-separated-values format.
To enable this storage engine, use the --with-csv-storage-engine option
to configure when you b
> You could use the CSV table type:
> http://dev.mysql.com/doc/mysql/en/csv-storage-engine.html
Interesting. I just downloaded 4.1.11 - how does one enable
this engine?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Produc
54 matches
Mail list logo
