s one.
Thank you!
Jay
PS: I'm using Version 4.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, doesn't work.
Has someone another idea?
Thank you!
Jay
> The schema of your contract should be like this:
>
> Contract (id, level, ...)
>
> where column 'id' is the primary key, isn't it?
>
> If so, you can try this:
>
> SELECT COUNT(id)
> F
1048577, etc.)
[...]
Sure, easy to understand. I was thinking in a (1,2,3,4,5) list instead
of a table
Thank you very much!
Jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello MySQL Users
Is there a way to change the separator in the following example,
e.g. from "," to "'"?
SELECT FORMAT(12332.123456, 4);
-> '12,332.1235'
is this the easiest way?
SELECT REPLACE(FORMAT(12332.123456, 4), ",", "'");
-
ther-way NULL, if it is a decision or a leaf node.
But I'm not very happy about it.
Does someone have experience to share about the table design and/or queries?
Thanks a lot!
Jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi there,
I am in the midst of creating a forums hosting site.
1. It has to be highly scalable, so I doubt a single MYSQL db with TONS
of "subforums that simulate full forums" would do.
2. Also regarding scalablity, I hope to "Add capacity" as and when its
needed. So i'll have one server runn
databases, and the DB would be HUGE, would it
not?
Lets say I host 100 forums, with 100k posts each, every write would need
to be replicated to as many slaves as I have.
Thanks!
Jay
Philip Hallstrom wrote:
Hi there,
I am in the midst of creating a forums hosting site.
1. It has to be
database install problem:
I'm having difficulty getting 3.23.3x to install on MacOS X 10.0.4.
I didn't have any problems on 10.0.0 or 10.0.2. And I've tried to
compile 3.23.37, 38, and 39. I also went through a variety of flag
combinations and tried running the make process as root, as was
sugges
ll-Text Query in HAVING clause crashes MySQL
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.36 (Official MySQL RPM)
>Environment:
System: Linux jay 2.2.16-22 #1 Mon Oct 30 20:26:30 PST 2000 i686 unknown
Arc
On my server the MySQL database decided to die on me. So I killed it and
restarted and that didn't work. So I just rebooted the machine. Now I'm
getting this error below.
Invalid SQL: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1
mysql error: Can't open file: 'privatemessage.M
[snip]
i wanna be able to sum a colum in a mysql database and display the sum
on the page field name <"Bondrem">
so if someone adds to the database the bondremaining colom would add
together and show the total on the page
record1 - ["bondrem"]=100
record2 - ["bondrem"]=450
total bondrem
[snip]
Here is a paired down version of a query I want to make. How can I get
the
"grandtotal" column? I know about the "HAVING" clause, but that's only
going
to be good for weeding out rows I don't want. I just want to do some
basic
math here.
SELECT a.*,
DATE_FORMAT(a.created_on,'%m/%d
[snip]
Here is a paired down version of a query I want to make. How can I get
the
"grandtotal" column? I know about the "HAVING" clause, but that's only
going
to be good for weeding out rows I don't want. I just want to do some
basic
math here.
[/snip]
More http://dev.mysql.com/doc/refman/5.1/en/e
[snip]
> 1. Please always reply to the List.
Who runs this list? Could it please be configured to send replies back
to
the list rather than the individual? It's really annoying to keep ending
up
with a personal address - it would make things so much easier, and is,
to my
knowledge, standard practi
[snip]
Yes this battle has been fought before. But this is still a pain in the
ass.
[/snip]
Once you get in the habit your ass will hurt a little less. I know that
there are mysql-ites who 'monitor' the list, maybe they can ease your
pain.
[snip]
How many times has someone had their problem s
[snip]
However, if the subject has been addressed and the decision made, then
there's just no point in this topic. I guess those of us that don't like
it,
or don't like people inadvertently posting personal replies thanks to
that
decision, should simply find another list.
[/snip]
Either that or le
[snip]
I accept that this was probably done for a reason, and that other lists
work
this way (though I've never seen one), so maybe I'd feel better if
someone
could actually tell me a reason why it is better this way?
[/snip]
Here is the answer;
http://www.unicom.com/pw/reply-to-harmful.html
Als
[snip]
How can I get the first and the last day of the month?
[/snip]
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
last_day() for last day of the month. The first day is always the first.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
I have no idea if this is possible or not but is there a way to run Apache,
PHP, and MySQL from a CD? I'd like it to be possible to run it on Windows,
Mac OSX and *nix. If it is possible could someone point me in the right
direction?
Thanks!
--
MySQL General Mailing List
For list archives: htt
[snip]
I have no idea if this is possible or not but is there a way to run
Apache,
PHP, and MySQL from a CD? I'd like it to be possible to run it on
Windows,
Mac OSX and *nix. If it is possible could someone point me in the right
direction?
[/snip]
You'd have to have CD's for each OS on which yo
[snip]
I have no idea if this is possible or not but is there a way to run
Apache,
PHP, and MySQL from a CD? I'd like it to be possible to run it on
Windows,
Mac OSX and *nix. If it is possible could someone point me in the right
direction?
[/snip]
Yippee, cross-posting!
http://www.google.com/s
[snip]
I have measurements of rooms stored in a table for each house in feet
and
inches, does anyone know how can I work out the square footage?
[/snip]
Convert to inches, multiply length * width, divide by 144 (one square
foot)
--
MySQL General Mailing List
For list archives: http://lists.mysql
[snip]
I read this as a SQL syntax question, not a math word problem. As in
SELECT ..., (some expression equaling sq ft) AS sqft...
[/snip]
Cool, then do it!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[snip]
I need to start a prog. as soon as a particular field in the mySQL 4.x
is
changed. ie. when in Flag table if_flag is set to '1' i need to start a
script.
The script will be in PHP.
Pl. tell me how to do so on mySQL 4.x.
[/snip]
Triggers are not available in 4.x, you will need 5.x
--
MySQL
[snip]
UPDATE command is not working for only the record that I want, but
for
all in the table. I sees WHERE is not interpretated by Mysql server. At
least the result is identic to it. For example, If my php execute
UPDATE clientes SET tipo='r', nome_fantasia='cc',
estado='24'
WHER
[snip]
can someone please just send me or post a example of editing feilds of a
mysql database within an html form and then updating the values thanks
alot
here is a small database u can use i can expand on your example as
needed
[/snip]
PHP question;
When you click on the form submission but
[snip]
Maybe it a bug of the php's mysql API?
[/snip]
Nope, I do this all of the time. Head on over to the PHP list and post
your code and see what they say.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE
[snip]
The php and db structure and data are attacheds. Two infos: 1) Im
not a
expert 2) The code is in the beggining of the development, so are too
many
uglyness yet =)
[/snip]
Find a place online to post your code or paste it into the message (only
the relevant parts). Usually no one will
[snip]
Find a place online to post your code or paste it into the message (only
the relevant parts). Usually no one will open an attachment on a mailing
list.
[/snip]
Post the line of PHP where this query exists.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
[snip]
I procured myself some zip/lat/long databases from various places. Then
I
noticed that for the same zip code, I got different values in different
databases??!!!
[/snip]
Latitudes and longitudes are often represented based on their location
relative to the equator and the prime meridian;
[snip]
Thanks for the graph.
So are you saying that I should use the database that has the negative
values,
and not the one that uses positive values?
I'm in the USA. I don't care about anywhere else (for my location needs
that
is).
[/snip]
Yes, that would be using the proper notation for lat
[snip]
Why have customer info in both? Delivery and Billing info makes sense,
but why the redundant info in both? Anyone got views on this? Do/would
you do it differently, and could you tell us why? Cheers.
[/snip]
It is bad database design IMHO.
--
MySQL General Mailing List
For list archives
[snip]
> Well, one reason could be, for example, that the address changes
> over time and they want to know what address the customer was
> when the order was processed.
[/snip]
So you would delete an old customer address in favor of a new one? I
would rather have an 'active/inactive' column with
LOWER( ) to any
value
passed to this column or if a record had to be manually input and the
admin
forgot to make sure all the characters were lowercase.
Ferindo
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email:
(can't check the exact interval
now -
weekend has begun here).
--
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED]mob: +1 614 406 1267
Are You MySQL Certified? http://www.mysq
y_id = cu.company_id
WHERE p.company_id IS NULL
AMD cu.company_id IS NULL;
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED]mob: +1 614 406 1267
Are You MySQL Certified? http://www.mysql.com/certificati
T * FROM t3;
++
| id |
++
| 3 |
| 5 |
| 7 |
| 9 |
| 11 |
+----+
5 rows in set (0.00 sec)
Hope this answers your questions!
Cheers,
-jay
Jay Pipes <[EMAIL PROTECTED]> wrote:
Yesmin Patwary wrote:
Dear All,
Need to find ids that are NOT in other two tables. With the help of
Hi Eko!
It shouldn't be an issue with table size. More likely, it is due to
duplicate records in the import file. Can you post the SHOW CREATE
TABLE for your table in full (including primary key information)? Also,
any output from your import run would be useful.
Thanks!
--
Jay
Please post your exact table schema using SHOW CREATE TABLE, and your
exact query, along with an EXPLAIN SELECT for the query.
Thanks!
-jay
Jan Gomes wrote:
Hy Guys,
I have a simple structure of tables, howewer has 50 million of registers and
2,5 GB of data.
The table is MyIsam and has 4
on the table, do do it "off hours".
Then, issue the query again and post back time results.
Also, post the output of SELECT @@version;
Cheers
Jay
PS.: Pardon me for some thing, my english is not very good
It's just fine!
Hy Jay,
Thanks for you attention.
Show you m
any requests/sec are you averaging, and also, what is the
percentage reads to writes in your database? You can get both answers
from SHOW STATUS variables.
Cheers,
Jay
-Original Message-
From: Dan Trainor [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 1:41 AM
To: Moritz Möl
awodny) as well as ApacheBench (ab), supersmack (really
customizable), and have used httperf in the past.
For general MySQL benchmarking, you can always run the MySQL benchmark
suite (included in source distributions) on one machine and on the
other, and see differences that way.
Cheers,
--
? Can you post the code you are using so we might suggest
an alternative solution?
Cheers,
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED]mob: +1 614 406 1267
Are You MySQL Certified? http://www
none of its "many" transaction records
has the merchant bankA.
Wouldn't something like this suit your needs?
SELECT a.account_id
FROM accounts a
LEFT JOIN transactions t
ON a.account_id = t.account_id
AND t.next_charge_date <= NOW()
AND t.merchant != 'bankA'
GROUP BY a
ave used the COALESCE function in the outer SELECT in order to
eliminate any possible NULL values from the results and replace those
with a correct value.
Hope this helps,
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [E
[snip]
I need to store something like a couple of million rows is a
MySql
table. Is that ok or do I have to split them up. I intend to index each
of
the columns that I will need to access so as to speed up access.
Insertion
will be done only when there is very little or no load on the server
[snip]
It seems that the reason is that "DEC" is a keyword standing for
"decimal". I do not understand why this cannot be allowed for a column
name.
[/snip]
There are several reserved keywords in MySQL, none of which are
recommended for column names. You can try the SQL statement using
backtick
I'm currently setting up MySQL 4.1.2 on RHEL 4.1 and I have found the
/etc/my.cnf file. I'm trying to find out if I change the "basedir" from:
Basedir=/var/lib
To
Basedir=/other/path
Will that move the actual data files that have all my databases? Do I need
to move any of the things that are
[snip]
what type of password algorithum does mysql 5.x uses for encrypting
passwords? and how does these algorithum keeps the password in secure.
[/snip]
Here is some helpful info;
http://www.mysql.com/search/?q=password+security&charset=
--
MySQL General Mailing List
For list archives: http://
[snip]
I'm currently looking for a tool that will take XML and produce a
database
from it. Not really looking for anything in particular at this point,
just
sort of scoping around. Anyone know of such a tool?
[/snip]
MySQL kinda' has a built-in tool
http://dev.mysql.com/tech-resources/arti
[snip]
Now, when I try to update the rotX, rotY, and rotZ fields, I have to put
a double into it, ints don't work. But then, when I print out the
database, it looks like this:
Which clearly indicates that it is storing the rot fields as ints.
I am just wondering why I can't give it an
[snip]
Right...the thing is that they are supposed to be INTs, but I can only
successfully perform an update query if I use doubles for the fields...?
[/snip]
Do a describe on the table and make sure that they are INTs, then show
us the update statement.
"because it is hard to read"
"why?"
[snip]
Here is what it gave me when I did describe:
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| id| int(10) unsigned | NO | PRI
[snip]
It seems to work with INTs when I do it from the MySQL commandline. I
guess something is weird with the JDBC connector or something...
[/snip]
May I suggest echoing your query out so that you can see what it is
trying to insert?
--
MySQL General Mailing List
For list archives: http://list
[EMAIL PROTECTED] wrote:
Any idea why libmysqlclient_r.so is not being created when I compile after a
configure --without-server?
Compile MySQL with --enable-thread-safe-client configure option.
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based
select psDealerID,
sum(if(substring(updated, 1, 10) = curdate(), 1, 0)),
sum(if(substring(updated, 1, 10) = date_sub(curdate(), interval 1 day),
1, 0))
from provision
group by psDealerID
I love crosstab queries, but one thing really eats at me. I'd like to be
able to add significance to the AS
[snip]
>We all know that you cannot do something like this;
>sum(if(substring(updated, 1, 10) = curdate(), 1, 0)) AS curdate()
>nor can you use user variables even though they get set properly
>set @d1 = curdate();
>sum(if(substring(updated, 1, 10) = curdate(), 1, 0)) AS @d1
>So, does anyone know o
[snip]
SET @sql=CONCAT('SELECT SUM(IF(SUBSTRING(updated,1,10)=CURDATE(), 1, 0)) AS ',
char(39),
CURDATE(),
CHAR(39),
' FROM tablename GROUP BY group by psDealer' );
PREPARE stmt FROM @sql;
[/snip]
Very clever Peter! Thanks for your he
[snip]
This may be a really stupid question, but I hate looking stupid if I can
avoid it. :-)
I have been using Microsoft SQL Server for a while, and I'm now trying
to
switch all our applications over to use MySQL. Microsoft SQL Server is
pronounced "Sequel Server". Is MySQL pronounced "My Se
[snip]
"The official way to pronounce "MySQL" is "My Ess Que Ell" (not "my
sequel"), but we don't mind if you pronounce it as "my sequel" or in
some
other localized way."
[/snip]
[localized way]
The best darned database since the dawn of computing.
[/localized way]
--
MySQL General Mailing List
F
dish, the
pronunciation of My sounds more like "Me"...
:)
p.s. That is also where "Max-DB" comes from. Max is the name of
Monty's son, not an implication that Max-DB is "better" than MySQL.
--
Jay Pipes
Community Relations Manager, North America, MySQ
[snip]
I am facing some problems to identify the advantages or disadvantages of the
use of INDEXes (a.k.a. VIEWS in other DBMS environments, please correct me
if am wrong), this is the scenario:
[/snip]
index != view AFAIK
An index on a column or columns is a method for the database to keep track
greatly appreciated.
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED]mob: +1 614 406 1267
Are You MySQL Certified? http://www.mysql.com/certification
Got Cluster? http://www.mysql.com/cluster
sao`)) ORDER BY emissao ASC
SELECT * FROM `sav00_sava0400_dbf`
emissao BETWEEN '2000-01-01' AND '2000-12-31'
UNION ALL
SELECT * FROM `sav00_sava0400_dbf`
emissao BETWEEN '1999-12-01' AND '1999-12-31'
--
Jay Pipes
Community Relations Manager, North America,
something is problematic with permissions. It
probably is the PID directory, IMO. Make sure you know where MySQL is
trying to create the pid file...
Let us know how things work out.
Cheers!
Den 6/21/2006, skrev "Jay Pipes" <[EMAIL PROTECTED]>:
Probably a permissions iss
[snip]
It appears that mysys 4.1 does not know how to multiply a dollar
amount to another number. Has anyone else seen this problem?
[/snip]
Your price column contains a dollar sign, making it a text field that
you cannot multiply with.
--
MySQL General Mailing List
For list archives: http:/
apterType
) AS advisor_counts
INNER JOIN State ST
ON primary_grouping.State = ST.State
ORDER BY
State
, Sub
, ChapterType;
This should reduce the number of queries actually executed to 3 instead
of > 700 million
Let us know the output of EXPLAIN and the speed difference.
Cheers,
--
Jay P
ouping.State = advisor_counts.State
AND primary_grouping.Sub = advisor_counts.Sub
AND primary_grouping.ChapterType = advisor_counts.ChapterType;
- Original Message - From: "Jay Pipes" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>
Cc: "mysql"
amme und Entwuerfe');
You can read more about LAST_INSERT_ID() here:
http://dev.mysql.com/doc/refman/5.0/en/information-functions.html
Cheers!
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED]
[snip]
Say I have two regular tables (table1, table2) and what a column
(status) in
the second table to update when it changes in table1. For example, if I
set
the status for a user in table1 to "0", the status for all that user's
records in table2 dynamically changes to "0".
Can this be done? Wh
[snip]
I´ve got a page where a ought to get 20 registers in ramdom order but i want
to display it in an alphabetical order.
Someone knows if there is a way to get that 20 random registers in
alphabetical order?
[/snip]
SORT BY `registers`
--
MySQL General Mailing List
For list archives: http:/
[snip]
Excuse me, but i don´t understand your answer.
Could you explain it?
[/snip]
Add it to the end of your query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[snip]
If I have a file that is in a spreadsheet format, how can I dump that
into a MySQL database, using PHP MyAdmin?
[/snip]
Using a LOAD DATA INFILE query.
http://www.google.com/search?hl=en&lr=&q=csv+to+mysql+phpmyadmin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
[snip]
i have a question, i want to do something like this
select 10 as a, 1 as b, (a+b) as c;
im want to get something like this
a | b | c
-
10 | 1 | 11
how can i do this... i want to do that becouse i get a big value from
a sub big subquery, so i don't want to make again the su
[snip]
Was wondering if I could get a conversation started on the pros/cons of
database storage verse filesystem
[/snip]
There is additional overhead in saving and retrieving images from a
database typically. Most folks benchmark to see which is faster and more
efficient on their systems. YMMV.
B
is; in fact, it makes more sense
that the reverse would be true, as MySQL would not have to do an
implicit DISTINCT on the outermost resultset.
Prashant:
Please post an EXPLAIN of your original posted SQL query. Use the /G
flag from the command line client to make it easier to read the results
columns for
specific entity attributes, and are pretty much storing everything in
one gigantic table. Any particular reason for this? For instance, why
not have a column called "color", instead of overcomplicating things?
-jay
--
MySQL General Mailing List
For list archives: http:/
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco wrote:
> The question is, how do I query this? Say I want all records from table
> T whose COLOR property value is ORANGE.
>
> The only thing I can come up with (and I'm no SQL expert and this looks
> wrong to me) is the following:
>
> SELECT *
>
ery
difficult to pick out SQL keywords, and MAKES IT SEEM LIKE YOU ARE
SHOUTING.
-jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Fri, 2006-08-04 at 17:14 -0700, Tanner Postert wrote:
> select text from table where user = 2 and id < 3 order by id ASC limit 1;
> select text from table where user = 2 and id > 3 order by id ASC limit 1;
>
> is it possible to do this using 1 query?
select text from table
where user = 2 and
ur name on the
participants page, and anything else.
Not familiar with barcamps? Check out http://barcamp.org to find out
about the concept!
Cheers!
Jay Pipes
Community Relations Manager, North America, MySQL, Inc.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list arch
It is likely you are also logging any queries not using an index (doing
full table scans). Check the configuration variable: log_long_format
Cheers,
Jay
On Tue, 2006-08-15 at 14:45 +0200, Dominik Klein wrote:
> I have specified
>
> log-slow-queries
> long-query-time=10
>
[snip]
Can anyone tell me how to add up values in different tables? For example
Table1.Column1 + Table2.Column2 + Table1.Column3 Where id(row) = n
[/snip]
SELECT t1.c1 + t2.c2 + t3.c3 FROM table WHERE id = n
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
[snip]
Can anyone tell me how to add up values in different tables? For example
Table1.Column1 + Table2.Column2 + Table1.Column3 Where id(row) =3D n
[/snip]
SELECT t1.c1 + t2.c2 + t3.c3 FROM table WHERE id =3D n
The above doesn't work I'm afraid.
[/snip]
Don't be afraid, you must join the tables
[snip]
[snip]
Can anyone tell me how to add up values in different tables? For example
Table1.Column1 + Table2.Column2 + Table1.Column3 Where id(row) =3D n
[/snip]
SELECT t1.c1 + t2.c2 + t3.c3 FROM table WHERE id =3D n
The above doesn't work I'm afraid.
[/snip]
Don't be afraid, you must join th
[snip]
we are working on a small project which needs to calculate the closest
distances from an address and/or zipcode entered into a search box. It
will read from a MySQL database of companies, which store their address
and zipcodes.
looking for the best way to approach this. I've seen some zipco
yway:
SELECT COUNT(field2):[EMAIL PROTECTED] FROM table2 WHERE id = 10;
SELECT table1.*, @counter as total
FROM table1
LIMIT 1;
Note that I took out the GROUP BY clause, which is pointless given the
query's structure of returning the first id column.
Jay
--
MySQL General Mailing List
For lis
[snip]
+---+--+---+-+--
+-+
| code | bin | min | ain |
cin | dur |
+---+--+---+-+--
+-+
|
to take a look at
your schema and a sample of your SQL queries from the application? That
would help immensely. 70ms for an UPDATE seems very slow... and 200ms
is very slow.
Cheers,
--
Jay Pipes
Community Relations Manager, North America, MySQL, Inc.
[EMAIL PROTECTED] :: +1 614 406 1267
--
Could you post an example of a query you are expecting to be cached?
On Wed, 2006-08-30 at 11:43 -0500, Mazur Worden, Kathy wrote:
> Hi,
>
>
>
> I just turned on the query cache by modifying its size and limit and
> restarting the server. However queries aren't being stored to it:
>
>
>
>
;INSERT INTO ITEMS (USER_KEY, SUBKEY, VERSION_STAMP_HASH, VERSION_STAMP,
> USER_DATA, LAST_ACCESS_TIME, TYPE, DATA_HASH, HINTED_STORAGE_ID,
> USER_KEY_HASH) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
>
> "DELETE FROM ITEMS WHERE USER_KEY = ? AND SUBKEY = ? AND VERSION_STAMP_HAS
gt; AgencyInfo.agencyid, BuildingInfo.buildingid FROM BuildingInfo INNER
> JOIN AgencyInfo ON BuildingInfo.agencyid = AgencyInfo.agencyid ORDER BY
> AgencyInfo.Name, BuildingInfo.Name;
>
> There are indexes on the id and name related fields used in the WHERE
> clauses.
>
> Kathy Mazur W
the keys, do the import, then re-enable the keys, it takes
> just as long,
> if not longer.
>
>
> I have just about given up on finding a solution for this and just
> rotate my tables out
> regularly once the imports take over 5 minutes to process roughly 10,000
> records
call_dest_crname| char(50)
> | YES | | NULL| |
> | call_dest_custid| char(20)
> | YES | | NULL| |
> | call_zone_data | char(20)
> | YES | | NULL| |
> | calling_party_on_dest_num_type | int(1)
> | YES | | 0 | |
> | calling_party_from_src_num_type | int(1)
>
orden
> Prairie Area Library System
>
> -Original Message-
> From: Jay Pipes [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 30, 2006 12:42 PM
> To: Mazur Worden, Kathy
> Cc: mysql@lists.mysql.com
> Subject: RE: query cache question
>
> Those queries loo
it into a temporary table,
then normalizing it and INSERT ... SELECT * FROM temp_table to batch the
insert as one move into the main table...
Jay
On Wed, 2006-08-30 at 15:11 -0400, George Law wrote:
> Jay,
>
> Here you go - at least according to mysqldump
>
>
> CREATE TABL
Use MySQL Workbench:
http://dev.mysql.com/downloads/guitools/
On Wed, 2006-08-30 at 15:11 -0400, Jerry Schwartz wrote:
> Automatically? Don't know. I did it by hand using Dia, a free alternative to
> MS Visio. It was tedious.
>
> Regards,
>
> Jerry Schwartz
> Global Information Incorporated
> 1
e_name Value
> Qcache_free_blocks1
> Qcache_free_memory10477008
> Qcache_hits 0
> Qcache_inserts0
> Qcache_lowmem_prunes 0
> Qcache_not_cached 20318
> Qcache_queries_in_cache 0
> Qcache_total_blocks 1
>
> Thanks
>
> -Original Message-
>
itwise operations in your application code.
For instance, in PHP you would write something like:
Some more notes:
* Use a 64-bit BIGINT datatype if you need 33-64 flags for permissions
* You can use a SET datatype as well in this manner
* Make sure you understand bitwise operations
Cheers,
Jay
A couple questions since I'm not a Solaris person I really don't know how to
do the following and was hoping that someone could help me out (Google isn't
much help on this).
How does one start the MySQL daemon on Solaris 8? (it's running MySQL
3.23.49)
How does one tell Solaris 8 to start the MyS
1 - 100 of 751 matches
Mail list logo
