From: [EMAIL PROTECTED]
Subject: Re: more queries vs a bigger one
Hello,
approx. how long does it take your big query to run as it is now? Are
these queries appending a table? or are they buiding a result (from a
chain of queries)? Have you tried separating them out? Any difference?
-sam
Illegal mix of collations (latin1_bin,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='' on query. Default
What default charset do your slave's tables have? The coercibility
value of system constants has changed in 4.1.11. Though it seems not
related to your problem I recommend
Thanks for the detailed information, this is much clearer. I look
forward to 5.0.x becoming release.
Kind regards,
Ben Clewett.
Joerg Bruehe wrote:
Hi Ben, all!
Ben Clewett wrote ((re-ordered into posting sequence)):
Joerg Bruehe wrote:
Hi Ben!
Ben Clewett wrote:
[[...]]
Privet!
What is faster: UNION or temporary table or something else ?
Sometimes MERGE tables could be used, but the speed difference between
UNION solution and MERGE is rather low. The temporary table for sorting
(ORDER clause causes this) should be created in all cases. So, if you
have
Hello.
According to the output of mysqld --help --verbose these variables
(date_format and datetime_format) don't work yet, they're exists
for future purposes.
[EMAIL PROTECTED] wrote:
Mike,
Have you tried creating a new table with a field for some sort of date?
Try adding some
Hi,
I have installed linux 9 with mysql-standard-4.0.15-pc-linux-i686..
mysql responding very slow when i request to find out any database its took
long time
to respons...
plz help me
Manish Popli
-
Fiorano
hi,
i've got some questions:
what happens when we deallocate a prepare statement?
can we use same name for 2 prepared statements in a SP by deallocating first
one before defining second one?
can we use a prepare statement in a loop?
can we use more than 1 prepared statement in a single SP?
Hi,
Though MySQl initially provided support for Prepared statements in MySQL
5.0, they have removed that support in the later beta versions of MySQL 5.0.
Right now MySQL does not recommend using prepared statements inside SP.
So it would be better if you go for some work around's like using 'if
hello
i am taking backup in *.sql format automatically how can i restore the same
in the server automatically from visual basic
regards
p rao
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello
I recommend you install mysql on your _home_ computer. After install
last version MySQL-Front (www.mysql-front.com) and trying to connect
from it.
TH I have finally gotten my MySQL server up and running. However, I am
TH having a bit of difficulty getting connected.
TH I am using
Hello
BM Are you looking to compare a few last records in each table or ??
BM Can I get a little bit more details?
I have 10 similar tables. 3 years ago it was one big table. Now I
split it to 10 tables.
3 years ago I could write:
SELECT * from BigTable WHERE date_col$some_date ORDER BY
I had a similar setup, involving log parsing. It was impractical to put all
of the data in one table and expect to get timely results. In order to do
it, I scripted the generation of the temp table (think I used a merge,
since it is not actually moving data and is fast). So... I scripted the
date
Hi!
Peregrine wrote:
On Monday 18 July 2005 03:06am, Joerg Bruehe wrote:
[[...]]
You are correct. The compile was successfully completed, as in there were no
compile errors. However, I am building RPMs; that was the build process
that I was referring to. Sorry to have been confusing.
Hello
Now I use temporary table, but I can`t use SQL_CACHE in queries, which
contain temporary table :-( In theory 90% queries can be cached.
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
http://gyxe.com/ http://gyxu.com/
http://xywe.com/
Hello
GP If you have faster solution (in several times) please introduce it. I've
GP seen similar issues at archives at:
GP http://lists.mysql.com/mysql
I find it in docs :-) :
(SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY a LIMIT 10)
UNION
(SELECT a FROM table_name WHERE a=11 AND B=2
You have not tried merge?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 19, 2005 5:46 AM
To: Peter J Milanese; mysql@lists.mysql.com
Subject: Re: Multitable selection
Hello
Now I use temporary table, but I can`t use SQL_CACHE in queries, which
I do hope that you understand that this is not a productive post
(question?)
Very slow is a bit vague. What is it that you are trying to do?
-Original Message-
From: Manish [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 19, 2005 3:20 AM
To: mysql@lists.mysql.com
Subject: error in mysql
Dirk,
Some suggestions.
1. can you still dump the table using mysqldump? Then you can import it
again (with the mysql commandline client), creating a 'fresh' table.
2. make a backup of the index file (.MYI), then throw it away. MySQL
will create a new index for you.
HTH,
Martijn
Octavian Rasnita [EMAIL PROTECTED] wrote on 07/19/2005 02:45:58 AM:
From: [EMAIL PROTECTED]
Subject: Re: more queries vs a bigger one
Hello,
approx. how long does it take your big query to run as it is now?
Are
these queries appending a table? or are they buiding a result (from a
Hello.
You've provided not enough information to give you a good suggestion.
Are you connecting through UNIX socket or TCP? Similar behavior is often
caused by DNS problems. 4.0.15 is a very old MySQL. Use 4.1.12 (or
4.0.25). What does it mean 'find out any database'? Did you mean that
Hello.
In what way do you create your backups? Why do you want to use visual
basic instead of mysql command line client for example?
prathima rao [EMAIL PROTECTED] wrote:
hello
i am taking backup in *.sql format automatically how can i restore the same
in the server
Hello.
Searching through the code shown me that all stuff is located in
sql/hostname.cc file. MySQL depends on gethostbyaddr_r and uses
the official name of the host which it returns. According to
rfc897:
Hosts have an official (or primary) name and possibly several
nicknames. When
Hello.
`key` varchar(255) character set utf8 collate utf8_bin NOT NULL
^^^
Field's character set should be latin1 as well. Change it.
Features and fixes: http://www.upscene.com/news/20050719.htm
Database Workbench supports:
- Borland InterBase ( v4.x - v7.x )
- Firebird ( v1.x )
- MS SQL Server/MSDE ( v6.5, 7, 2000, MSDE 1 2 )
- MySQL 4, 4.1
- Oracle Database ( 8i, 9i, 10g )
If you experience any problems with this new version
王 旭 [EMAIL PROTECTED] wrote on 07/18/2005 03:17:51 AM:
Follow is the sql statement:
explain SELECT ol_i_id
FROM orders, order_line
WHERE orders.o_id = order_line.ol_o_id and o_id0
ORDER BY SUM(ol_qty)DESC
王 旭 [EMAIL PROTECTED] wrote on 07/18/2005 03:12:28 AM:
NO effect :-(
From: pow [EMAIL PROTECTED]
To: 王 旭 [EMAIL PROTECTED]
Subject: Re: optimize a sql statement
Date: Mon, 18 Jul 2005 11:51:23 +0800
Do u have composite index on order_line.ol_o_id AND order_line.ol_i_id?
You could try
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, July 19, 2005 10:08 PM
Subject: table export problem
Hi all,
I am trying to create a table on the remote server from a table I created on my
local sever but it never seems to
work
CREATE TABLE
Hi all,
I am trying to create a table on the remote server from a table I created on my
local sever but it never seems to
work
CREATE TABLE `sheet1` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`fname` varchar(255) NOT NULL default '',
`sname`
I have been able to create your table in my mysql 4.1.12
I think your remote server is in mysql 4.0 series
[EMAIL PROTECTED] wrote:
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, July 19, 2005 10:08 PM
Subject: table export problem
Hi all,
Hi,
I have setup cronjobs to take daily backups of my db using mysqldump.
But the problem is, mysqldump requires the password to be passed via
command line, which means anyone on the same machine can take a peek
at my password using top, ps -ef, etc.
Is there a way of avoiding this, i.e. making
have you looked at using a my.cnf file?
eMac:~ hcir$ mysqldump test /temp/test.sql
eMac:~ hcir$ ls -l /temp/test.sql
-rw-r--r-- 1 hcir staff 78893008 Jul 19 16:47 /temp/test.sql
contents of ~/.my.cnf
[client]
user= username
password= password
# actual username and
Hi all,
After deleting and reinstalling mysql on my Powebook G4 12, it
starts and then quits immediate. I had
to reinstall because my users seemed to not be working on.
These are the steps I am taking after reinstalling and the errors I get:
cd /usr/local/mysql
sudo echo
sudo
[EMAIL PROTECTED] wrote:
Hi all,
After deleting and reinstalling mysql on my Powebook G4 12, it starts
and then quits immediate. I had
to reinstall because my users seemed to not be working on.
These are the steps I am taking after reinstalling and the errors I get:
cd /usr/local/mysql
Michael, here are some snippets from the error log that look
relevant, from three times I tried to start:
050719 20:29:41 mysqld started
050719 20:29:46 [Warning] Setting lower_case_table_names=2 because
file system for /usr/local/mysql/data/ is case insensitive
050719 20:29:58 InnoDB:
Chris Fonnesbeck wrote:
On 7/18/05, Michael Stassen [EMAIL PROTECTED] wrote:
Hmmm... In that case, I have more questions. Log in as root and run
SHOW VARIABLES LIKE '%pass%';
DESC user password;
and post the results.
Also, was this a brand new installation, or an upgrade? If an
35 matches
Mail list logo