Hello dear all-mighty list :)
I do run mysql in 4.0.24 and have the following very slow query.
select tbl3.colname from tbl
.. (some left joins)
where
left(colname,1)={letter}
the tbl.col has no index nore will it ever get one because auf
the tbl structre. (this would make no sense becaus only
Hi,
you should have posted 2 threads ;)
the other thing is that I would like to update to 4.1.x on
my debian sarge. Has anybody done this yet?
do I have to just: apg-get remove mysql ?
and apg-get install mysql-4.1
just apt-get install mysql-4.1 to get things runs smoothly
(which would
Hello.
Please, check if the problem exists on the latest release (4.1.13 now).
It might be a bug like:
http://bugs.mysql.com/bug.php?id=9703
Octavian Rasnita [EMAIL PROTECTED] wrote:
Hi,
I have tried the following query and it works fine. It takes 11 seconds and
this is a little
Hello.
This is a line from one of your files which were attached in archive:
[EMAIL PROTECTED] Test_pgms]# gcc -c -I/usr/lib/bcc/include
^^
-I/usr/include/mysql createdb.c
Are you using Borland C++ includes with gcc?!
Hello.
When I strace the mysqld process it doesn't do anything, it's waiting
Do you use the official binaries? There're additional InnoDB monitors
mentioned at:
http://dev.mysql.com/doc/mysql/en/innodb-monitor.html
which could provide more information.
When I strace the
Hello.
You said that you had created a view, but you continued using Tab_A
instead of Tab_A_View in your next queries. Did you want to use view
Tab_A_View? On my MySQL 5.0.9 all queries works both with view and
original table. See:
mysql desc Tab_A;
Hello.
May be I'm wrong, but most of the time, your query is spending in
sorting results (you can check it with SHOW PROCESSLIST). If you can't
change it, you could increase the value of tmp_table_size to use
in-memory tables, if you have enough RAM.
$ $ [EMAIL PROTECTED] wrote:
Does anyone know a free tool to convert MySQL to MSSQL
Thank you
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Am Thursday 28 July 2005 11:19 schrieb [EMAIL PROTECTED]:
Does anyone know a free tool to convert MySQL to MSSQL
mysqldump?
Seriously, what do you expect? A tool which transforms mysql files on disk to
mssql files? I don't think this exists and would probably be hardly possible.
Perhaps there
So all I can do is copy tables as they already exist? I obviously need
to keep the structure in place
Andrew
Am Thursday 28 July 2005 11:19 schrieb [EMAIL PROTECTED]:
Does anyone know a free tool to convert MySQL to MSSQL
mysqldump?
Seriously, what do you expect? A tool which
Hi all
I installed mysql client on a windows box and created a my.conf file with the
following:
[client]
server=servername
user=username
When I type the full path of the executable, it reads the conf file, and takes
appropriate action.
However, when I use the shortcut that is created by the
[EMAIL PROTECTED] wrote:
Does anyone know a free tool to convert MySQL to MSSQL
Thank you
Andrew
phpMyAdmin (http://www.phpmyadmin.net/) version 2.6.3-pl1 has the option
to export the data in mssql format (and much others).
You need a php enabled web server able to connect to your mysql
Hello All!
I have a question. I'm using the mysql 4.0 but I want change 5.0 because I
would like to use some features. (Subselect etc)
Was 5.0 ever used in bigger system? Is 5.0 more realible than 4.0?
Where can I find information about critical bugs and errors of 5.0?
Thanx!
Zoli
--
Gyurasits Zoltán wrote:
Hello All!
I have a question. I'm using the mysql 4.0 but I want change 5.0 because
I would like to use some features. (Subselect etc)
Maybe some of features you want are already included in 4.1 series, try
a search before switch to 5.0 for a production system.
Hi,
MySQL 5.0.10-beta, a new version of the popular Open Source Database
Management System, has been released. It includes support for Stored
Procedures, Triggers, Views and many other new enhancements.
The Community Edition is now available in source and binary form for a
number of platforms
Although finding a tool that will automatically transfer files from MySQL to
MS SQL format will be hard to do, both will accept txt files that have the
CREATE statements and data in SQL.
mysqldump will do this for you.
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Just export the files to an
The original message was received at Mon, 25 Jul 2005 09:55:55 +0900
from knoware.nl [57.7.174.117]
- The following addresses had permanent fatal errors -
mysql@lists.mysql.com
- Transcript of session follows -
... while talking to host 11.171.104.62:
554 mysql@lists.mysql.com...
Eric,
Can you send us the actual show indexes from table and explain output that
isn't shortend?
Thank you for answer my question.
Actually, the real query and tables are much more complex than
the data in the previous message.
A just tryed to optimize the information for you better
Hi, there,
I am have a hard time figuring out why a simple query is extremely
slow. I would greatly appreciate if you can shed some light!
The table is in InnoDB:
CREATE TABLE `rps_hits` (
`gi` int(10) unsigned NOT NULL default '0',
`cddid` int(10) unsigned NOT NULL default '0',
MySQL 4.0.16
I am having this annoying persistent corruption issue, and am
wondering if anyone has any suggestions. I have two tables that
refuse to stay clean. After a myisamchk (below) they show corruption.
I run a myisamchk -r, they get fixed, and the next day, they are once
again corrupt.
Am I reading the documentation correctly. I cannot us a trigger to insert a
record into an other table??? I use triggers on other dbms to create an
acivity histoy table.
Fredrick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
Isn't there some information in the MySQL error log about what might have
caused the corruption. Normally this would happen when disk or memory problem
occurs.
On Thursday 28 July 2005 17:45, Chris McKeever wrote:
MySQL 4.0.16
I am having this annoying persistent corruption issue, and
On 7/28/05, Dobromir Velev [EMAIL PROTECTED] wrote:
Hi,
Isn't there some information in the MySQL error log about what might have
caused the corruption. Normally this would happen when disk or memory problem
occurs.
thanks for the reply -
from the .err file:
050722 5:20:24 read_next:
Hello,
Today, I started experiencing some issues on our website with max
connections exceeded errors. In looking into this, I found that we had too
many sleeping processes. I was not even able to login to the mysql server
from a command line. Is there a way to set a timeout for sleeping
Jason Williard wrote:
Hello,
Today, I started experiencing some issues on our website with max
connections exceeded errors. In looking into this, I found that we had too
many sleeping processes. I was not even able to login to the mysql server
from a command line. Is there a way to set a
Andy Pieters [EMAIL PROTECTED] wrote on 07/28/2005 05:06:46 AM:
Hi all
I installed mysql client on a windows box and created a my.conf filewith
the
following:
[client]
server=servername
user=username
When I type the full path of the executable, it reads the conf file,and
takes
I had a similar problem while connecting to mysql 4.0.21 throuhg MyODBC
3.51.11.
If so you must upgrade mysql to 4.1 or downgrade MyOdbc to 3.51.06
Jason Williard wrote:
Hello,
Today, I started experiencing some issues on our website with max
connections exceeded errors. In looking into
Eric Bergen wrote:
This does make his code fall under the limitations of unix timestamps.
In 30 years or so when we are all retired millionaires ;) some poor
intern is going to have to figure out why the hour diff calculation is
failing.
Long before then we will all be using 64 bit
Hello,
I've been looking around for a while. Seems there are many options and
tools that can help do it. Guidance and directions are highly welcome.
We need to move the contents of a bunch of tables from Access to the
existing tables on MySQL. The target tables in MySQL already have some
I will be migrating Oracle database 9i to Mysql. Do anyone have any
experience in doing this?. Please share with us!
Thank you very much,
V/R,
Nguyen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Zhe Wang [EMAIL PROTECTED] wrote on 07/28/2005 10:40:08 AM:
Hi, there,
I am have a hard time figuring out why a simple query is extremely
slow. I would greatly appreciate if you can shed some light!
The table is in InnoDB:
CREATE TABLE `rps_hits` (
`gi` int(10)
I am learning MySQL from an older book, and some of the examples it give do
not work in MySQL, so I am going to ask for help on those.
select cust_contact from Customers where cust_contact like '[JM]%';
returns Empty set (0.00 sec)
What is the right way to do this?
Likewise:
mysql select
Bob Rea [EMAIL PROTECTED] wrote on 28/07/2005 18:19:34:
I am learning MySQL from an older book, and some of the examples it give
do
not work in MySQL, so I am going to ask for help on those.
select cust_contact from Customers where cust_contact like '[JM]%';
returns Empty set (0.00 sec)
Make a select query in Access whose result mimics the table layout of
the target table in MySQL. Then export the query as tab-delimited text
and import into the MySQL table using LOAD DATA INFILE.
On Jul 28, 2005, at 12:32 PM, Bing Du wrote:
Hello,
I've been looking around for a while.
I've used the exportSQL script
(http://www.rot13.org/~dpavlin/projects/sql/exportSQL3.txt) to dump tables
out of Access into a file that can be imported by mySQL. Since a lot of my
work is porting Access apps to web apps, it comes in very handy.
I've also written a really simple VB script that
Why are you going backwards MySql is an 8th grade toy.
-Original Message-
From: Nguyen, Phong [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 9:42 AM
To: mysql@lists.mysql.com
Subject: Migration from ORACLE 9i to MySQL
I will be migrating Oracle database 9i to Mysql. Do
Hi,
I am using a MySQL database on a web site, and I would like to know what
happends if someone searches in the database using a form, but after a few
seconds MySQL starts the query, that user hit the Stop button of the
browser.
Will MySQL continue its searching and also create the cache, or it
Hello,
I've been looking around for a while. Seems there are many options and
tools that can help do it. Guidance and directions are highly welcome.
We need to move the contents of a bunch of tables from Access to the
existing tables on MySQL. The target tables in MySQL already have some
I was running into this all the time.
I actually had myisamchk running on a regular basis (live) via cron
which I think was actually causing the corruption.
By chance are you running myisamchk on the live tables?? I ran the
REPAIR TABLE... on each table, shut down mysql THEN ran myisamchk
Johnson, Michael [EMAIL PROTECTED] wrote on 07/28/2005
01:56:33 PM:
Why are you going backwards MySql is an 8th grade toy.
-Original Message-
From: Nguyen, Phong [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 28, 2005 9:42 AM
To: mysql@lists.mysql.com
Subject: Migration
I got no experience in migrating Oracle to Mysql, but here might be what you
were looking for:
http://dev.mysql.com/downloads/migration-toolkit/1.0.html
Scott
On 7/28/05, Nguyen, Phong [EMAIL PROTECTED] wrote:
I will be migrating Oracle database 9i to Mysql. Do anyone have any
Johnson, Michael wrote:
MySql is an 8th grade toy.
So why are you here? Go haunt an Oracle mailing list.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Octavian Rasnita [EMAIL PROTECTED] wrote on 07/28/2005 02:18:05 PM:
Hi,
I am using a MySQL database on a web site, and I would like to know what
happends if someone searches in the database using a form, but after a
few
seconds MySQL starts the query, that user hit the Stop button of the
Octavian,
I am using a MySQL database on a web site, and I would like to know what
happends if someone searches in the database using a form, but after a few
seconds MySQL starts the query, that user hit the Stop button of the
browser.
Will MySQL continue its searching and also create the
Hi, Shawn,
Thanks a lot for your reply.
Running analyze table didn't help much since this table has not
been updated after being built.
The table has 3 single indexes. What puzzled me was that the queries
against the first index were fast, only slow if against the second or
third
On 7/28/05, Dan Tappin [EMAIL PROTECTED] wrote:
I was running into this all the time.
I actually had myisamchk running on a regular basis (live) via cron
which I think was actually causing the corruption.
By chance are you running myisamchk on the live tables??
I was - but not after all
Hello.
It is possible to obtain your results without temporary tables, but
with user variables. For a pity you should execute three queries.
With first query you're getting the Sum:
select @all_sum:= count( employee_id) from table_employee
where employee_hire_date between
Hello.
MySQL 4.0.16
You run an old MySQL. Upgrade to the latest release sometimes solves
such issues. Check if the problem remains with MySQL 4.1.13 (or 4.0.25).
Chris McKeever [EMAIL PROTECTED] wrote:
MySQL 4.0.16
I am having this annoying persistent corruption issue, and
Hello.
I'm unable to comment your decision about making a separate table
and how your data will be normalized after it. But, in my opinion,
if you're going to use only one letter for WHERE condition your index
will have a low cardinality (number of unique values) and optimizer
might
Hello.
I'm able to insert a record with a trigger to another table at least
at 5.0.10. May be these lines from ChangeLog shows new behavior:
It is no longer necessary to issue an explicit LOCK TABLES for any
tables accessed by a trigger prior to executing any statements that
might
I have a table 'companies' and a table 'feedback'. Feedback has rows
with a id_company key that matched the companies.id. Think of it as
the ebay rating system.
I have a simple query that works fine:
SELECT companies.id, MIN(feedback.rating), MAX(feedback.rating),
I cd /usr/local/mysql/sql-bench and perl run_all_tests, just to get the
following error:
-
Got error: 'Access denied for user 'root'@'localhost' (using password: NO)'
when connecting to DBI:mysql:database=test;host=localhost with user:
Hi,
Is there a secure way of running mysql commands against the db from the
command line, or in some kind of secure batch mode, without making the
password totally visible? We need to procedurize things like flush
tables with read lock, unlock tables etc. Is making the password
visible on the
You *COULD* include the information in the my.cnf file under the
[client] area, something like this:
[client]
user=bruce
password=brucesPassword
That would tell the client to use that unless something else is
disabled.
Of course that needs to be saved in plain text in a plain text file
Xu Qiang wrote:
I cd /usr/local/mysql/sql-bench and perl run_all_tests, just to
get the following error:
-
Got error: 'Access denied for user 'root'@'localhost' (using
password: NO)' when connecting to
Jeff Richards wrote:
Hi,
Is there a secure way of running mysql commands against the db from the
command line, or in some kind of secure batch mode, without making the
password totally visible? We need to procedurize things like flush
tables with read lock, unlock tables etc. Is making the
Without knowing more of your requirements, I find seeing the grand total and
overall average repeated in every row strange from a usability perspective.
Do you really need that, or were you just hoping to get that information out
of your query?
I'd suggest something like:
SET @sum=0, @m=0;
57 matches
Mail list logo
