Re: "segment fault" when using mysql++

e reply only on the list, not to me directly. wangxu wrote: below is my code;these code works very fine until, the length of the field "content" exceeds 30, How certain are you about this threshold? It seems a very odd number for a computer to care about. If you'd said 6

"segment fault" when using mysql++

below is my code;these code works very fine until, the length of the field "content" exceeds 30, then "segment fault" happened. how can I avoid this? mysqlpp::Query query = conn.query(); query << "select content from pages where id="

alter engine

Now i want to change myisam table to innodb table using "alter table ... engine innodb". But the process is too slow! Need i increase key_buffer_size? Need i increase innodb_buffer_pool size?

Re: when rebuilding keys?

- Original Message - From: "Martijn Tonies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, April 12, 2007 3:17 PM Subject: Re: when rebuilding keys? > > >> yes. > >> >> before load data. >> > >> > You want to rebuild the indices after loading data, >

Re: Can I create a index on a column of Type datetime?

No,I am just asking for a solution to speed up my queries. Martijn Tonies wrote: > >> I will very often do query like this: >> >> select * from mytable where create_date >='...' and create_date <='' >> >> can I create a index on the column create_date? >> > > Have you tried it? > > >

Re: Can I create a index on a column of Type datetime?

field unless it's the last field in the index. > > - Original Message - From: "wangxu" <[EMAIL PROTECTED]> > To: > Sent: Wednesday, April 11, 2007 8:08 PM > Subject: Can I create a index on a column of Type datetime? > > >> I will very oft

Re: when rebuilding keys?

yes. - Original Message - From: "Martijn Tonies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; Sent: Thursday, April 12, 2007 1:43 AM Subject: Re: when rebuilding keys? > > > >> before load data. > > You want to rebuild the indices after loading data, > correct? > > Martijn Tonies >

Re: dumpfile question

no, please use "load data infile" function. - Original Message - From: "Wm Mussatto" <[EMAIL PROTECTED]> To: Sent: Thursday, April 12, 2007 12:44 AM Subject: Re: dumpfile question > On Tue, April 10, 2007 19:45, Paul DuBois said: >> At 10:15 AM +0800

Re: when rebuilding keys?

before load data. - Original Message - From: "Martijn Tonies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; Sent: Wednesday, April 11, 2007 7:45 PM Subject: Re: when rebuilding keys? > > > >> My table is myisam. >> >> I disable key using "alter table ... disable keys" before load data

Can I create a index on a column of Type datetime?

I will very often do query like this: select * from mytable where create_date >='...' and create_date <='' can I create a index on the column create_date? what is the best practise? Thanks, shell. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Fw: dumpfile question

oh,yes. There is a blob column in mytable.So i use "dumpfile" instead of "outfile". There are more than 100 rows in mytable. The follow sql is successful: select * into dumpfile '/home/wangxu/test4.data' from mytable where id=1 or id=2; Why it is false t

dumpfile question

follow is my sql: select * into dumpfile '/home/wangxu/test4.data' from mytable ; mysql server report: Result consisted of more than one row why?how to use the "select into dumpfile"?

help me optimize this sql

sql: select * from table_one inner join table_two on table_two.column_one = table_one.column_one left join (SELECT * from table_three) table_four on table_four.column_two = table_one.column_three and table_fo

Re: help me optimize this "ALL"

thank you - Original Message - From: "Jay Pipes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: Sent: Tuesday, March 06, 2007 4:29 AM Subject: Re: help me optimize this "ALL" > No, because you have no WHERE condition. >

help me optimize this "ALL"

sql: SELECT * FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one = table_one.column_two INNER JOIN table_one table_one2 ON table_one2.column_one = table_one.column_three explain: *** 1. row **

oracle transfer question

There is a oracle SQL: SELECT employee_id, salary, hire_date, STDDEV(salary) OVER (ORDER BY hire_date) "Std Deviation of Salary" FROM employees WHERE job_id = 'ST_CLERK'; The result is: EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary --- -- --

How to transfer the oracle function PERCENT_RANK to mysql

How to transfer the oracle function PERCENT_RANK to mysql? oracle example: SELECT PERCENT_RANK(11000) WITHIN GROUP (ORDER BY salary DESC) "Rank of $11,000 among managers" FROM employees WHERE job_id LIKE '%MAN' OR job_id LIKE '%MGR';

