Follow is the result.
+--+-+
| Variable_name| Value |
+--+-+
| character_set_client | utf8
Are you mean this problom only disposed in compile ?
- Original Message -
From: "Andreas Steichardt" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, December 20, 2005 4:34 PM
Subject: (瑞星提示-此邮件可能是垃圾邮件)Re: (鐟炴槦鎻愮ず-姝ら偖浠跺彲鑳芥槸鍨冨溇閭欢)Re: insert utf8 character
in Linux commind-line tool
On Tuesday 20
No effect.
I use chinese in konsole no problem but in mysql commind-line.So in my word,
this problom maybe happen in mysql commind-line setup.
- Original Message -
From: "古雷" <[EMAIL PROTECTED]>
To: "wangxu" <[EMAIL PROTECTED]>; "Andreas Streichardt" <[EMAIL PROTECTED]>;
Sent: Tuesday
Hi,
For the first time, I'm working with a really large database. I have 1
SQL statement that brings my server to it's knees. This setup is currently on
my home development PC, and not in production. The server is running apache,
samba, and mysql under gentoo linux. I'm the only
Nathan Gross <[EMAIL PROTECTED]> wrote on 12/20/2005 05:34:58 PM:
> Hi;
> [Mysql 4x] In a table where I get data from another program, I have
> many records (about 1000) that have illegal chars in a [unique]
> indexed varchar field. I would like to clean the illegal characters
> out and leave the
Hi all.
I'm working on splitting a 5G myisam fact table into separate parts,
and putting a merge table on top.
his will definitely help with table management, but I am hoping that a
merge table might help me with query speed:
(a) The docs say that spreading the underlying tables across different
Confused about how ALTER TABLE foo ADD col2... operates.
On an otherwise idle server, iostat 1 shows the disk being written to at a
rate of 15MB/sec (its capacity is about 50MB/sec), but the ibdata-autoextend
file only grows at a rate of 500kb/sec.
12GB table (w/ 1.5GB index) took 6 h
Hi;
[Mysql 4x] In a table where I get data from another program, I have
many records (about 1000) that have illegal chars in a [unique]
indexed varchar field. I would like to clean the illegal characters
out and leave the rest of the data intact.
1. Is there a utility to do this?
1b) Or an UPDATE c
The following takes a little effort, but it should get you close to dump
file size.
On 5.0.x you can use Information_schema.columns to get average row
length for MyISAM tables. Take that plus the punctutation {~35 + 3* #
cols for insert per row if you enclose your columns in "'s} in the
insert sta
On 20/12/2005, Marcus Bointon wrote:
> I have a table that contains around 400,000 simple names. It's
> displaying a subset of them (perhaps 5,000) them a page at a time in
> a web interface, sorted by name, so I have a query like this:
>
> SELECT * FROM names WHERE account=123 ORDER BY lastname,
Hello.
> symbolic links! Thats a neat solution. Question: when you say
> "symbolic links for databases" do you mean links to ibd files, ibdata1
> file, either, or something else?
I've meant symbolic links for databases. See:
http://dev.mysql.com/doc/refman/5.0/en/symbolic-links.html
>
On 12/20/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
>
>
> Please, next time answer to the list as well.
Sorry. I didn't realize Gmail's 'reply' didn't go to the list. First
time I noticed the 'reply to all' option in Gmail. Thanks.
> As far as I know, you can't specify the location
Hi Mark -
Regarding:
>Depends on the connection pool and how it's configured. Generally the
>logical session is terminated by the container, eventually the
connection >pool will terminate the physical session if some idle
timeout value is >reached, or if the physical session has been
determined to
Bruce Carey wrote:
> - my problem is that when a text field, with html in it, it makes it
> into several hundred recs
Well, that's strange -- I use mysqldump to dump/xfer/load records
with fields containing HTML regularly, using the mysqldump defaults,
and have no problems.
Have you tried the de
That was the problem.
Thanks a lot Heikki.
I guess my next move would be to persuade upgrading to MySQL 5.
Dilipan
Heikki Tuuri wrote:
Dilipan,
indeed, there was a race in the printing of thd->query in 4.0.18. But
the problem was probably fixed in May 2004.
Best regards,
Heikki
Oracle C
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Noga Woronoff wrote:
> Hi Mark -
>
> 1. Can you deploy the MysqlConnectionPoolDataSource with JBoss 3.2.5
> using J/Connector 3.0.15 (using MySQL 4.0.21)?
Noga,
Sure, but it's not required, and generally the JBoss folks seem to
prefer using driver-
Hi Mark -
1. Can you deploy the MysqlConnectionPoolDataSource with JBoss 3.2.5
using J/Connector 3.0.15 (using MySQL 4.0.21)?
2. If so - is the documentation "1.4.3. Using Connector/J with JBoss"
for the mysql-ds.xml enough using the tag or do you have
to add a tag that provides an explicit r
Gleb Paharenko wrote:
Hello.
Are you able to start mysqld without using /etc/init.d/mysql, manually
invoking mysqld_safe or mysqld? From my experience, SELinux can cause
different problems, check if you have it enabled. Follow general
recommendations from:
http://dev.mysql.com/doc/refman/5.0/e
Hello.
The recommended way to install MySQL on FreeBSD is to use ports collection.
> my_print_defaults: not found
Are you using binary distribution? Put the path to directory which
contains my_print_defaults to you $PATH variable, and check if the
problem still exists.
Êàëàí÷èí À. w
Hello.
That seems like a bug for me. Please, check if the problem
still exists if you're using 4.1.16 master and slave.
Martijn van den Burg wrote:
> Dear list,
>
> Replication (between two 4.1.10 servers, Solaris) fails on the following
> query with a 1064 error (parse error), but th
Hello.
Please, next time answer to the list as well. As far as I know, you
can't specify the location of ibd files, they're stored in the database
directory, however, you can use symbolic links for databases to have
them in another place.
>all databases? So the question is if I can locate
Hello.
Are you able to start mysqld without using /etc/init.d/mysql, manually
invoking mysqld_safe or mysqld? From my experience, SELinux can cause
different problems, check if you have it enabled. Follow general
recommendations from:
http://dev.mysql.com/doc/refman/5.0/en/starting-server.
Hello.
Please, provide the output of this statement:
show variables like '%char%';
> I import utf8 character in terminal commind-line is well.So in my
>word,there aren't error in my terminal settings.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Hello People,
I have some indexing problem on using the fieldtype 'date' as
restriction in a query.
I use MySQL Server version: 4.0.20
The table I have consists of roughly over 200.000 rows about 37 fields and
it looks sort of like this:
mysql> desc the_table;
++--
On 12/17/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> Hello.
>
>
>
> > and slave. Error on master: 'Incorrect key file for table '%-.64s
>
>
>
> Really, the name of the table is strange enough. Is it possible that
>
> you have non-latin symbols in table name, which are displayed
>
> incorrectly
Hi,
Disregard my previous post.
It seems the developer is doing stuff that creates duplicate key errors,
which seem to propagate to the slave, in stead of being ignored.
--
Martijn
> -Original Message-
> From: Martijn van den Burg [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 20 decemb
> -Original Message-
> From: "Marcus Bointon" <[EMAIL PROTECTED]>
[SNIPPED]
> That takes 11 seconds to run. Without the order by it takes 0.13 sec.
> I have simple indexes on both first name and last name (they are
> sometimes searched separately). It strikes me that this is really
>
Hi Marcus,
Do you have the output of the EXPLAIN? I've found the number of rows
processed to be very instructional. If you could get this number down,
it may be well worth putting an index on the account column and
re-running the EXPLAIN to see how many rows are being processed.
I recently put an
I have a table that contains around 400,000 simple names. It's
displaying a subset of them (perhaps 5,000) them a page at a time in
a web interface, sorted by name, so I have a query like this:
SELECT * FROM names WHERE account=123 ORDER BY lastname, firstname
LIMIT 0,30
That takes 11 sec
Hi,
I've a freshly installed linux Box (Fedora Core 4) and I'm trying to install a
little mysql server.
I've download the following linux RPM and installed the via rpm -Uvh:
MySQL-client-5.0.17-0.glibc23.i386.rpm
MySQL-server-5.0.17-0.glibc23.i386.rpm
If i launch the server via the following
Dear list,
Replication (between two 4.1.10 servers, Solaris) fails on the following
query with a 1064 error (parse error), but there are no reserved words
in it, and when I run the query from the command line on the master no
errors occur and the table is created.
(binlog)
/*!40019 SET @@session
Good Day !
When installing mysql 5.0.16 on FreeBSD 5.3, after unpacking of the archive and
attempt to execute скрипт:
scripts/mysql_install_db
the system gives the mistake:
my_print_defaults: not found
Could not find help 'fill_help_tables.sql' in ./support-files or inside ..
--
in
Hi everybody!
Martijn Tonies wrote:
I execute follow procedure:
---
create procedure test_transation_rollback()
begin
start transaction;
create table t_34d (c1 int,c2 char(30));
rollback;
end
--
On Tuesday 20 December 2005 03:10, wangxu wrote:
> Are there two option?
> How to use them?
These are just two options which you will have to use when ./configure'ing the
source distribution
if you are using a binary distribution of mysql try downloading the source
distribution...
then rea
Jim Winstead wrote:
This is addressed in the FAQ for the mailing lists.
http://lists.mysql.com/faq.php#replyto
Jim Winstead
MySQL Inc.
Times and technology change. Take a look at the changes to MySQL server
and the internet in general since 2000.
That's all I'm going to say as there a
35 matches
Mail list logo
