Chris Kantarjiev wrote:
I'm looking at the stats on one of our servers and trying to understand
why Handler_read_rnd_next is so high. It's 256.5M right now, which is
about 10x the total number of reported queries.
The machine is being used, almost entirely, for queries of the form:
select * f
Gregory Machin wrote:
I tried the following
UPDATE temp SET 'file_content' = REPLACE(file_content, '' ,
'');
but it didn't work, i think thing problem is that the string i need to
replace / null has quotation marks .. how can i work around this
You need to escape the quotation marks. A
Siegfried Heintze wrote:
>Some dialects of SQL have SELECT [FIRST|TOP 1000] clause for their SELECT
>syntax. I looked at the syntax for mysql and it does not appear to have this
>feature.
>Apparently, however, this is possible because the MySQL Control Center does
>this. How does it do it?
See
Some dialects of SQL have SELECT [FIRST|TOP 1000] clause for their SELECT
syntax. I looked at the syntax for mysql and it does not appear to have this
feature.
Apparently, however, this is possible because the MySQL Control Center does
this. How does it do it?
Thanks,
Siegfried
--
MySQL Genera
> I am fairly sure that there aren't any queries being run, but while in
> the background, my mysqld process chews up exactly 50% of my cpu. It
> runs queries nicely and has excellent response times for most any
> query I throw at it, but its causing issues for other apps.
Try using mytop to see i
On Jul 25, 2005, at 3:47 PM, Chris Kantarjiev wrote:
link_id is indexed. There are about 8 million rows in the table,
and most of them have link_id = null right now. latitude and longitude
are not indexed - but my understanding is that mySQL will only
use one index, and link_id is the interest
Since most of the rows have link_id = NULL, using that as the first
condition in the WHERE clause does not help MySQL reduce the number of
rows it needs to check (therefor MySQL prefers to do a full table scan).
My suggestion is create a composite index on (latitude, longitude,
link_id) and cha
Shawn (and anyone else who will listen):
I'm already running out of RAM (actually, virtual memory/page file space)
just trying to display all the job titles without even joining them with
anything. I have to use a LIKE clause to just get a portion of them.
So, I could:
(1) Have multipl
I'm looking at the stats on one of our servers and trying to understand
why Handler_read_rnd_next is so high. It's 256.5M right now, which is
about 10x the total number of reported queries.
The machine is being used, almost entirely, for queries of the form:
select * from crumb
where link_id i
Hello
CA> The query takes ages to run (has been running for over 10 hours
CA> now). Is this normal?
I think, your indexes are too complicated. MySQL have to rebuild it
usually after ALTER TABLE.
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
h
Hello All,
I am fairly sure that there aren't any queries being run, but while in
the background, my mysqld process chews up exactly 50% of my cpu. It
runs queries nicely and has excellent response times for most any
query I throw at it, but its causing issues for other apps.
What can I do to fin
On Jul 25, 2005, at 1:23 PM, Sujay Koduri wrote:
I guess anywhere we have 3 levels of hierarchies for a phone number.
(Country code, Area code and the actual number).
The advantage of seperating them into different columns(Either an
integer or
a string) is that he can group different phone nu
That may be true, but I don't think the augments provided by Joerg necessitate
a single column or multiple columns. His points, leading zeros, sorting, etc go
more to the native data type that should be used and are valid in either case.
Bob
-Original Message-
From: Sujay Koduri [mailto
I guess anywhere we have 3 levels of hierarchies for a phone number.
(Country code, Area code and the actual number).
The advantage of seperating them into different columns(Either an integer or
a string) is that he can group different phone numbers based on area code or
country code.
sujay
--
On Monday 25 July 2005 01:56pm, Michael Stassen wrote:
> Gregory Machin wrote:
> > Hi.
> >
> > Please could you advise me...
> > I have php pages that are stored in a mysql database, that will later
> > be imported into a cms
> > I want to use mysql's regex funtion to remove unwanted php code and
>
Hi!
Sujay Koduri wrote (re-ordered):
-Original Message-
From: Asad Habib [mailto:[EMAIL PROTECTED]
Sent: Monday, July 25, 2005 11:53 PM
To: mysql@lists.mysql.com
Subject: Phone Number Storage
Is it better to store phone numbers as strings or as integers? Offcourse,
storing them as int
Gregory Machin wrote:
Hi.
Please could you advise me...
I have php pages that are stored in a mysql database, that will later
be imported into a cms
I want to use mysql's regex funtion to remove unwanted php code and
update links to images
and urls.
But i cant seem to get my brian around the r
Hi.
Please could you advise me...
I have php pages that are stored in a mysql database, that will later
be imported into a cms
I want to use mysql's regex funtion to remove unwanted php code and
update links to images
and urls.
But i cant seem to get my brian around the regex part ...
i want to
I think it is better to store the phone numbers as strings only. As phone
numbers may also include '-', if you allow entering international numbers,
it is good to store them as strings only.
Or you can ask the area code and the actual number seperately and store them
seperately in two columns as
>From 'perldoc perldata':
Variable substitution inside strings is limited to scalar
variables, arrays, and array or hash slices. (In other
words, names beginning with $ or @, followed by an optional
bracketed expression as a subscript.)
You can check this from the command line:
% perl
Is it better to store phone numbers as strings or as integers? Offcourse,
storing them as integers saves space but this requires extra processing of
the user's input (i.e. CPU time). Are there any other
advantages/disadvantages of doing it one way or the other?
- Asad
--
MySQL General Mailing Li
Not knowing what the ALTER TABLE is changing, I can't really say. Could
you send the table structure (as it was before the ALTER TABLE)?
Remember that MySQL is actually changing the data for every row, and
potentially rebuilding indexes as well, so it has a lot of work to do
from that single st
Hi,
Thanks for the reply.
The setup is the following:
Dual Processor SuSE 9.0 (kernel 2.4.21 SMP), apache 2.0.54, php 5.0.4,
mysql-4.1.12 (RPM), 2GB RAM, 80GB scsi RAID 5
The database config file is this one:
[mysqld]
port= 3306
socket = /var/li
Catalin,
I was able to create the table with the CREATE statement you pasted, and
insert a row with some simple data.
mysql> insert into raw_outgoing_sms
(id_gsm_operator,id_shortcode,msisdn,sender,text,dlr_url) values
(10,20,'19284720','deva','hello world','yahoo.com');
Query OK, 1 row aff
news <[EMAIL PROTECTED]> wrote on 07/25/2005 10:41:46 AM:
> Hi,
>
>
> I have the following table :
>
> CREATE TABLE `raw_outgoing_sms` (
>`id` bigint(20) NOT NULL auto_increment,
>`id_gsm_operator` bigint(20) NOT NULL default '0',
>`id_shortcode` bigint(20) NOT NULL defa
On Saturday 23 July 2005 09:05am, Gregory Machin wrote:
> Hi all.
> I'm writing a php script to store the contents of html and php pages
> in a data base, it works well until there are mysql queries in the
> pages source then give errors such as this one.
>
> Query failed: You have an error in your
On Jul 25, 2005, at 5:33 AM, Marvin Wright wrote:
Hi,
Thanks for your reply.
I've only just moved all tables to there own table space so that I
can put
certain databases on different disks.
Right now my shared tablespace does not hold any databases.
I'm aware that I still need the shared t
"Siegfried Heintze" <[EMAIL PROTECTED]> wrote on 07/24/2005 11:35:36
AM:
> I have a large number of job titles (40K). Each job title has multiple
> keywords making a one-to-many parent-child relationship.
>
> If I join job title with company name, address, company url, company
city,
> job name,
Hi,
I have the following table :
CREATE TABLE `raw_outgoing_sms` (
`id` bigint(20) NOT NULL auto_increment,
`id_gsm_operator` bigint(20) NOT NULL default '0',
`id_shortcode` bigint(20) NOT NULL default '0',
`msisdn` varchar(20) NOT NULL default '',
`sender` varcha
Hello
JT> Did you try that link? When I follow it, I get a search results page
JT> saying <>. Too
JT> bad it doesn't actually show the search results
Sorry. Try this links
http://solutions.mysql.com/search.php?pc=4%2C86&q=backup&level=0
http://solutions.mysql.com/software/?c=backup
Since
"Darryl Hoar" <[EMAIL PROTECTED]> wrote on 07/21/2005 04:12:39 PM:
> Greetings,
> I am currently using Mysql 3.23.52. I am looking for events (when a
record
> is added, mod'd or deleted
> from a table, and event is sent to each client connected to the DB.
> Firebird can do this,
> but before I
Jacek Becla <[EMAIL PROTECTED]> wrote on 07/21/2005 02:47:20 PM:
> Hi,
>
> Is there a way to insert binary data representing numbers
> directly into (preferably MyISAM) table. We are trying to
> avoid conversion from ASCII to float/double/int...
>
> Thanks,
> Jacek
>
> --
> MySQL General Maili
"Ryan Stille" <[EMAIL PROTECTED]> wrote on 07/21/2005 05:47:28 PM:
> I'm trying to get a handle on MySQL backups and hot backups using MyISAM
> and InnoDB tables together. We plan to switch from SQL Server to MySQL
> soon.
>
> How are you guys handling full-backups of databases with mixed MyISAM
Scott Hamm <[EMAIL PROTECTED]> wrote on 07/21/2005 09:39:48 AM:
> I'm now trying to learn engines in MySQL. When I migrated from M$ SQL to
> MySQL to learn the migration process and executed the following:
>
> SELECT
> *
> FROM
> QA
> LEFT JOIN
> Batch
> ON
> Batch.QAID=QA.ID
> LEFT JOIN
Sebastian wrote:
the example i just showed you doesn't need to use delimited syntax. it
will load the entire contents of the file into the column you specify..
try it a test:
CREATE TABLE `table_test` (
`content` mediumtext NOT NULL
) ENGINE=MyISAM;
Mediumtext can be too much, depending on
When you use double quotes for strings in Perl, Perl looks through your
strings for variables like $foo, and replaces them with the current value of
$foo. This is called interpolation. When you use single quotes, it
considers your string a literal.
So when you use double quotes, you need to
Hi all,
we are trying to run the following query on a table that contains over 600
million rows:
'ALTER TABLE `typed_strengths` CHANGE `entity1_id` `entity1_id` int(10)
UNSIGNED DEFAULT NULL FIRST'
The query takes ages to run (has been running for over 10 hours now). Is this
normal?
As a sid
Hi,
Thanks for your reply.
I've only just moved all tables to there own table space so that I can put
certain databases on different disks.
Right now my shared tablespace does not hold any databases.
I'm aware that I still need the shared table space but I don't need 200gb
now, I just want to dec
On Jul 25, 2005, at 5:47 AM, Marvin Wright wrote:
You recommend to dump tables before changing then re-import them
back. But
if all databases are in there own tablespace I should need to do
this dump
should I ?
Unfortunately I think that's your only option to create a new table
space.
Christian Wollmann wrote:
By the way: Perhaps you could tell me how I can determine/change the encoding
of the database?
SHOW CREATE DATABASE db_name;
ALTER DATABASE db_name
[[DEFAULT] CHARACTER SET charset_name]
[[DEFAULT] COLLATE collation_name];
http://dev.mysql.com/doc/mysql/en/c
You could try:
SELECT memberid, lastname
FROM tblmembers
ORDER BY lastname COLLATE latin1_german2_ci ASC
It worked in my database. But I dont know, if my database is utf8.
By the way: Perhaps you could tell me how I can determine/change the encoding
of the database?
Kind regards
Christian
Gregory Machin wrote:
Hi all.
I'm writing a php script to store the contents of html and php pages
in a data base, it works well until there are mysql queries in the
pages source then give errors such as this one.
Query failed: You have an error in your SQL syntax near 'temp'
how do stop mysq
Nico Grubert <[EMAIL PROTECTED]> wrote on 22/07/2005 09:06:25:
>
> Hi there,
>
> I have a MySQL 4.1 DB running including a database whose character set
> is set to utf8.
> In the database I have a table "tblmembers" with some records containing
> german umlauts.
> How do I sort results with germ
Hi,
Can anybody help with this ?
Regards,
Marvin
-Original Message-
From: Marvin Wright
Sent: 22 July 2005 10:46
To: Heikki Tuuri; mysql@lists.mysql.com
Subject: RE: Correct way to use innodb_file_per_table?
Hi Heikki,
I've followed your instructions here and its all worked fine.
N
Hi
Please could you advise. I inserted some web pages into a table and
now i need to do updates to the pages so that the cms can display them
with out the legacy code. there are about 1000 pages.
I tried the following
UPDATE temp SET 'file_content' = REPLACE(file_content, '' ,
'');
but it di
Hi there,
I have a MySQL 4.1 DB running including a database whose character set
is set to utf8.
In the database I have a table "tblmembers" with some records containing
german umlauts.
How do I sort results with german umlauts if the database character set
is set to utf8?
Using the SQL query
S
46 matches
Mail list logo