How to transfer the oracle function PERCENT_RANK to mysql

How to transfer the oracle function PERCENT_RANK to mysql? oracle example: SELECT PERCENT_RANK(11000) WITHIN GROUP (ORDER BY salary DESC) "Rank of $11,000 among managers" FROM employees WHERE job_id LIKE '%MAN' OR job_id LIKE '%MGR';

oracle transfer question

There is a oracle SQL: SELECT employee_id, salary, hire_date, STDDEV(salary) OVER (ORDER BY hire_date) "Std Deviation of Salary" FROM employees WHERE job_id = 'ST_CLERK'; The result is: EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary --- -- --

How does the federated engine table work

please help me thanks. - Original Message - From: "wangxu" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 02, 2006 5:27 PM Subject: How does the federated engine table work > How does the federated engine table work when the query statement include > a

question about the query against to the federated engine tables

who can help me? - Original Message - From: "wangxu" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 02, 2006 5:29 PM Subject: question about the query against to the federated engine tables > I have a question about the query against to the federated engin

query cache about the federated engine

It bring great effect in performance if federated engine can't use the cache. If mysql intend to support it in the future? - Original Message - From: "Michael Loftis" <[EMAIL PROTECTED]> To: "wangxu" <[EMAIL PROTECTED]>; Sent: Thursday, August 03,

question about the query against to the federated engine tables

I have a question about the query against to the federated engine tables. As the following example: "select Id,name from e01_system.category" Note: the "e01_system.category" is a federated table. I select only tow fields from the federated table "category" with the above sq

How does the federated engine table work

How does the federated engine table work when the query statement include a join substatement, it joins a local table with innodb engine and a federated table. How does the server deal with the query substatement like this?

query cache about the federated engine

I have a problem about the performance of federated engine. The mysql5.0 reference manual says that the FEDERATED tables do not work with the query cache, aren't they? How about the query cache used by the federated engine in the mysql5.1? If the query cache cann't be used with the fede

dump a xml result

When i dump a table to a xml result mysqldump throw a warning: - Warning: Can't set SQL_QUOTE_SHOW_CREATE option () - If i dump the table to a txt result mysqldump don't throw the warning.

Re: split a datafile

How can i to achieve my idea? - Original Message - From: "Ow Mun Heng" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 07, 2006 4:07 PM Re: split a datafile > On Tue, 2006-02-07 at 15:48 +0800, wangxu wrote: > > I want to split a datafile to two datafiles.Ho

split a datafile

I want to split a datafile to two datafiles.How can i do?

Re:Can not get answers

The second question related to the "RAID" setup in mysql-administrator. http://forums.mysql.com/read.php?34,61374,61374#msg-61374 - Original Message - From: "wangxu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: Sent: Monday, January 23, 2006 3:57 PM S

Re: question about recovery with binlog

fman/5.0/en/replace-utility.html > man sed > man awk > > > wangxu wrote: > > How to replace it? > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > >

question about mysqlbinlog

I do the follow statement: [EMAIL PROTECTED] mysql]# /usr/bin/mysqlbinlog -h192.168.55.55 -uroot -R --to-last-log /var/lib/mysql/1.01 But the results are: --- /*!40019 SET @@session.max_insert_delayed_threads=0*

Can not get answers

I can not recieve answer about follow url for a long time. I very need the answers of those. Please help me. thanks! http://forums.mysql.com/read.php?34,61375,61375#msg-61375 http://forums.mysql.com/read.php?34,61374,61374#msg-61374 http://forums.mysql.com/read.php?34,60411,60411#msg-604

Re: question about recovery with binlog

u can parse the output of mysqlbinlog and > replace the buggy statement with the correct one. > > > wangxu wrote: > > My mysql version is 5.0.16. > > > > My problem is similar to the bug. > > > > My sql mode is ANSI and TRADITIONAL > > > > If mysq

Re: question about "CONTAINS SQL"

hould mysql to perfect these function? - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]>; "wangxu" <[EMAIL PROTECTED]> Cc: "mysql" Sent: Friday, January 20, 2006 3:20 PM Subject:Re: quest

Re: question about "CONTAINS SQL"

