Any reply is appreciated .
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
Add an autoincrement attribute will make you clear.
On Fri, Jul 4, 2008 at 4:55 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
u mean to says if u have 100 records u want 50 records in one table and
another 50 records in another table?
On 7/4/08, Chandra N [EMAIL PROTECTED] wrote:
Hi,
The biggest difference is that 4.1 does not support store routine but the
5.1 support.
On Sat, Jul 5, 2008 at 1:08 AM, Pablo [EMAIL PROTECTED] wrote:
Hi all,
I'm looking for some information about difference and new features
between mysql 5 and mysql 4.1
Can somebody give me any
When my database machine's load is too high,the procedure spend more much
time than normal use.
Here is my mysqldumpslow 's result.
Count: 5 Time=6.60s (33s) Lock=0.00s (0s) Rows=1.0 (5),
[EMAIL PROTECTED]
SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA='site' AND
When the memory can not load our application,the error occurs.
080630 17:32:38 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed
1651540 bytes)
And there are some data displayed ? in my database.
For example.
mysql select * from passport where name like '%??%' limit 1\G
PROTECTED] wrote:
Is this data comming from application or loaded using LOAD DATA command.
Can u please check the character set of the db and columns.
On 6/30/08, Moon's Father [EMAIL PROTECTED] wrote:
When the memory can not load our application,the error occurs.
080630 17:32:38 [ERROR
You can write a shell script to kill these threads one by one.
On Mon, Jun 30, 2008 at 9:43 AM, Marcin Polewski [EMAIL PROTECTED]
wrote:
On my machine, I start the following command:
/bin/sh /usr/local/bin/mysqld_safe
--defaults-extra-file=/var/db/mysql/my.cnf --user=mysql
I advise you should add a new column to save this information
date_format(cache.server.tstamp,%Y %M %d %H %i)) and add a new index on
it.
On Sat, Jun 28, 2008 at 8:55 PM, Darryl Steyn [EMAIL PROTECTED]
wrote:
Hi Ananda,
At the moment the explain for the entire month will look the same as
For example,the user is [EMAIL PROTECTED]
I want to adjust timeout value for him ,which is different from the global
parameter named interactive_timeout or wait_timeout?
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
Maybe you have to adjust your file limit by user named mysql.
On Sat, Jun 21, 2008 at 7:50 PM, [EMAIL PROTECTED] wrote:
Hi All,
I am running mysqldump with --no-data option, but it gives error:
can't exec 'show fields from ...' out of resources when opening file ...
(errorcode 24) (23)
The official table's data.
++---+-+
| id | title | body|
++---+-+
| 1 | MySQL Tutorial| DBMS stands for DataBase ...
This is because only one cpu is enough for your concurrent.
On Sun, Jun 22, 2008 at 12:14 AM, Per Jessen [EMAIL PROTECTED] wrote:
Eber Duarte wrote:
I noticed that I always have 2 processes runing on Linux doesn't
matter the amount of concurrent connections that is running on MySQL.
Due
Maybe you shoul write your insert statement like this.
insert into LogTable set SQL='select ''abc'' from table';
On Sun, Jun 22, 2008 at 3:46 AM, mos [EMAIL PROTECTED] wrote:
I have my own log table which contains a Text column that is suppose to
store SQL statements that fail to execute
I don't know whether I got your mean or not.
I advise that you should take a look at this url.
http://www.day32.com/MySQL/
On Sun, Jun 22, 2008 at 12:41 AM, Atle Veka [EMAIL PROTECTED] wrote:
I don't think anyone answered your actual question, so here's my attempt..
:* Moon's Father [EMAIL PROTECTED]
*To:* [EMAIL PROTECTED]
*Cc:* mysql@lists.mysql.com
*Sent:* Saturday, June 21, 2008 12:20 PM
*Subject:* Re: mysqldump giving errors
Maybe you have to adjust your file limit by user named mysql.
On Sat, Jun 21, 2008 at 7:50 PM, [EMAIL PROTECTED] wrote:
Hi All
Can you show us the proper view of your sql statement by adding \G.
On Sat, Jun 21, 2008 at 1:57 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
The below query performance in 10 sec when there are no other activity on
db
, but when any insert or LOAD DATA Index creation happens it takes close
to
How large is your total memory?
There parameter seems too large.
On Sun, Feb 10, 2008 at 5:42 PM, VeeJay [EMAIL PROTECTED] wrote:
Hello
I am running a Freebsd server:
1. Software:
Apache 1.3
mysql 5.0.27
php 4.4
2. Hardware:
2 intel procerssors
4 gb ram
RAID 10 with hard drives 15K
How large is your total memory?
There parameters' value seem too large.
On Mon, Jun 16, 2008 at 4:49 PM, Moon's Father [EMAIL PROTECTED]
wrote:
How large is your total memory?
There parameter seems too large.
On Sun, Feb 10, 2008 at 5:42 PM, VeeJay [EMAIL PROTECTED] wrote:
Hello
I am
Good.
On Fri, Jun 13, 2008 at 3:23 AM, Lori Kurovski [EMAIL PROTECTED] wrote:
We are currently looking for a contractor for 30 days in Kansas City that
has experience doing MySQL DBA/Windows Server Administration work. This
will be a production support role as the consultant will be covering
This is also what I want to know.
Waiting for somebody's help.
On Thu, Jan 17, 2008 at 12:39 AM, Britske [EMAIL PROTECTED] wrote:
Hi,
I have a partitioned table using hash. For the example lets say I have N
partitions. Selects perform well due to the partitioning. However I
noticed
that
Just execute as the following.
1、create table b like a;
2、alter table b add ;
3、insert into b select a.
4、alter table b rename to a;
On Wed, Apr 16, 2008 at 11:08 PM, Arun Kumar PG [EMAIL PROTECTED]
wrote:
given that my table is in myisam, there are some hacky way of doing this
The maximum width is int(20).
On Thu, May 22, 2008 at 5:15 PM, Saravanan [EMAIL PROTECTED] wrote:
what kind of datatype it is int(50)
parent_id| int(50)
is that big int?
Saravanan
--- On Thu, 5/22/08, Norbert Tretkowski [EMAIL PROTECTED] wrote:
From: Norbert Tretkowski
You can manually restart the slave process.
On Wed, May 21, 2008 at 9:11 PM, Dominik Klein [EMAIL PROTECTED] wrote:
Hello mysql list
I posted this problem to the list earlier this month:
Error reading packet from server: Out of memory (Needed 6560 bytes) (
server_errno=5)
I was then told
This is a classic error.
You just reconfigurate the parameter master_log_file and master_log_pos
.Good luck.
On Fri, May 23, 2008 at 5:13 AM, Mike [EMAIL PROTECTED] wrote:
On Thu, May 22, 2008 at 10:41 AM, François Beausoleil
[EMAIL PROTECTED]
wrote:
Hi all!
I must be stupid or
If you create all your databases and tables with utf8,then every thing is
fine.
On Mon, Apr 28, 2008 at 1:43 AM, Velen [EMAIL PROTECTED] wrote:
Hi,
I'm storing some ascii codes in a table. When I do a dump using mysqldump
from the server and then restoring it on another station, the ascii
Here is my test.
Any way can retrieve the metadata.
On Fri, May 9, 2008 at 10:45 PM, Martijn Tonies [EMAIL PROTECTED]
wrote:
SHOW CREATE TABLE ...
Yes, I thought so :-(
From a coding point of view, this requires parsing...
Why isn't there anything in show full columns.
Martijn
Didn't you google it ?
On Thu, May 8, 2008 at 1:59 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I am getting below error. This is the only table of INNODB ENGINE, the
default storage engine is MyISAM
mysql create table tmp_dc as select gid,siteid,has_gy,starts from dc_tc;
ERROR 1206
I think you should check the error with perror at first.
On Sat, May 24, 2008 at 12:46 AM, Mike [EMAIL PROTECTED] wrote:
On Fri, May 23, 2008 at 12:08 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Mike,
Since i have done a fresh backup from master (with master db down), and
copied over
If you didn't define zerofill
int is equal to int(11)
if the actual variable is 59,then all display 59.
On Thu, May 22, 2008 at 4:53 PM, Glyn Astill [EMAIL PROTECTED] wrote:
int(10) will pad with zeros on return, i.e. if value = 59
int(10) 59
int59
- Original
learnt
On Wed, Apr 30, 2008 at 5:18 AM, Mihail Manolov [EMAIL PROTECTED]
wrote:
Hi all,
I feel obliged to report on my success with migration from 32bit to 64bit
platform.
Last Sunday I braced myself and migrated 3 servers (one master and two
slaves) with approximately 100GB data each by
]:
On May 21, 2008, at 8:09 AM, Moon's Father wrote:
Now I want to know which way you use to create index of a table.
1、ix_u (item_id,item_count)
ix_item_count (item_count)
This makes sense if you have queries which search item_id AND item_count,
and queries which just search the column
Thanks very much.
2008/5/21 Paul McCullagh [EMAIL PROTECTED]:
On May 21, 2008, at 8:46 AM, Paul McCullagh wrote:
On May 21, 2008, at 8:09 AM, Moon's Father wrote:
Now I want to know which way you use to create index of a table.
1、ix_u (item_id,item_count)
ix_item_count (item_count
In china?
On Thu, May 22, 2008 at 1:43 AM, bruce [EMAIL PROTECTED] wrote:
Hi...
Got a small personal project that I'm considering, and I realize that I
need
a mysql database guru/dba to talk to to figure out the best approach to
implementing a database for my needs of the project.
The
That is fine.
On Thu, May 8, 2008 at 4:51 PM, Neil Tompkins [EMAIL PROTECTED]
wrote:
Perfect. It worked just how I wanted.
Thanks for your help.
Neil
Date: Wed, 7 May 2008 19:54:39 +0200 To: [EMAIL PROTECTED]
Subject: Re: Order Problem From: [EMAIL PROTECTED] Hi, You should
look
Change the following parameter:
myisam_sort_buffer_size=300MB
Larger than here.
myisam_max_sort_file_size=10GB
Reduce this value to 30% of your real memory.
On Tue, May 13, 2008 at 7:10 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Krishna,
how do i make my index to get more key blocks
On
You should post this question to php section.
On Wed, May 21, 2008 at 6:51 AM, Dave Shariff Yadallee - System
Administrator a.k.a. The Root of the Problem [EMAIL PROTECTED] wrote:
Customer has tested his site in Mysql 5.1 and we are running Mysql 4.1 .
His test works but over here we get:
You should keep it on in my opinion.
On Tue, May 13, 2008 at 6:04 PM, Nico Sabbi [EMAIL PROTECTED] wrote:
Hi,
I guess that when I'm using only Innodb and no replication I can
safely disable mysql's (bin-) log files (that grow to no end) because
Innodb has its own log files. Is it correct?
What is LVM?
2008/5/12 MarisRuskulis [EMAIL PROTECTED]:
Hello!
I'm wondering about MySQL LVM2 preformance, but cant found any
comparisions. I know that there is some speed decrease with LVM,
something about 30%. But how this decrease impacts overal MySQL
performance?
Now we are backuping
Don't you use the following statements instead of yours?
...month between 10 and 12
On Wed, May 7, 2008 at 1:46 AM, kabel [EMAIL PROTECTED] wrote:
I have a table from which I need to calculate the percentage growth of
downloads from specific countries over two distinct periods of time.
The general version can not be replaced *frequently *
On Fri, May 9, 2008 at 4:23 PM, Dominik Klein [EMAIL PROTECTED] wrote:
Upgrade to 5.0.51b seems to have solved the problem. On wednesday, I saw
the problem about a dozen times during a peak time. Upgraded wednesday night
and have not seen
Just try to get it.
On Mon, May 5, 2008 at 10:12 PM, SQL Maestro Group [EMAIL PROTECTED]
wrote:
Hi!
SQL Maestro Group announces the release of Data Wizard for MySQL 8.4, a
powerful Windows GUI solution for MySQL data management.
Data Wizard for MySQL provides you with a number of
You can import your data into a test database,then export the data using
statement select ... into ...
then You can complare the two.
On Tue, May 20, 2008 at 9:14 AM, Dan Lipsitt [EMAIL PROTECTED] wrote:
Is there a set of flags for mysqldump that will include the auto_increment
specifier for
You can add this condition in the configuration file if you didn't find
other way to solve this.
expire_logs_per_day = 4
On Tue, May 20, 2008 at 12:14 AM, Todd Lyons [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, May 18, 2008 at 01:02:32PM +0530, Ananda Kumar
To make the parameter max_allowed_packet larger.
On Mon, May 19, 2008 at 12:17 PM, sangprabv [EMAIL PROTECTED] wrote:
Hi,
Currently in my production environment, mysql only allow max 50.000
records per insert. Is it possible to increase the number of records
inserted during insert into
You are right.
Mysql 4.0 don't have a concept charset.
2008/5/16 MarisRuskulis [EMAIL PROTECTED]:
Found partial sollution! Need to specify mysql_query(SET NAMES
'latin1'); for connection charset.
MarisRuskulis wrote:
Hello!
I'm trying to migrate database from mysql 4.0 to 5.0 (latin1).
I mean database,not table.
thank you all the same.
On Mon, May 12, 2008 at 1:55 PM, Krishna Chandra Prajapati
[EMAIL PROTECTED] wrote:
show table status;
On Mon, May 12, 2008 at 11:19 AM, Moon's Father [EMAIL PROTECTED]
wrote:
I want to know the create time of a database,but I can
Thanks for your reply very much.
I know this way.
Could you know how to get this just by sql?
On Mon, May 12, 2008 at 2:57 PM, Iñigo Medina García
[EMAIL PROTECTED] wrote:
Hi Moon's Father, :-)
what about through filesystem? $ ls -la /path-mysql-databases or
something like that.
Iñigo
Thanks for your reply.
I know this way to comment outside of a store procedure,But this is not my
need.
On Wed, Apr 30, 2008 at 10:49 PM, Saravanan [EMAIL PROTECTED] wrote:
Use
alter procedure procedure_name comment 'comments string'
Saravanan
--- On Wed, 4/30/08, Moon's Father [EMAIL
if that works for you.
Regards
Baron
On Wed, Apr 30, 2008 at 5:27 AM, Moon's Father
[EMAIL PROTECTED] wrote:
When I execute the following statements in the command line:
DELIMITER $$
DROP PROCEDURE IF EXISTS `t_girl`.`sp_test`$$
CREATE [EMAIL PROTECTED] PROCEDURE `sp_test`()
BEGIN
Make sure your mysqld is running
On Fri, Apr 4, 2008 at 3:24 AM, Joerg Bruehe [EMAIL PROTECTED] wrote:
Hi,
Vidal Garza wrote:
[[...]]
I have a cuestion, where do you find the system header files error
number (61)?
I do that brute-force:
#! /bin/sh
#
# FGIN shell
Schema is a collection of databases.
On Fri, Mar 28, 2008 at 6:00 PM, Nanni Claudio
[EMAIL PROTECTED] wrote:
I know I am a little late.
From my experience with Oracle Database:
ORACLE MYSQL(equivalent)
---
DATABASE
You can use temporary table if you want short statement.
On Mon, Apr 7, 2008 at 9:24 AM, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
On Thu, Apr 3, 2008 at 3:25 AM, nataliew
[EMAIL PROTECTED] wrote:
I need querylike this that make a row of numbers (in one execute)
SELECT a from (
Learnt more from here.
On Mon, Apr 7, 2008 at 9:22 AM, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
On Wed, Apr 2, 2008 at 4:34 PM, Ben Roberts [EMAIL PROTECTED]
wrote:
Hello,
Does anybody have any info on cross-database joins?
i.e. doing a join across various tables that are
Just waiting for any reply .
On Thu, Apr 3, 2008 at 11:01 PM, Jay Pipes [EMAIL PROTECTED] wrote:
Please actually read my reply before asking the same question. As I
stated, InnoDB outputs *estimated* row counts in EXPLAIN, whereas MyISAM
outputs *accurate* row counts.
-jay
Krishna
You can read more at my blog, if you want .
On Tue, Apr 1, 2008 at 8:55 PM, Kaushal Shriyan [EMAIL PROTECTED]
wrote:
Hi
I am referring to
http://dev.mysql.com/doc/refman/5.0/en/multiple-unix-servers.html to
create multiple instances of MySQL Database Server. I wanted it for
Gentoo Linux
Nice reply.
On Fri, Apr 4, 2008 at 5:19 PM, Krishna Chandra Prajapati
[EMAIL PROTECTED] wrote:
Master--Slave1/MasterSlave2 (Chain 1
to 1)
Slave1 should have --log_slave_updates
Master-Slave1/Slave2/Slave3.
(Parallel
You should decrease your max_connections value
On Sat, Mar 29, 2008 at 11:15 AM, jfuentes [EMAIL PROTECTED] wrote:
Hi
Last days frequently I see an error message :
Can't create a new thread (errno 12) if you are not out of available
memory, you can consult the manual for a possible
I think this is the same as the other system.
On Mon, Mar 31, 2008 at 10:32 PM, Daniel Brown [EMAIL PROTECTED] wrote:
On Mon, Mar 31, 2008 at 9:39 AM, Kaushal Shriyan
[EMAIL PROTECTED] wrote:
Hi
Is there a documentation on replication of MySQL Database on Gentoo
From the manual:
learnt
On Tue, Mar 18, 2008 at 3:39 PM, Paul McCullagh
[EMAIL PROTECTED] wrote:
Yes, definitely. Previous versions of PBXT built on Windows, so there
can't be much work to get it going.
But I don't think I will get around to firing up my Windows VM until
after the conference...
On Mar
This is my test
13795620 8.0K -rw-rw 1 mysql mysql 146 Mar 21 17:58 mysql.100
13795622 8.0K -rw-rw 1 mysql mysql 146 Mar 21 17:58 mysql.101
13795623 8.0K -rw-rw 1 mysql mysql 106 Mar 21 17:58 mysql.102
On Thu, Mar 20, 2008 at 10:08 PM, Baron Schwartz [EMAIL PROTECTED]
Can't open and lock privilege tables: Table
'mysql.servers' doesn't exist
On Fri, Mar 21, 2008 at 4:23 AM, Brown, Charles [EMAIL PROTECTED] wrote:
Hey Folks.
I'm getting this error -- I need your input or help.
080320 15:02:16 [ERROR] Can't open and lock privilege tables: Table
If you skip the extend insert during mysqldump ,the process of the restore
is painful.
On Fri, Mar 21, 2008 at 5:05 AM, dr_pompeii [EMAIL PROTECTED] wrote:
Hi Rolando
thanks for the reply
it works, thanks,
new command used
mysqldump --opt --skip-extended-insert --password=XXX
The following format can be supported by mysql.
The first is the pure insert statement.
The other is csv file.
On Tue, Mar 18, 2008 at 10:00 PM, Rajesh Mehrotra [EMAIL PROTECTED]
wrote:
Have you tried the MySQL Migration Toolkit? Check
http://www.mysql.com/products/tools/migration-toolkit/
Save the sql statement to text file,then execute it inside the mysql shell.
On Feb 12, 2008 2:00 PM, Mário Gamito [EMAIL PROTECTED] wrote:
Hi,
Is it possible to send an INSERT statement from a Windows server running
MS SQL SERVER 2005 to a Linux box running MySQL ?
If so, how ? Do I need
Maybe you should view this article:
http://blog.chinaunix.net/u/29134/showart_375303.html
On Feb 12, 2008 8:32 AM, Grant Limberg [EMAIL PROTECTED] wrote:
Something like this should help you find all of the dupes
select email_address from table
group by email_address
having count(*)1;
On
Just use the type varchar.I always use it in my regular life.
On Feb 11, 2008 4:44 PM, Magne Westlie [EMAIL PROTECTED] wrote:
Jerry Schwartz wrote:
SELECT user_id, user_name FROM user_test WHERE user_id IN (SELECT
uid
FROM temp_uids);
[JS] Couldn't you replace the WHERE user_id IN
if row_count()0 then
select 'Successfully update';
else
select 'Failed update.';
endif;
On Feb 13, 2008 7:42 AM, Saravanan [EMAIL PROTECTED] wrote:
Hi List,
I am trying to write a procedure. I want to know whether the last
statement updated correctly. Then I can add the count.
anybody
No matter what happened ,just look at your error's log.Then everything
should be ok.
On Feb 3, 2008 5:57 AM, js [EMAIL PROTECTED] wrote:
High Performance MySQL ch 7 provides one of the solutions on that.
Look for check_repl.
http://dev.mysql.com/books/hpmysql-excerpts/ch07.html
On Feb 3,
I think it doesn't need to combine these two query with one.
On Jan 31, 2008 9:45 AM, [EMAIL PROTECTED] wrote:
Hi,
I'm currently using 2 queries to obtain some data and would like to know
if I can combine these two queries into one query.
I have a database with 3 tables:
1. A category
will it be file or super?
On Jan 31, 2008 10:29 PM, Olaf Stein [EMAIL PROTECTED]
wrote:
Hi All,
I would like for my regular database users to be able to turn logging off
for certain sessions. This would work by allowing them to set SQL_LOG_OFF
and SQL_LOG_BIN. This requires the user to have
This is correct.Thank you very much.
But I also why I wrote is wrong on linux and right on windows.
You can tell me answer if you have time.thanks.
On Jan 19, 2008 12:47 AM, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
On Jan 18, 2008 3:50 AM, Moon's Father [EMAIL PROTECTED] wrote:
My test
My test is as follows:
mysql select g_id from t group by g_id order by g_id desc limit 0,1;
+--+
| g_id |
+--+
|6 |
+--+
1 row in set (0.00 sec)
mysql select g_id from t group by g_id order by g_id desc limit 0,1 into
@tmp_id;
Query OK, 1 row affected (0.00 sec)
mysql select
So many tables join.OH.
Can you paste your explain results here?
On 1/17/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello everybody!
I have a huge query (something similar to a search engine), full of left
joins and my testing server takes several minutes each time to output the
Enter your mysql shell and enter the command:
set global max_allowed_packet=10M
The value of the variable can be set whatever you want .
On Jan 16, 2008 4:36 PM, MAS! [EMAIL PROTECTED] wrote:
Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto:
Post your error message here
Cursors can fetch from procedure.
On Jan 10, 2008 1:36 AM, Robert DiFalco [EMAIL PROTECTED] wrote:
A while back there was a general consensus that useCursorFetch (with
useServerPrepStmts) was somehow flakey?
Is this still the case? I had heard from someone that MySQL will not
even provide
This means you should take care of the routine replication of this section.
On Jan 13, 2008 6:04 PM, gengxy-douban [EMAIL PROTECTED] wrote:
With MySQL's classic statement-based replication, there may be issues with
replicating stored routines or triggers
from :
You should give me an error message here.
On Jan 16, 2008 4:44 PM, MAS! [EMAIL PROTECTED] wrote:
Enter your mysql shell and enter the command:
set global max_allowed_packet=10M
I have it setted at 32M, but that is not the problem; the data are
not too much ...
and it's strange because
I think it's the same.
On Jan 16, 2008 6:03 PM, Richard Heyes [EMAIL PROTECTED] wrote:
Performance wise, what is a BIGINT like in comparison to an INT on a 32
bit machine?
Thanks.
--
Richard Heyes
http://www.websupportsolutions.co.uk
Mailing list management service allowing you to
But my test result is different with you,here is my test
mysql truncate table c_t;
Query OK, 0 rows affected (0.00 sec)
mysql load data infile '/tmp/Book1.csv' into table c_t fields
terminated by ',' lines terminated by 'w';
Query OK, 1 row affected (0.00 sec)
Records: 1 Deleted: 0 Skipped: 0
Because client's submit speed also affects servers's data.
On Jan 14, 2008 6:54 PM, Sebastian Mendel [EMAIL PROTECTED] wrote:
Moon's Father schrieb:
On Jan 14, 2008 7:00 AM, Daevid Vincent [EMAIL PROTECTED] wrote:
I saw this on the PHP list and was wondering if there is any merit
You can just use function sum to get what you want.
On Jan 16, 2008 6:23 AM, Imran [EMAIL PROTECTED] wrote:
Hi:
I have a table that I need help to summarize the data. I need to be able
to
create one row of data for custno + prodno + period + weekno combination
summarized by Invtot.
Here is corrent sql sentence.
INSERT INTO sections (`order`,`edit`,`remove`,`section`,`type`) VALUES
('blah','blah','blah','blah','blah');
The best habit is to use backquotes beside every column you used.
Show you results of ps aux | grep mysql | grep -v grep
On Jan 14, 2008 11:41 PM, [EMAIL PROTECTED] wrote:
Or maybe the pid is still existing?
-Original Message-
From: Ross Crawford [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 12, 2008 5:13 PM
To: mysql@lists.mysql.com
Post your error message here.
On Jan 16, 2008 4:27 AM, MAS! [EMAIL PROTECTED] wrote:
Can anyone help me to understand why my site (php 4.4.2 / ubuntu
dapper) loose all connections to mysql server when /etc/cron/hourly
starts? (there are no process to start hourly, the directory is empty)
I
You should post your error message here at first.
On Jan 16, 2008 4:49 AM, Saravanan [EMAIL PROTECTED] wrote:
Hi,
You don't need to change the hostname to reflect the new server if you run
php from the same server. Could you post the error you get when you insert
new records.
Saravanan
To know the exact speed improvement ,you have to have a test yourself append
on your hardware mathine.
On Jan 15, 2008 11:39 PM, mos [EMAIL PROTECTED] wrote:
At 11:25 AM 1/14/2008, Jay Pipes wrote:
Are you using the PREPARE STATEMENT server-side syntax or an emulated
prepared statement like
What is method mean in your sql statement?
On Jan 15, 2008 5:33 PM, Martijn Tonies [EMAIL PROTECTED] wrote:
Hi,
I am having a problem with MySQL 5.0.45 returning what I consider to be
unexpected results.
Basically I am attempting the following query, and ALL records are being
returned.
learnt more from here.
On Jan 16, 2008 2:31 PM, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Jan 16), mos said:
I tried :
select SQL_NO_CACHE * from table where col1='abc';
which took 800ms the first time it was executed. The second time it
was executed it took 0ms. How
Of course faster than before.
On Jan 14, 2008 7:00 AM, Daevid Vincent [EMAIL PROTECTED] wrote:
I saw this on the PHP list and was wondering if there is any merit to it?!
I would be surprised if disabling networking made a difference. I'm only
concerned about the added speed. I get the
Here is my procedure statment.
DELIMITER $$
DROP PROCEDURE IF EXISTS `david_test`.`sp_test_prepare`$$
CREATE PROCEDURE `david_test`.`sp_test_prepare`(IN f_top int)
BEGIN
set @sqltext = concat('select * from test limit ',f_top);
prepare s1 from @sqltext;
execute s1;
drop prepare s1;
There is also a function named instr.You should visit the section directorly
from the document.
On Jan 7, 2008 3:38 AM, Barry Newton [EMAIL PROTECTED] wrote:
OK, never mind. I finally found the 'locate' function. I knew it had
to be there somewhere!
--
Barry
--
MySQL General Mailing
You should change your sql to related sub query.
On Jan 8, 2008 1:34 PM, Andrey Dmitriev [EMAIL PROTECTED] wrote:
All,
We are using group_concat but there seems to be some sort of display
limit.
Is there are a way to unset or increase it?
Thanks,
Andrey
--
I'm a mysql DBA in china.
You should paste the result of command show grants for
'filasPOS'@'localhost',not the message pasted here.
On Jan 8, 2008 12:04 PM, Mauricio Tellez [EMAIL PROTECTED] wrote:
Hi, I'm developing a PHP/MySQL app, and I use load data infile to feed
data to MySQL. At the develop server I haven't
learnt.
On Jan 8, 2008 2:11 PM, Werner Puschitz [EMAIL PROTECTED] wrote:
Andrey Dmitriev wrote:
All,
We are using group_concat but there seems to be some sort of display
limit.
Is there are a way to unset or increase it?
Thanks,
Andrey
You can change the maximum length by
You should paste all your error messages here.
On Jan 4, 2008 7:29 PM, Vitaliy Okulov [EMAIL PROTECTED] wrote:
You must copy all files from old location, probably /var/lib/mysql to
/data/mysqldata/.
Also open your mysql error log file read it.
2008/1/4, Krishna Chandra Prajapati [EMAIL
I've never used this feature before on my application.
On Jan 5, 2008 7:06 AM, Perrin Harkins [EMAIL PROTECTED] wrote:
On Jan 4, 2008 5:51 PM, Eben [EMAIL PROTECTED] wrote:
The resultset is paginated on the front end using the
SQL_CALC_FOUND_ROWS functionality...
Usually a bad idea:
In my opinion ,I alway use underscore as f_table in my appication.
It runs well all the time.
On Jan 5, 2008 6:22 AM, mos [EMAIL PROTECTED] wrote:
At 12:36 PM 1/4/2008, you wrote:
Thanks. It doesn't make the programming easier...it's just easier to read
the tables!
Victor
Victor,
But why I have not found this parameter in my version.
Something is like this:
mysql show variables like '%innodb_buffer%';
+-+---+
| Variable_name | Value |
+-+---+
| innodb_buffer_pool_size | 268435456 |
Just a look at this.
On Jan 4, 2008 4:36 PM, Martijn Tonies [EMAIL PROTECTED] wrote:
Dear ladies and gentlemen,
Upscene Productions is happy to announce the major
version of their test data generator tool:
Advanced Data Generator 2 (v2.2.0)
A fast test-data generator tool that comes with
The script mysql_install_db will initilize all the data in database mysql.
So the user you created losted certaintly.
On Jan 4, 2008 3:10 PM, Chris [EMAIL PROTECTED] wrote:
Krishna Chandra Prajapati wrote:
Hi all,
Mysql on debian operating system has debian-sys-maint user. What is the
101 - 200 of 206 matches
Mail list logo