If so, how is it working out? Are you taking advantage of the
64bit memory space?
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,151,820,403 queries (426/sec. avg)
--
I want to speed up a large query and I noticed if I do an:
Explain select * from LargeTable order by IndexCol1
it always has Extra "Using FileSort", which means it is physically sorting
the result set.
I've tried different tables and sorted on different index columns, and it
is always using Fil
Dathan Vance Pattishall wrote:
Look at your wait_timeout and interactive_timeout settings. They may be
set to a low value. If your connection sleeps for > these 2 vars mysql
will disconnect you.
- Dathan Vance Pattishall
-->Subject: Connection Time Out
-->
-->
-->Splain this to me: I use my la
I have both the standard and source mysql, and I am attempting a link with a
simple program that calles mysql_server_init and mysql_server_end.
I have tried various library call outs to find these two calls in both the
standard and source mysql directories.
I have not located these in any of th
Hi
We have just release Rekall V2.1.0 beta4. There have been no new features
added but we have fixed many bugs both large and small. You can download the
demo from either http://www.totalrekall.co.uk or from
http://www.rygannon.com
If all goes well this will be the final beta release
Regards
John
Uberdumb question - but I'm still enough of a newbie that this is giving
me fits...
I have four tables, with relevant columns as follows:
++ ++
group zip
-- --
name varchar city_id int
zip mediumint zip mediumint
MySQL, Second Edition, is now available in Czech.
Information is available at:
http://www.kitebird.com/mysql-book/
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
>Description:
Mysql 4.0.15 from ports on FreeBSD 4.7 has this repeated many times in
the logs while under heavier loads:
Warning: thr_alarm queue is full
Threads get disconnected when this happens. I assume it is the thread
that has this problem:
("..."=removed sensitive data)
DBI->connect(.
At 17:22 -0300 10/14/03, Daniel Franco wrote:
InnoDB uses some log files that are placed in the directory 'MySQL / data'.
What are those files ? Why and when InnoDB needs to save those logs ?
InnoDB uses them to record ongoing changes being made by transactions,
and for auto-recovery after a crash.
InnoDB uses some log files that are placed in the directory 'MySQL / data'.
What are those files ? Why and when InnoDB needs to save those logs ?
I had a problem whith those files and now all my InnoDB stopped working,
only the MyISAM tables are working, how can I recovery data from them ?
--
My
Does thread_concurrency work for x86 Linux systems? If so, if a thread
is waiting for a table (locked, etc.) does that mean the thread in
question could use up a one of the thread_concurrency pooled values?
For Instance you have 20 active threads. Thread_concurrency is set to 8
and 8+ threads are
At 19:53 +0100 10/14/03, Andrew Braithwaite wrote:
Thanks, that was extremely useful especially the date format detection.
However as it's usually quite scientific data, I need to detect FLOATs,
DOUBLEs and DECIMALs and the structure is not conducive to being integrated
into my current framework.
I
Dear all
When I use
Insert into table tabl1 (col1)
select ...
to insert about 2 mio. rows into tabl1 I get the error message 2013
connection lost.
When I just run the query, pipe the output into a text file, and use the
load data local infile into table tbl1, it works. How can I chang
I have written a .NET class library (fully scriptable via java script and
vbscript too) that serves up all of the meta data for MySql, Sql, Oracle,
Access, DB2 and a few others. Not just the normal meta data but all kinds
of custom meta data that's hard to get to. So, if you're running on a
M
Is anyone aware of an open source project that provides a graphical
representation of tables that can then generate a database schema in sql
statements. Something like Posiedon auto generating java beans.
Perhaps one should be started? ;-)
dan
Thanks, that was extremely useful especially the date format detection.
However as it's usually quite scientific data, I need to detect FLOATs,
DOUBLEs and DECIMALs and the structure is not conducive to being integrated
into my current framework.
Is it OK if I pilfer parts of the code and extend i
Hello,
I would like get the last 10 distinct (i'm not interested in all
columns) rows in a table which meet a condition. My first try was to
use the following query:
SELECT DISTINCT frobnitz.Field1, frobnitz.Field2, frobnitz.Field3,
frobnitz.Field4
FROM frobnitz, user WHERE user.username = 'foo'
At 19:05 +0100 10/14/03, Andrew Braithwaite wrote:
Hi,
Does anyone know of a perl module or other code that can look at a text file
(CSV, tab-delim etc..) of data and determine a MySQL table definition from
it?
The data may or may not have a set of column headers as the first line.
You can use the
Look at your wait_timeout and interactive_timeout settings. They may be
set to a low value. If your connection sleeps for > these 2 vars mysql
will disconnect you.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Orig
1) After I did the above is the server running or not? I believe I need to do a NET
START MySql
And if so, is there a way to make this a service that starts up when my box comes up?
You do need to do a NET START MYSQL, but since you are using NET commands mysql IS
installed as a service and sh
Dear All,
Hi!
Installed RH8 & included it mysql (RPM-version) with
it, looks like it didnt install in the /usr/local/
directory.
I'd love to uninstall it however, everything I do an
rpm -e mysql it gives this:
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed)
MyOD
Hi,
Does anyone know of a perl module or other code that can look at a text file
(CSV, tab-delim etc..) of data and determine a MySQL table definition from
it?
The data may or may not have a set of column headers as the first line.
I would appreciate it greatly if anyone could give me any pointe
Splain this to me: I use my laptop to connect to the test-bed MySQL
server residing on my desktop. Using this connection, I can do
anything: load 200K lines, do complex (for me) queries, whatever.
But,
open a MySQL console connection _on the desktop_ where the MySQL
server lives, I can't do a desc
I wrote a quick PERL script to give me the status of a table of a
particular database or queries in general on a db server.
71 | 2958 | System lock | e115 | messages |
REPLACE INTO antispam (code) values ('521.25624894_50628.1066152283')
For 71 seconds show full proces
I've just finished reading through most of the MySQL Enterprise
Solutions book by Alexander Pachev and I think you might want to take
a look at it. There is a section that deals with testing and MySQL
benchmarking tools.
These tools are available in the mysql/sql-bench (if your MySQL was
I have just installed MySql 4.0.15 from package [mysql-4.0.15-win.zip] onto my Win2000
box.
After doing the binary install, I got a 'cmd' prompt and followed the install
directions.
http://www.mysql.com/documentation/mysql/bychapter/index.html
I followed the 2.1.1.1 Installing the Binaries text
Never mind,
I used the show create table Mailbox results as my create table
supermailbox query and it worked.
Thanks
Jeff
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 14, 2003 11:59 AM
> To: Jeff McKeon; [EMAIL PROTECTED]
> Subject: RE
> % perror 143
> Error code 143: Unknown error: 143
> 143 = Conflicting table definitions in sub-tables of MERGE table
>
> Can you post the results for SHOW CREATE TABLE for the tables
> you're trying to merge?
MAILBOX
[snip]
| Mailbox |CREATE TABLE `Mailbox` (
`ID` int(11) NOT NULL auto_in
* Dusty Kleyboecker
> I have two tables, a PROJECTS table and a COMMENTS table linked by
> seq in a one to many relationship. In other words, there might be
> several comment rows for the same project, with different dates.
>
> PROJECTS
>
> seq name startdate enddate
>
> 1 p1 02032002
Hi -
You didn't mention which version of Sybase you are migrating from. I
just migrated our db from Sybase SQLAnywhere to MySQL v4.1 and there
were a couple things I found that didn't I had to change:
1) SQLAnywhere allows some words as column names that MySQL doesn't: I
had some a couple tables w
But MySQL even doesn't ask me for a password but returns immediately this
error.
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Stephan Wölfel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 10:14 PM
Subject: Re: Error 1045
> You are not en
> >2. Grants aren't working.
> >
> >Almost for each db we have the grant I did is something like :
> >
> >grant all on db.* to 'user'@'%.domain.com' identified by 'password';
> >
> >So, I end up with a user with no global privilege in the user table, and
a
> >entry in the db table with all privs.
>
At 11:50 -0400 10/14/03, Jeff McKeon wrote:
Ok, created the merge table, now I get this error when I log into the
mysql server
[snip]
Didn't find any fields in table 'SuperMailbox'
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3903 to server version: 3.23
I have two tables, a PROJECTS table and a COMMENTS table linked by
seq in a one to many relationship. In other words, there might be
several comment rows for the same project, with different dates.
PROJECTS
seq name startdate enddate
1 p1 02032002 12202003
2 p2 04012003 10
Ok, created the merge table, now I get this error when I log into the
mysql server
[snip]
Didn't find any fields in table 'SuperMailbox'
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3903 to server version: 3.23.56
Type 'help;' or '\h' for help. Type '\
At 11:30 -0400 10/14/03, Nicolas Ross wrote:
Hi !
Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just
crached, I had to recover on another hardware, a Mac OS X 10.2, wih
mysql-max 4.0.15.
The restore went well, but I have some problems :
1. All tables/database are now lower cas
"jon yeargers" <[EMAIL PROTECTED]> wrote:
>
> The /var/lib/mysql directory is collecting -bin.### files.
> What are these? Should I be saving them?
>
They are binary log files:
http://www.mysql.com/doc/en/Binary_log.html
If you don't need binary logging you can start mysqld without --lo
Are you running Replication?
- Original Message -
From: "jon yeargers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 10:12 AM
Subject: .bin.### files in /var/lib/mysql
The /var/lib/mysql directory is collecting -bin.### files.
What are these? Should I be sa
Hi !
Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just
crached, I had to recover on another hardware, a Mac OS X 10.2, wih
mysql-max 4.0.15.
The restore went well, but I have some problems :
1. All tables/database are now lower case.
This not a major issue, as the dbs are s
union isnt available with 3.23 either
Nitin
- Original Message -
From: "Rory McKinley" <[EMAIL PROTECTED]>
To: "Jeff McKeon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 8:01 PM
Subject: Re: Data from two tables in one query
> Hi Jeff
>
> Have you looked at
The /var/lib/mysql directory is collecting -bin.### files.
What are these? Should I be saving them?
At 11:14 -0400 10/14/03, Jeff McKeon wrote:
Paul,
- Original poster suggests that MERGE tables are not implemented until
4.0, but this is incorrect. MERGE tables are available as
of MySQL 3.23.25.
Very true, I must have misread. Now my question is, when I create a
merge table, do I have to
Paul,
> - Original poster suggests that MERGE tables are not implemented until
>4.0, but this is incorrect. MERGE tables are available as
> of MySQL 3.23.25.
Very true, I must have misread. Now my question is, when I create a
merge table, do I have to include every field from the two table
Manual for MyISAM table types says: 'Maximum number of keys/table is 32 as
default. This can be enlarged to 64 without having to recompile myisamchk.'
Is possible to enlarge this number for windows binary distribution? How?
It's not possible for any binary distribution, because changing the
limit r
Manual for MyISAM table types says: 'Maximum number of keys/table is 32 as
default. This can be enlarged to 64 without having to recompile myisamchk.'
Is possible to enlarge this number for windows binary distribution? How?
Thanks
Jaroslav
--
MySQL General Mailing List
For list archives: http://
Two points about the messages below:
- With respect to the suggestion to use UNION: Original poster is using
3.23, so UNION cannot be used (it's implemented in MySQL 4.0)
- Original poster suggests that MERGE tables are not implemented until
4.0, but this is incorrect. MERGE tables are availa
I am using 1 master (4.0.13 named PISSARRO ) and 3 slaves (4.0.15); of
course the my.ini are different in the master and slaves.
Today for an error (I thinked to be on my slave) I executed in sequence
these commands:
change master to
master_host='pissarro',master_user='root',master_password='',
Hi Jeff
Have you looked at UNIONS? An example would be something as follows:
SELECT field_1, field_2, field_3
FROM table 1
WHERE blah blah blah
UNION
SELECT field_1, field_2, field_3
FROM table 1_old
WHERE blah blah blah
ORDER BY field_1
This should do the trick...
Rory McKinley
Nebula Solution
Lee,
> I get the feeling there is a more efficient method using
> binary operations
> (only one field populated with zeros and ones) but I can't
> find anything to
> help in the manuals.
i think you should try to avoid such thing as much as you can.
Storing more than one piece of data in a colu
Lee.
Maybe others would disagree but they way I would handle this would be to
forget about storing the data in separate fields (or binary fields) and use
three tables.
Table1 - Facilities
A complete list of all criteria you want to record about the hotels
Table2 - Hotels
Table containing the hot
Hi!
On Sep 19, Michael Stassen wrote:
> This doesn't surprise me. I haven't looked at the code, but I'd bet
> that double-quoted, exact phrase matches are handled the usual way by
> mysql: First, do a regular fulltext search (using the index) to find
> rows with your search words, then check
Hellow,
I'm trying to do a replication using MASTER Linux
(mysql 4.1) and SLAVE Windows XP (mysql 4.1).
I attached the "show slave status", but i think that's
OK.
The problem is: when I run "load data from master"
returns:
"Error running query on master:
Access denied. You need the SUPE
We're currently running mysql ver 3.23 with plans to upgrade to 4.x soon
but we're not ready yet.
I have two tables that are identical, table1 and table1_old. Table1_old
contains all data writen to table1 prior to july of 2003.
I need to do a single query that pulls the same fields from both tab
Hellow,
I'm trying to do a replication using MASTER Linux (mysql 4.1) and SLAVE Windows XP
(mysql 4.1).
I attached the "show slave status", but i think that's OK.
The problem is: when I run "load data from master" returns:
"Error running query on master: Access denied. You need the SUPER privi
I'm not sure I'm posting this to the correct list. If I'm not, please
reply and let me know which list to post this to. Thanks.
We have a php-mysql web-based e-mail system that has a problem that has
happened twice in a 2 month period. This morning, somebody logged into
it and all of his mai
Hi people,
I have mysql 4.0.7-gamma/linuxthreads running under FreeBSD 4.6.2 (server
has 4G phisical memory), and occasionally mysql traps with the message:
InnoDB: Fatal error: cannot allocate 1064960 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 513951016 bytes.
I use both kinds of tables in my softawares, MyISAM and InnoDB, but since
I started trying using InnoDb, some problems with that kind of thable has
been occured.
Sometimes when I try to connect to an InnoDB, the server answers that the
table does not exist, but it's there, I can see it in my MyS
Hi,
I would create one field (char(200) or char(255)) for all criteria.
After that I will store:
in the first byte of that string Y if hotel has swimming pool, N - doesn't
have, Q - no idea
in the second byte of that string Y if hotel has TV, N - doesn't have, Q -
no idea
in the third byte of that
Hello,
I'm after some advice on database design:
I've got an object - for an example a hotel - and I want to keep information
about this hotel, criteria that it either has or hasn't (TV, swimming pool
etc).
I want to search on criteria and return the most appropriate match.
Bearing in mind I've
Hi,
If I understand you correctly the this query should help you:
select
date_format(date_add(DateTime, interval 7 hour), "%Y%m%d") as Date,
count(1)
from Table1
group by Date
order by Date
Best regards,
Mikhail.
- Original Message -
From: "Graeme B. Davis" <[EMAIL PROTECTED]>
To:
Does anyone know any way to be able to group by day/week/month for an
adjusted date (GMT -> EDT).
I store dates as GMT in the db, but sometimes I want to count the
number of rows per EDT day instead of GMT day. I can't figure out how
to do this.
Ideas?
Thanks,
Graeme
- Original Message -
create table as select
Enjoy
Nitin
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 2:49 PM
Subject: creating a new table from a SELECT
> how can i create a new table from a SELECT...WHERE... ?
>
> thanks
>
>
>
> --
> MySQ
Hello
I'm work in the Gdynia Maritime Academy, Poland. I use Mysql database
since 5 years. Now We are using Mysql database in the our education course
"Databases technology".
This course needed SQL subselect implementation.
We compiled and installed Mysql 4.1 alpha version with openssl support o
On Tue, 14 Oct 2003 11:55:18 +0200 (CEST)
<[EMAIL PROTECTED]> wrote:
> i have mysql version 3.22
perhaps you mean 3.23 ?
but no matter, it's time to upgrade definitely.
---
WBR,
Antony Dovgal aka tony2001
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Also check the [EMAIL PROTECTED] list.
It is very helpful
Thanks
Emery
- Original Message -
From: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
To: "scr informatiques" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 11:07
Subject: Re: connexion avec un pocket
In the docs, search for CREATE TABLE syntax.
There is something like
CREATE TABLE tbl_name SELECT some_fields FROM some_table WHERE
where_condition
I don't remember exactly but you should find useful information in the docs
of the MySQL website.
Thanks
Emery
- Original Message -
When restoring tables from a backup, get:
Op: repair // - this should always be "restore" according to manual
Msg_type: info
Msg_text: Delete link points outside datafile at 0
The datafiles seem to restore ok.
Have rtfm'd, googled and mysql forumed, but to no avail.
Is this something to worr
yes, sorry.
my intention is to delete repeated rows from TABLE1.
and since its a bit difficult with mysql the way that i take is create a
new table TABLE2 with the repeated rows (but not repeated in TABLE2), and
then i want to delete from TABLE1 all the rows which also are in TABLE2.
later on, i I
Hi,
Sql Porter Might Be Of Some Help, But Alas Its Not Free...
P
Prasad Budim Ram wrote:
> Hi,
>
> Are there any tools to migrate db schema as well as data from sybase
> to mysql?
>
> Thanks,
> Prasad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
I think the question is not very clear.
Do you want to delete from all the tables or you just want to delete from
one of the tables?
Does your MySQL version support sub-queries? (Is it Ver 4.1.x ?)
I saw some replies to your question, did they solve your problem?
I am asking this because a DELETE
if you can export the same from sybase, then undoubtedly you can import
those iinto mysql
Nitin
- Original Message -
From: "Prasad Budim Ram" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 1:57 PM
Subject: Migration tools for sybase to MySQL
> Hi,
>
> Are the
how can i create a new table from a SELECT...WHERE... ?
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Des articles de Mike Hillyer peuvent t'aider.
Son site est http://www.vbmysql.com
Vous aurez besoin d'un Connecteur ODBC pour utiliser Visual Basic. MyODBC est tres
simple a utiliser. Il peut se telecharger depuis le site de MySQL
(http://www.mysql.com)
Mais le site est en Anglais.
I can ask and
Hi Kabbouri
Please see below, an excerpt from the MySQL manual, that answers your
question.
If the FIELDS TERMINATED BY and FIELDS ENCLOSED BY values are both empty
(''), a
fixed-row (non-delimited) format is used. With fixed-row format, no
delimiters are used
between fields (but you can still
Hi,
Are there any tools to migrate db schema as well as data from sybase
to mysql?
Thanks,
Prasad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Will it be possible in mysql-5.0 to create packages and global session variables?
or will this be possible in the near future?
I can't find any documentation on this subject, does someone have some documentation
on MySQL 5.0 or knows where to find more?
greetings, Bob
http
How can I find the way to import a text file with fixed width fields:
for example:
Import file content:
375120031010143902KABBOURIMOHAMMED
Imported in:
Field 1: 3 char : "375"
Field 2: 5 char : "1"
Field 3: 8 char : "20031010"
Field 4: 6 char : "143902"
Fiel
77 matches
Mail list logo