---+ | information_schema | | db1| | db2| | mysql | | test | | wangxu | ++ 6 rows in set (0.03 sec) mysql> use wangxu; Reading table information for completion of table and column names You can turn off t

Re: question about recovery with binlog

g was not closed properly. Most probably mysqld crashed writing it. # at 98 #060119 13:57:41 server id 1 end_log_pos 165 Query thread_id=4 exec_time=0 error_code=0 use wangxu; SET TIMESTAMP=1137650261; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_n

question about recovery with binlog

Mysqlbinlog throw out a error "ERROR 1231 (42000) at line 10: Variable 'sql_mode' can't be set to the value of '501481487'" when i recovery a binlog. What can i do?

a question about "innodb log file"

There are many information about different logs in manual but innodb log file. Please tell me where can i find it? What's innodb log file different to binlog? Where can i find data about redo and undo? thanks

Re: question about "CONTAINS SQL"

But what is INSERT OR UPDATE need? > - Original Message - > From: "Rhino" <[EMAIL PROTECTED]> > To: "wangxu" <[EMAIL PROTECTED]>; > Sent: Tuesday, January 17, 2006 9:49 PM > Re: question about "CONTAINS SQL" > >

question about "CONTAINS SQL"

I notice there are one section in the manual: CONTAINS SQL indicates that the routine does not contain statements that read or write data. And that the option is default. It's true? If i wouldn't do read or write in routine.What can i do yet?

Re: Do mysql support command-level trigger?

sorry. In general,there are two kinds of trigger's activity. One is row activity. The other is SQL-statement activity. I want to know if mysql support the second. Do you understand? thanks - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "

Re: Do mysql support command-level trigger?

help - Original Message - From: "wangxu" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 10, 2006 2:58 PM Subject:Do mysql support command-level trigger? > Do mysql support command-level trigger?

question about "master_pos_wait"

Slave server should automatically catch up master server when it be started. When i need use master_pos_wait?

Re: question about "sql security"

h-resources/articles/mysql-storedprocedures.html > > > "wangxu" <[EMAIL PROTECTED]> wrote: > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.e

about mysql security

I get a concept about mysql security. It's named "five-tiered access control".Can you tell me the detail of this concept?

Can i get a mysql technology standard

Can i get a technology standard? It include database capability,table capability,row number limit in table,blob object capability etc

an backup syntax error

Follow is my preform and result: - mysql> backup table ht_detail to '/'; +++--+--+ | Table | Op | Msg_type | Msg_text | +-

question about "sql security"

I refer a question about "sql security" option of create procedure syntax at 2005-12. But i can't quite understood with that answer. Can you give me a example to describe the effect of set "sql security" option ?

question about sql mode = ansi

AS 1.7.3. Running MySQL in ANSI Mode explain: -- Running the server in ANSI mode is the same as starting it with these options (specify the --sql_mode value on a single line): --transaction-isolation=SERIALIZABLE --sql-mode=REAL_AS_

Fw: Re: create function with space

ate function with space > > > > Hello. > > > > >From the manual: > > > > ANSI > > > > Equivalent to REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE. > > Before MySQL 5.0.3, ANSI also includes ONLY_FULL_GROUP_BY. See Section > &

Re: (ÈðÐÇÌáʾ-´ËÓʼþ¿ÉÄÜÊÇÀ¬»øÓʼþ)RE: set sql mode

