On Tue, May 13, 2008 at 8:25 AM, Sebastian Mendel
[EMAIL PROTECTED] wrote:
is there a way or a function like NOW() except it returns the client time
and not the server time?
On Linux you could do something like:
mysql -e insert into tablex (..., clientside_timestamp, ...) values
(..., '$(date
what is the reason for creating main_dup. If your thinking of taking a
backup of all the changes from main table, then the trigger also will have
to wait, till the locks on the main table are released.
This trigger would add another feather to the lock/load on the machine.
regards
anandkl
On
Hi,
I have 3 tables which I want to count records from. The tables are
users, phonebooks, groups. I want to count how many phonebooks and
groups does a user have. Currently I try to use this query:
SELECT users.username, count( phonebooks.key_user ) AS pb,
count( groups.key_user ) AS gp
FROM users
Hi all,
Below is the user_delivery table structure.
CREATE TABLE `user_delivery` (
`user_id` decimal(22,0) NOT NULL default '0',
`delivery_id` decimal(22,0) NOT NULL default '0',
`send_to_regulator` char(1) default NULL,
PRIMARY KEY (`user_id`),
KEY `user_delivery_comp1`
Hi,
MyISAM is being used on production server. It applies table level locking.
From mytop view, I see that the table gets locked very frequently for 5 to
10 seconds. Reports are generated everyday. so it scans billions of data (
1years data). Changing to innodb will be doing soon and optimising
Hi,
I am looking for a solution to reduce the table locks as mytop shows that
table gets locked very frequently. During report generation.
Thanks,
Prajapati
On Tue, May 13, 2008 at 1:10 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
what is the reason for creating main_dup. If your thinking of
I assume I should check if my mysql has support for UTF-8,
I believe it just has to be 4.1 or newer. And, that's only necessary so
you can get UTF-8 aware sorting and such. You don't need any special
support to just _store_ UTF-8 data.
Ah, that's actually the critical part. I'm
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?
Thanks,
Nico
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi anand,
PRIMARY KEY (`id`),
KEY `KI_IDX_0805090456` (`words`,`id`),
KEY `CI_IDX_0805090456` (`lf_id`)
Since id is a primary key. Then why again indexing on id is being created
(`words`,`id`). It will be a duplicate index on id. words is a varchar
type. So instead of creating fulltext index
Table level locking is inherent to MyIsam.
Look into partitioning, as this breaks table into two or more other
tables which will lock separately.
Or use InnoDB:
ALTER TABLE ... SET ENGINE=InnoDB; (I think)
Ben
Krishna Chandra Prajapati wrote:
Hi,
I am looking for a solution to reduce
Hi Krishna,
how do i make my index to get more key blocks
On 5/13/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
Hi anand,
PRIMARY KEY (`id`),
KEY `KI_IDX_0805090456` (`words`,`id`),
KEY `CI_IDX_0805090456` (`lf_id`)
Since id is a primary key. Then why again indexing on id is
Thanks a lot
On Tue, May 13, 2008 at 4:30 PM, Ben Clewett [EMAIL PROTECTED] wrote:
Table level locking is inherent to MyIsam.
Look into partitioning, as this breaks table into two or more other tables
which will lock separately.
Or use InnoDB:
ALTER TABLE ... SET ENGINE=InnoDB; (I
Waynn Lue wrote:
I'm getting a weird ^A character when I
try to print it out in a textarea field.
In that case, what character set does the browser think it should be
using for the page? If you don't explicitly declare it, the browser has
to guess, and you know what happens when you rely
Hi Jerry,
Thanks for the tip.
What is UUID look for? is it an ID associated with the motherboard, CPU,
harddisk?
Thanks.
Regards,
Velen
- Original Message -
From: Jerry Schwartz [EMAIL PROTECTED]
To: 'Garris, Nicole' [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Monday, May 12,
On May 9, 2008, at 12:17 AM, Sebastian Mendel wrote:
Paul DuBois schrieb:
On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote:
Hi,
wouldn't it be very helpful if mysql connectors support some sort
of per session persistent connection?
this would save a lot of queries in many apps, for
I used not only the PHP functions but also the native MySQL HEX() function
to see exactly what was going into my database.
You can also set always_populate_raw_post_data = On in php.ini and examine
$HTTP_RAW_POST_DATA to see exactly what the web server is seeing.
Regards,
Jerry Schwartz
The
Hi all,
I want to export the values based on the condition. I export them as csv.
select * into outfile 'filename.csv' from table;
the problem is one field in table has many lines, means with \n. I couldn't
import the values into the xls sheet.
any ideas how to escape the new line
I suggest you check out http://en.wikipedia.org/wiki/UUID. It seems to have
a pretty current, but not overwhelming, explanation. Originally the starting
point for a UUID was the MAC (hardware) address of the network interface.
Theoretically, there should only be one device with any particular MAC
So far as I've been able to figure out, there's no form of escaping that
will convince Excel to do what you want.
The only thing I can think of is to replace * with a list of fields, and use
MySQL functions to replace the \n with something else.
Regards,
Jerry Schwartz
The Infoshop by Global
Try using:
select * into outfile 'filename.csv' fields enclosed by '' terminated by
',' lines terminated by '\n' from table
Regards,
Velen
- Original Message -
From: Saravanan [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Tuesday, May 13, 2008 9:26 PM
Subject: how to escape
thanks velen. But I want to escape the newlines in the fields. It is annoying
and new lines moves the values in separate line of excel sheet.
Thanks,
Saravanan
--- On Wed, 5/14/08, Velen [EMAIL PROTECTED] wrote:
From: Velen [EMAIL PROTECTED]
Subject: Re: how to escape new lines using select
Hi, can anyone explain mysql 5.0.54 handling of replication between two
servers with inconstant /etc/localtime (but the same real clock time for
UTC)
On one server I inserted a new row with created_at and updated_at as
the same time. Server localtime is GMT+1, created col is a date,
On Tue, May 13, 2008 at 2:07 PM, Ed W [EMAIL PROTECTED] wrote:
I had naively assumed that dates would always be stored in UTC in the
database and the only effect of localtime would be for display purposes?
Can anyone shed some light on what's happening here please?
TIMESTAMP values are
I'm running MySQL 5.0.22 on CentOS 5.1 (with all current patches
applied) and tried to define a table 'testcsv' using ENGINE = CSV. I
couldn't find a *.CSV file in the data directory. After looking it up in
MySQL Third Edition (by Paul DuBois) it turns out that I'm not running
the CSV engine. My
Hi,
is there a way or a function like NOW() except it returns the client time
and not the server time?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Generally, in data modelling there are some independent table, user related
tables, master tables and one main table which is related with most of the
tables. Almost in all the queries main table is involved to fetch the `id`.
In this way main table is used maximum. some times the main table
| Handler_commit| 25802690 |
| Handler_delete| 100 |
| Handler_discover | 0|
| Handler_prepare | 10370014 |
| Handler_read_first| 88920|
| Handler_read_key
If you use InnoDB you should not have a problem as it used row-level
locking and isolated transitions.
Other than that you can split your tables into smaller ones using either
partitioning or the federated engine...
Ben
Krishna Chandra Prajapati wrote:
Hi,
Generally, in data modelling
28 matches
Mail list logo
