I know, all the shell command can do this. Thanks.
2010/8/25 Moon's Father
> Hi.
>For example, entering mysql command line client,
>mysql> pager more ( or pager md5sum and so on.)
>
>I want to know how many command the 'pager' follows? Any reply will be
> big appreciated.
>
Hi.
For example, entering mysql command line client,
mysql> pager more ( or pager md5sum and so on.)
I want to know how many command the 'pager' follows? Any reply will be
big appreciated.
Hi.
If you know chinese, I advise that you should visit the website called
http://yueliangdao0608.cublog.cn
On Sat, Jun 20, 2009 at 10:44 AM, michel wrote:
> I have MySQL set up and running, but I am under the impression that I am
> unable to password protect it properly because I can't protec
Hi.
This is a good choice!
On Tue, Jun 23, 2009 at 5:53 PM, Janek Bogucki
wrote:
> Have you tried SQL Developer? It works great with Oracle and also
> supports MySQL,
>
>
> http://www.oracle.com/technology/products/database/sql_developer/files/what_is_sqldev.html
>
> Cheers,
> -Janek
>
> On Tu
Hi.
Can you give me a flow of your master/slave?
On Wed, Jun 24, 2009 at 7:45 PM, 赵琦 wrote:
> hi all:
>I have three mysql database,tow run as master and the other one runs as
> slave.
> Some tables in the database have an autoincreament field named as 'rowid'.
> These
> tables have 100
Hi.
I think innodb will split these into many small pieces and then merge them
to execute.
On Thu, Jun 18, 2009 at 1:52 PM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi guys,
>
> On MIS (management information system) server we have 16GB of physical
> memory. 10GB has been allo
Hi.
I think you should create an index like this.
alter table user add index idx_tmp (key1,key2,key3,user_id)
2009/6/19 Darryle Steplight
> Select user_id from user where key1=value and
> key2=value2 and key3=value2 GROUP BY user_id
>
> is faster than
>
>
> Select distinct user_id from user
Could you tell me your detail statements?
On Wed, Jun 24, 2009 at 9:46 AM, sangprabv wrote:
> Hi,
> I found every time I try to do multiple rows delete on replicated MySQL
> is always failed. Is there any explanation regarding this issue and how
> to solve it? TIA.
>
>
>
> Willy
>
>
> --
> MySQL
Login mysql client. Do the following commands.
tee ie.txt;
...
notee;
On Thu, Jun 25, 2009 at 10:29 PM, John Daisley <
john.dais...@mypostoffice.co.uk> wrote:
> SELECT INTO OUTFILE does almost the same thing as spool in SQL*Plus
>
> SELECT columnname from tablename into outfile '/path/and/filenam
Who can please tell me what is mean of "The db storage is on fiber
channel."?
On Fri, Jun 26, 2009 at 1:05 AM, mos wrote:
> Mike,
> I re-posted your Show Status to the group to see if anyone can offer a
> way to speed up the indexing for you.
>
> BTW, you are adding ALL of the indexes to th
Hi.
Here is the introduction.
http://www.oracle.com/technology/oramag/oracle/05-sep/o55security.html
I want to know whether MySQL has the same function as Oracle's?
Any reply is appreciated.
--
David Yeung,
MySQL Senior Support Engineer,
Sun Gold Partner.
My Blog:http://yueliangdao0608.cublog
Ok. I have already gotten the answer.
On Wed, Jun 3, 2009 at 4:15 PM, Moon's Father wrote:
> Hi.
>I want to know which lock method is used within MySQL?
> For example, if I query the following statements within MySQL client.
> mysql> begin;
> Query OK, 0 rows affect
As I know, IN sometimes invoke unmormal index.
On Thu, May 28, 2009 at 1:15 AM, Baron Schwartz wrote:
> Simon,
>
> On Wed, May 27, 2009 at 11:23 AM, Simon J Mudd wrote:
> > per...@elem.com (Perrin Harkins) writes:
> >
> >> On Wed, May 27, 2009 at 6:43 AM, Simon J Mudd wrote:
> >> > So is the f
Thanks for your sincerely reply.
On Mon, May 11, 2009 at 11:04 PM, Baron Schwartz wrote:
> On Sun, May 10, 2009 at 10:12 PM, Moon's Father
> wrote:
> > Hi.
> > MySQL only has one datatype called bit, but its smallest storage is one
> > byte.
> > How to
Here is the table structure.
CREATE TABLE `UP_UserEx` (
`UserId` INT(11) NOT NULL,
`UserNationality` CHAR(2) NOT NULL DEFAULT '',
`UserProvince` CHAR(2) NOT NULL DEFAULT '',
`UserCity` CHAR(4) NOT NULL DEFAULT '',
`HomePhone` VARCHAR(32) NOT NULL DEFAULT '',
`WorkPhone` VARCHAR(32) NOT
Once your tables' engine are all of innodb, your configuration file has to
be changed to fit innodb's feature, not myisam.
On Tue, Apr 21, 2009 at 2:09 PM, living liquid | Christian Meisinger <
c.meisin...@livingliquid.com> wrote:
> ah sorry... there are a few UPDATEs too but most is SELECTs...
Waiting for more interesting points.
On Tue, Apr 21, 2009 at 1:42 PM, Manish Gupta wrote:
> http://www.sun.com/third-party/global/oracle/
>
> anyone saw this ??
>
> On Tue, Apr 21, 2009 at 2:54 AM, John Meyer
> wrote:
>
> > Yep. In particular the anti-trust division of the DOJ.
> > Kaushal Shriy
f he only has 512MB available for MySQL and he starts writing
> lots of
> 1GB temporary tables what's going to happen to the performance of his
> server?
>
> With advice like that you could grind his server/s to a halt and cause
> his site
> To die a miserable swappy death.
>
&
ces issues practically when implementing temporary tables.
>
> Waiting for your suggestion.
>
> Thanks,
> Manoj
>
>
> On Fri, Apr 17, 2009 at 8:21 AM, Moon's Father
> wrote:
>
>> Use temporary table can be a good idea. But I think you performance would
>&g
Use temporary table can be a good idea. But I think you performance would be
boost so much if you can do something else to replace the temporary table.
On Wed, Apr 15, 2009 at 2:03 PM, Manoj Singh wrote:
> Hi All,
>
> I have a query which returns the large number of ids which i am using in
> othe
Yeah, please show us the source code of yours.
On Wed, Apr 15, 2009 at 4:10 PM, Venu Gopal wrote:
> Hi guys,
> I am using stored procedures and stored functions for the first time.
> And currently stuck at a this point where. I am unable to retrieve
> results returned by stored function using My
Can you tell me which version of mysql you use in you test?
On Thu, Apr 16, 2009 at 12:43 AM, Pete Wilson wrote:
>
>
> Hi folks --
>
> New to MySQL. I'm developing C-language connector software and, while
> debugging, I often get the error message "MySQL server has gone away" if,
> say, I've sto
Innotop can satisfy you demand.
On Thu, Apr 16, 2009 at 4:36 PM, Hitesh Shah wrote:
> Hello,
> I'd like to know if there is a command line tool I can run to collect
> vital health information for a remote mysql server (just like
> mysqltop) for 5.0 - I often see mysql swapping to disk and would
Thanks for you reply.
I read the official document and found the variable called
"thread_concurrency" could only affect on solaris.
On Sat, Apr 11, 2009 at 5:04 AM, mos wrote:
> At 06:00 AM 4/10/2009, you wrote:
>
>> Hi.
>> If the server has 16 cores, how to set parameters to make MySQL runs
Thank you very much.
Could you tell me what is IIRC?
On Fri, Apr 10, 2009 at 8:24 PM, Uwe Kiewel wrote:
> Moon's Father wrote:
> > Hi.
> >If the server has 16 cores, how to set parameters to make MySQL runs
> > well.
>
> IIRC is mysqld multi threaded -
elational
> DBMS.
>
> Cheers
> Claudio Nanni
>
>
> Moon's Father wrote:
>
>> Hi.
>> Who could tell me when the MySQL support array datatype?
>> Any reply will be appreciated.
>>
>>
>>
>
>
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
This is because you didn't copy innodb ibdata and ib_log files togeter. Or
you forgot to stop mysqld when you remove its ib_log files.
On Sat, Feb 7, 2009 at 7:21 AM, my sql wrote:
> WHY do I see this error when restoring my backup db :
> " InnoDB: Your database may be corrupt or you may have co
Thanks for your fast reply.
Do you know MySQL will support this feature in the future?
On Sun, Feb 15, 2009 at 12:59 AM, Baron Schwartz wrote:
> Hello,
>
> On Sat, Feb 14, 2009 at 11:15 AM, Moon's Father
> wrote:
> > Here is my routine.
> > DELIMITER $$
&g
Yeah, you're right.
On Fri, Jan 16, 2009 at 10:57 AM, Daevid Vincent wrote:
> you misunderstand me. I have three servers (dev, test, prod) that all
> have maybe 3 databases EACH that have all these eventum* tables in them.
> don't ask. a simple "trickle" won't do. I'm writing a script to loop
>
Yeah. You should use mk-heartbeat, it's the best tool for this situation
that I have seen before.
On Wed, Dec 24, 2008 at 10:06 PM, Baron Schwartz wrote:
> On Wed, Dec 24, 2008 at 2:31 AM, Jake Maul wrote:
> > Slightly more complicated (and also probably more accurate- the time
> > reported by
I have solved this problem.
^_^
On Fri, Dec 12, 2008 at 10:54 AM, Moon's Father
wrote:
> Hi.
> I want to know how to connect mysqld with ssl encryption from windows or
> linux system.
> Any reply will be appreciated.
>
> Here is my status.
>
> mysql> status
>
//www.danga.com/memcached/apis.bml
>
> http://tangent.org/index.pl?node_id=506
>
>
> -Original Message-
> From: Moon's Father [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 03, 2008 1:22 AM
> To: MySql
> Subject: Could somebody tell me how to use the memcac
Although I set up memcache engine successfully on my computer, I didn't know
how to use it?
I can not find where the document is.
Here is my result of engines.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.1.30 Source distribution
Type
Thanks for advice.
There're no environment for me to test the cluster again right now. Hope the
chance chooses me, then the english version will be done.
:)
On Fri, Nov 21, 2008 at 10:48 AM, steve grosz <[EMAIL PROTECTED]>wrote:
> Hello Moon's Father,
>
> That would b
What is your storage engine used?
On Fri, Nov 21, 2008 at 8:59 AM, Marten Lehmann <[EMAIL PROTECTED]> wrote:
> Hello,
>
> what do these errors mean:
>
> mysqldump: Got error: 1030: Got error 1 from storage engine when using LOCK
> TABLES
> mysqldump: Couldn't execute 'show create table `Antrag`':
What is your storage engine used?
On Fri, Nov 21, 2008 at 8:59 AM, Marten Lehmann <[EMAIL PROTECTED]> wrote:
> Hello,
>
> what do these errors mean:
>
> mysqldump: Got error: 1030: Got error 1 from storage engine when using LOCK
> TABLES
> mysqldump: Couldn't execute 'show create table `Antrag`':
Try drop table if exists Tablex;
On Fri, Nov 21, 2008 at 9:53 AM, mos <[EMAIL PROTECTED]> wrote:
> How can I determine if a temporary table exists? Normally I use something
> like:
>
> create temporary table Tablex like Table1;
> show tables like "Tablex";
>
> but the Show Tables never displays a
I had done many instances on one machine before, the most important thing
is about the my.cnf.
And there are many individual my.cnf, which belonged to their own instance.
Since your total memory is 32GB, you can assign them properly.
On Fri, Nov 21, 2008 at 3:40 AM, Claudio Nanni <[EMAIL PROTECTE
You may execute mysql_fix_privileges_table script to upgrade all of your
mysqld.
On Thu, Nov 20, 2008 at 7:54 PM, Ronan Lucio <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I installed MySQL-5.0.67_1.
> When I execute "CHECK TABLE information_schema.COLUMNS FOR UPGRADE" I get
> the message:
>
>
> +
Hi.
Here are some of my tests on Centos 5.0.
http://blog.chinaunix.net/u/29134/article_71956.html
On Fri, Nov 21, 2008 at 3:49 AM, Ronan Lucio <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Does anybody has a tip to install a MySQL Cluster in a Linux CentOS-5?
> Is it better from source or can it be from
Maybe your tables were not properly designed.
On Tue, Nov 18, 2008 at 10:35 AM, sangprabv <[EMAIL PROTECTED]> wrote:
> Thanks for the reply, does this overhead reduce performance? And is
> there any tips to avoid this overhead? TIA.
>
>
> WM
>
>
> --
> MySQL General Mailing List
> For list archiv
Yeah, it's really a nice tool for me.
Thanks.
On Tue, Nov 18, 2008 at 5:44 AM, Saravanan <[EMAIL PROTECTED]> wrote:
> really nice tool.
>
> Thanks,
> Saravanan
>
> --- On Mon, 11/17/08, lakshmi pathi <[EMAIL PROTECTED]> wrote:
>
> From: lakshmi pathi <[EMAIL PROTECTED]>
> Subject: A tool
> To: my
Hi.
I got an error message when I adjust the system variable named
default-time-zone.I don't how to adjust this variable.
Hope to get help here.Thanks.
Here is my error log.
081113 15:24:43 InnoDB: Started; log sequence number 0 423199200
081113 15:24:43 [Note] Recovering after a crash using my
I'm sorry to mistake the wrong storage engine.
On Wed, Nov 12, 2008 at 3:52 PM, Moon's Father <[EMAIL PROTECTED]>wrote:
> Hi.
>I got an error when I use alter statement to modify an innodb's table
> structure. The error no is 1114 and the detail information is
&
Hi.
I got an error when I use alter statement to modify an innodb's table
structure. The error no is 1114 and the detail information is
ERROR 1114 (HY000): The table '#sql-4c0_1' is full.
Here is my table's structure.
mysql> show create table t1;
+---+---
t you can download it from the Proven Scaling mirror.
>
> http://mirror.provenscaling.com/mysql/community/source/4.0/
>
> -Eric
>
> On Thu, Nov 6, 2008 at 1:58 AM, Joerg Bruehe <[EMAIL PROTECTED]> wrote:
> > Hi!
> >
> >
> > Moon's Father wrote:
> &g
Thanks for your patient reply.
Now I believe that the memory leak problem was generated by the program.
On Sat, Nov 1, 2008 at 5:31 PM, Ian Christian <[EMAIL PROTECTED]> wrote:
> 2008/10/31 Moon's Father <[EMAIL PROTECTED]>
>
>> *A prepared statement is also glo
ing. Which you might need to increase depends entirely on which
> limitation you're running into... if the current index files for the
> relevant tables on disk exceed 2GB, you might want to increase
> myisam_max_sort_file_size. Otherwise, myisam_sort_buffer_size might be
> bet
In my experiences, there're three reasons below.
1. Your network is not stable.
2. Your mysqld's parameter called max_allowed_packet is adjusted too small,
trying to increase it.
3. Your mysqld's parameter called connect_timeout is adjusted too small,
trying to increase it.
On Thu, Oct 30, 2008 at
I think Claudio Nanni 's suggestion is the best!
On Thu, Oct 30, 2008 at 8:29 PM, Claudio Nanni <[EMAIL PROTECTED]>wrote:
> Hi Mark,
>
> from my experience I can tell you that you can easily migrate.
>
> A quick and dirty way is to use the two(or more) different MySQL
> installations
> on same se
Hi,andy.
Can you show me the details about the options of mysqldump to be used ?
On Fri, Oct 31, 2008 at 1:25 AM, Andy Smith <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Im having an issue using mysqldump to dump a DB from comercial app which
> includes mysql 4.0.18-pro. It doesnt however include mysq
alter table tablename modify id int not null auto_increment primary key;
On Sat, Oct 25, 2008 at 2:48 AM, Paul <[EMAIL PROTECTED]> wrote:
> Anybody know if there's a way to change a primary key field that is not
> auto-incremented, turning on auto-increment but preserving the values that
> are cu
Thanks.
On Tue, Oct 28, 2008 at 3:17 PM, Micah Stevens <[EMAIL PROTECTED]>wrote:
> It's a package for Debian based systems, which include Ubuntu and a few
> others..
>
> It's like an RPM for Fedora/Redhat linux.
>
> -Micah
>
> On 10/27/2008 06:39 PM, Moon
Setting is difficult but checking is simple.
On Thu, Oct 9, 2008 at 9:26 PM, Amit Sharma <[EMAIL PROTECTED]> wrote:
> Hi Sudhir,
> #show table status command will give you most of what all is required. Have
> a look at the results & post any further query if you have.
>
> Regards,
> Amit Sharma
>
I'm sorry that if I can ask a question.What is DEB?
On Fri, Oct 3, 2008 at 9:49 PM, US Data Export
<[EMAIL PROTECTED]>wrote:
>
>
> >-Original Message-
> >From: Ellison, David [mailto:[EMAIL PROTECTED]
> >Sent: Friday, October 03, 2008 2:35 AM
> >To: mysql@lists.mysql.com
> >Subject: RE: D
I advise that you should put your my.cnf in mysql installation location.
On Mon, Oct 6, 2008 at 11:06 PM, Varuna Seneviratna <
[EMAIL PROTECTED]> wrote:
> Armin
> I did what you said, now I understand what you say that there is no
> sence in what I wanted to do.But I gave these commands as
I also want to know the answer to this question.If it's for me.I'll scan all
the source code manually.But it's too complicated.
On Tue, Oct 7, 2008 at 1:02 AM, Olaf Stein <
[EMAIL PROTECTED]> wrote:
> It specifies the query in the Info field.
> In your case the connection is "sleeping", nothing i
Just use command line tools called fc on windows or diff on linux if you are
patient and perfer trouble.
On Tue, Oct 7, 2008 at 10:07 PM, Duzenbury, Rich <[EMAIL PROTECTED]>wrote:
>
> I just used mysqldiff for a project, and was successful.
>
> -Original Message-
> From: Uma Bhat [mailto:
Or you can create a temporary table including a auto_increment attribute and
fill it with continuous numbers.
Then simply use it to left join the original table.
On Sat, Oct 25, 2008 at 2:57 PM, Moon's Father <[EMAIL PROTECTED]>wrote:
> Create an extra trigger on that table with del
Create an extra trigger on that table with delete event.Then the deleted
item will be recorded in the database.
On Fri, Oct 10, 2008 at 11:34 PM, Jerry Schwartz <[EMAIL PROTECTED]
> wrote:
> Thanks.
>
>
>
> Although I've been around SQL for quite a while, I've never really gotten
> the hang of se
Just use another term will solve your problem.Or you can use pager more in
mysql command line client.
On Sun, Sep 28, 2008 at 12:44 AM, Dan Nelson <[EMAIL PROTECTED]>wrote:
> In the last episode (Sep 27), Alex Katebi said:
> > Hi,
> >
> > When selecting (example: select * from mysql.db ) some o
There are some of backup scripts written by me.You can find it at:
http://blog.chinaunix.net/u/29134/article_71953.html
On Wed, Oct 22, 2008 at 4:52 PM, Mad Unix <[EMAIL PROTECTED]> wrote:
> Any one tried the script from HowToForge
>
>
> http://www.howtoforge.com/shell-script-to-back-up-all-mysql
See the usage of the function named field.
On Mon, Jul 28, 2008 at 8:15 PM, Mr. Shawn H. Corey <[EMAIL PROTECTED]>wrote:
> On Mon, 2008-07-28 at 07:32 -0400, Gary Josack wrote:
> > Andrew Martin wrote:
> > > Hello,
> > >
> > > Is it permissible to order a clause such that the search term is the
>
Any additional tools will satisfy your demand.
On Mon, Oct 13, 2008 at 7:34 PM, Sudhir Menon <[EMAIL PROTECTED]> wrote:
> My reply was with regards to the answer in this post.
> http://lists.mysql.com/mysql/214827
>
> Anyways thanks for the concern from your end.. Mike :) My query was
> answered
Make sure your log_bin_trust_function_creator is on.
On Sun, Sep 28, 2008 at 3:04 AM, Jesse <[EMAIL PROTECTED]> wrote:
> I'm trying to use existing functions from a restored database from 5.0xx to
> 5.1, and get an error about the mysql.proc table is missing or corrupt. The
> mysql.proc table app
You may see the section named group by optimization on the document.
On Tue, Sep 30, 2008 at 4:44 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> Glancing over things I suggest:
> ALTER TABLE browse_nodes_to_products ADD INDEX(browse_node_id,product_id);
>
> (if product_id has greater cardinality pu
Show the details of your hardware us.
On Thu, Oct 2, 2008 at 3:02 PM, Krishna Chandra Prajapati <
[EMAIL PROTECTED]> wrote:
> Hi,
>
> Just try the below command on console. It will give that the error is
> exactly related to what.
>
> $perror 5
>
> What is total ram in your box.
>
>
> On Thu, Oct
Hi.
I think you had a mistake for the server types.Mysql-nt.exe is the only
exexutable program on windows.So you just pay close attention about it.
On Mon, Oct 6, 2008 at 8:35 PM, Steven <[EMAIL PROTECTED]> wrote:
> > Steve
> (n)
> Martin!
>
>
> > if you want apache and mysql (and possibly PHP
There're an article about master to master replication at my blog.
On Thu, Oct 9, 2008 at 3:45 PM, Simon J Mudd <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] ("Carl") writes:
>
> > I am running 5.0.24a on Slackware Linux. I would like to set up a
> master-master replication process so that I ca
If you want to choose the first one, then the flag' data type must be
enum.For int fill the disk with 4 byte and enum just 1 byte.
On Sat, Oct 4, 2008 at 2:15 AM, Alex K <[EMAIL PROTECTED]> wrote:
> That seems like a nice trick. I suppose the flag would just be an int
> and not an enum in this cas
mrc_titles is a temp table?
On Wed, Oct 15, 2008 at 11:59 PM, Jerry Schwartz <[EMAIL PROTECTED]
> wrote:
> I tried to make a query that joins to subqueries:
>
>
>
> SELECT discontinued.b
>
> FROM
>
> (SELECT mrc_titles.title AS a
>
> FROM mrc_titles JOIN prod ON mrc_titles.tit
It's very nice!
But it's too simple.
On Mon, Oct 6, 2008 at 12:26 AM, Anders Karlsson <[EMAIL PROTECTED]> wrote:
> Sorry for crossposting, but I think this is relevant both th general MySQL
> and specifically to Win32 users.
>
> MyQuery 2.3 has a lot of new features, a few bugfixes and some other
Maybe you should set your old_passwords = on.
On Fri, Oct 17, 2008 at 4:36 PM, Sudhir Menon <[EMAIL PROTECTED]> wrote:
> Hi Ujang
>
> I could reproduce the same error mentioned by you in the actual post even
> after having all of the packages for MySQL. Figuring out the what could be
> the probl
This is because either somebody is attacking your mysqld or your variable
named connect_timeout is very lower.
On Wed, Oct 22, 2008 at 9:55 PM, Krishna Chandra Prajapati <
[EMAIL PROTECTED]> wrote:
> Hi list,
>
> Aborted clients and connects are increasing very fast.
>Aborted_clients
> 4934
Add skip-name-reslove in my.cnf and restart mysql immediately.
On Thu, Oct 23, 2008 at 12:37 AM, Richard S. Huntrods
<[EMAIL PROTECTED]>wrote:
> Awesome! Thanks very much - exactly what I was looking for. I'm in the
> field and was under the gun, otherwise would have checked the manuals first.
>
It didn't occured unless you manually changed your user's privilege.
On Wed, Oct 22, 2008 at 11:05 PM, kalin m <[EMAIL PROTECTED]> wrote:
>
> hi all...
>
> i had a weired thing happened
>
> is it possible for a user privileges to expire?!
>
> suddenly today an application stopped working and
I know it.Thanks.
I'm sorry that I had a mistake to what you said.
On Thu, Oct 23, 2008 at 2:32 AM, Ian Christian <[EMAIL PROTECTED]> wrote:
> 2008/10/21 Moon's Father <[EMAIL PROTECTED]>:
> > Could you please give me an idea of how to manage the privil
You're wrong.The new log file will be generated when you flush logs
manually.
On Fri, Oct 24, 2008 at 2:23 AM, Olaf Stein <
[EMAIL PROTECTED]> wrote:
> And I assume you backup script also archives or removes the old log file,
> because flush-logs does not start a new log file if there is still on
Just staightly use ... in .. is ok.
On Fri, Oct 24, 2008 at 12:57 AM, Bill Newton
<[EMAIL PROTECTED]>wrote:
> Pretty standard mysql function. Its been in mysql for a while.
>
> http://dev.mysql.com/doc/refman/4.1/en/string-functions.html#function_field
>
>
>
>
> Jim Lyons wrote:
>
>> I'm not fami
Maybe it's a bug.^___^
On Thu, Oct 9, 2008 at 1:37 PM, Andrew Garner <[EMAIL PROTECTED]>wrote:
> On Wed, Oct 8, 2008 at 3:10 AM, Zbigniew Szalbot <[EMAIL PROTECTED]>
> wrote:
> > Hi there,
> >
> > I hope someone can help. Due to they way my HD has been sliced I had
> > to move mysql database to
Could you please give me an idea of how to manage the privileges inside
mysql?
Thank you very much.
On Wed, Oct 15, 2008 at 5:01 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> On Tue, Oct 14, 2008 at 1:49 PM, Grant Peel <[EMAIL PROTECTED]> wrote:
> >
> > Hi all,
> >
> > I run a shared Apache, Perl,
You could create an extra table in order to record the max number of
widget,the the ID should alway be 1.
On Thu, Oct 16, 2008 at 2:04 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> I would do a muli key PK with a after insert trigger to that would
> change widget_number 1 to 1000. Just my HO...
>
select * from
(
SELECT ID_number, count( CU_number ) AS CC
FROM MyTable
GROUP BY ID_number
) T
WHERE CC =
(
select max(cc) from
(
SELECT ID_number, count( CU_number ) AS CC
FROM MyTable
GROUP BY ID_number
) T2
)
On Wed, Oct 15, 2008 at 5:08 PM, dave aptiva <[EMAIL PROTECTED]>wrote:
> Hello a
Learnt!
On Wed, Oct 15, 2008 at 5:28 PM, philip <[EMAIL PROTECTED]> wrote:
> > Date: Tue, 14 Oct 2008 16:55:11 +0300
> > From: Olexandr Melnyk <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED], mysql@lists.mysql.com
> > Subject: Re: Problem with GROUP BY
> >
> > http://jan.kneschke.de/projects/mysql/
Timestamp is the best bridge between java and mysql,I think.
On Sun, Oct 19, 2008 at 4:48 PM, Rama <[EMAIL PROTECTED]> wrote:
> DATE TIME ZONE SENSITIVE
>
> DATETIME NOT SENSITIVE TO TIME ZONE
>
> TIMESTAMP TIMEZONE SENSITIVE
>
> iam getting the above problem as date is timezone sensitive.i
Maybe you can use mysql -e instead.
On Mon, Oct 20, 2008 at 12:51 AM, walter harms <[EMAIL PROTECTED]> wrote:
> hi ronaldo i tried and failed.
> it seems that mysql has no option to specify a select statement.
> did i mis something ?
>
> re,
> wh
>
>
> walter harms schrieb:
> > hi ronaldo,
> > i
Only increase max_allowed_packet is ok.
On Tue, Aug 19, 2008 at 5:49 PM, Warren Young <[EMAIL PROTECTED]> wrote:
> Mad Unix wrote:
>
>>
>> During the update of the MySQL DB (delete/insert), I keep getting the
>> following message
>> Lost connection to MySQL server during query...
>>
>
> By defaul
Use mysqldump on the old version and import the data into new version in my
opinion.
On Fri, Aug 22, 2008 at 1:29 AM, Andy Shellam <[EMAIL PROTECTED]>wrote:
> FYI the manual for 5.0 recommends upgrading to 4.1 first.
>
> "As a general rule, we recommend that when upgrading from one release
> seri
This is weird issue that I have never met.I think you should show us your
table's definition phrase and use flush tables to shut down all the open
tables.
On 8/21/08, Abdul Gomaa <[EMAIL PROTECTED]> wrote:
>
> Hey everyone!
>
> I really hope this is the right place to post this problem. I have hav
You should increase parameter named max_bulk_insert_buffer_size and
max_allowed_packet.
On 8/21/08, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> Mysql use tmpdir,
> when ever there is any index creation.
>
> regards
> anandkl
>
>
> On 8/21/08, jthorpe <[EMAIL PROTECTED]> wrote:
> >
> > Hi,
> >
> >
Check if your connections are too large to afford any other connections.
On Mon, Aug 11, 2008 at 8:54 PM, Krishna Chandra Prajapati <
[EMAIL PROTECTED]> wrote:
> Hi All,
>
> Connecting to mysql server is taking lot of time near around 4 to 5
> seconds.
> Its a pentium box with 512Mb ram max_conne
If you have the whole backup ,then you can simply use reset slave statement
to purge all the relay log on your slave machine and use change master to
statement to do a new slave configuration.
On Tue, Aug 12, 2008 at 2:59 AM, Michael Dykman <[EMAIL PROTECTED]> wrote:
> The first thing that occurs
Remove line contains naxbmisq02-relay-bin.000157 in your
naxbmisq02-relay-bin.index file.
On Fri, Aug 8, 2008 at 1:58 AM, Brown, Charles <[EMAIL PROTECTED]> wrote:
>
>
> Please advise me on how to restart MYSQL slave instance.
>
> All efforts have failed. When I issued the "START SLAVE" command it
Add additional option to my.cnf
[mysqld]
relay-log-purge=1
On Mon, Aug 11, 2008 at 2:21 AM, Brown, Charles <[EMAIL PROTECTED]> wrote:
> Here is what I'm getting
>
> mysql> change master to master_host = 'naxbmisq01.bmi.com', master_user
> = 'repl', master_password = 'repl';
> ERROR 1201 (HY000)
Delete all your relay log ,restart mysqld and use a new change master to
statement to do a slave configuration.
On Sat, Aug 9, 2008 at 2:32 PM, Brown, Charles <[EMAIL PROTECTED]> wrote:
>
> Could not initialize master info structure;
>
> Can someone help me. I am getting the above message
> *
If you're good at Chinese ,just visit here.
http://blog.chinaunix.net/u/29134/showart_375303.html
On Thu, Aug 7, 2008 at 10:34 PM, Magnus Smith <
[EMAIL PROTECTED]> wrote:
> I think got it in the end by doing a union and a join.
>
> delete AA, PA from ACCOUNTACTION AA, ACCOUNTPAYMENTACTION PA
> w
Now mysql's version is 5.0.45
Any reply is appreciated.
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
Hi.
There are 1 store procedures in my database,and prepared statement was
used within procedure's definition.
But when our concurrency is higher,mysqld's memory grows very fast.
PS:I have explicitly used drop prepare .. statement in procedure's
definition.
Anybody can tell me why this happen
mysql> show global status like '%stmt%';
+-+-+
| Variable_name | Value |
+-+-+
| Com_stmt_close | 4875504 |
| Com_stmt_execute| 4875504 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare| 48
Innodb was also purchased by Oracle in its attempt to kill MySQL after its
>> failed attempt to purchase MySQL. That's why MySQL has been working on
>> their own storage engine as well as the pluggable storage system.
>>
>> Curtis
>>
>> David Gir
1 - 100 of 206 matches
Mail list logo