es a warning for divisions by zero, but the result of the operation is NULL. Ed -Original Message- From: wangxu [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 28, 2005 7:23 PM To: Gleb Paharenko; mysql@lists.mysql.com Subject: Re: set sql mode My sql_mode is "STRICT_TRANS_T

create function with space

I set my sql_mode = 'STRICT_TRANS_TABLES,ANSI_QUOTES,ERROR_FOR_DIVISION_BY_ZERO'. Note,IGNORE_SPACE not include sql mode. But i still execute statement as follow : CREATE FUNCTION "wangxu"."user " () RET

Re: set sql mode

; >"REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI" when i > >set sql mode is "ansi". > >But now i wish sql mode only include "REAL_AS_FLOAT,PIPES_AS_CONCAT". > >Can I achieve it?wangxu wrote: > > > -- > For technical

set sql mode

It showing "REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI" when i set sql mode is "ansi". But now i wish sql mode only include "REAL_AS_FLOAT,PIPES_AS_CONCAT". Can I achieve it?

Re: how to use "sql security"

How "sql security" option restrict privileges? - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "wangxu" <[EMAIL PROTECTED]>; Sent: Wednesday, December 28, 2005 3:21 PM Subject:Re: how to use "sql security" > At 1

how to use "sql security"

User_one create a procdure named "proc" with option "sql security invoker". User_two only have "execute" privilege in the database that the "proc" in. But the User_two still call the "proc". What effect do the "sql security" option producing?

Re: insert utf8 character in Linux commind-line tool

Follow is the result. +--+-+ | Variable_name| Value | +--+-+ | character_set_client | utf8

Re: (瑞星提示-此邮件可能是垃圾 邮件)Re: (鐟炴槦鎻愮ず-姝ら偖浠 跺彲鑳芥槸鍨冨溇閭欢)Re: insert ut f8 character in Linux commind-li ne tool

ool 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 dist

Re: insert utf8 character in Linux commind-line tool

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 Str

Re: insert utf8 character in Linux commind-line tool

nicode.html > > > >I can't operate utf8 characters within command-line in linux operating > >system. Mysql doesn't support? > wangxu wrote: > > > -- > For technical support contracts, goto https://order

Re: (瑞星提示-此邮件可能是垃圾邮 件)Re: insert utf8 character in L inux commind-line tool

Are there two option? How to use them? - Original Message - From: "Andreas Streichardt" <[EMAIL PROTECTED]> To: Sent: Tuesday, December 20, 2005 3:55 AM Subject: (瑞星提示-此邮件可能是垃圾邮件)Re: insert utf8 character in Linux commind-line tool On Monday 19 December 2005 08:47, w

insert utf8 character in Linux commind-line tool

I can't operate utf8 characters within command-line in linux operating system. Mysql doesn't support?

insert utf8 character in Linux commind-line tool

无法显示邮件 Outlook Express 在显示此邮件时遇到了意外的问题。请检查你的计算机是否有足够的内存或磁盘空间，然后再试。 -- Outlook Express

Re: use deterministic within procedure

It is a doubt.What do the "deterninistic" option do? You ever gave me the follow example: - create procedure unsafe_sp() begin if @@server_id=2 then drop databaseaccounting; enf if; end - This is a

Re: use deterministic within procedure

NO,no. I want to say,if i my funciton is a non-deterministic function.But i define then function with "deterministic" option. for example: - create function test() return int DETERNINISTIC routine_body ---

invalidation rollback?!

I execute follow procedure: --- create procedure test_transation_rollback() begin start transaction; create table t_34d (c1 int,c2 char(30)); rollback; end After execut

check a table column

I create a table using the follow statement: CREATE TABLE test_check(NO_W_ID int ,NO_D_ID int,MM int,CT int,CHECK(MM > 3)); But server allow a insert statement as follow,why? insert into test_check values(1,1,1,1);

Re: use deterministic within procedure

y your self if it is possible to replicate functions > which was declared NOT DETERMINISTIC. > > > > > >I have read the replicate document in reference manual.But i have some > >question. > > >1.If a deterministic storeprocedure only use in replication? >

Re: change a variables value

tf8 character_set_results and characters_set_connections, but usually > they're should be the same). > > > >How can i set "character_set_client" to "utf8" in my.ini?Maybe there > >are not the variable.thanks! > wangxu wrote: > &

use deterministic within procedure

I have read the replicate document in reference manual.But i have some question. 1.If a deterministic storeprocedure only use in replication? 2.If a procedure within replication must be deterministic? 3.When a procedure result is non-deterministic?Can i get a example?

about innodb_safe_binlog option

My mysql version is 5.0.12-linux. I use "show variables like 'innodb_safe_binlog'". But i can't find this option.Why?

about increment backup

Mysql increment backup technique is different from others.When a binlog file be created after enable binlong? thanks!

Re: a question of specifying Times for Recovery

"default-character-set" can't set in "[client]"? - Original Message - From: "sheeri kritzer" <[EMAIL PROTECTED]> To: "wangxu" <[EMAIL PROTECTED]> Cc: Sent: Friday, November 18, 2005 5:44 AM Subject: Re: a question of specifying Tim