Bdb tables locks are at page level, how can I determine the number of
pages of my table?
mysql show variables like '%binlog_cache_size%';
+---++
| Variable_name | Value |
+---++
| binlog_cache_size | 32768 |
|
Hi, here's my create table:
mysql show create table parametrivaloriplc;
++-+
| Table | Create Table|
++-+
| parametrivaloriplc | CREATE
Hello.
As was mentioned by other members without seeing your configuration
settings it is difficult to say about InnoDB performance. You can
indirectly monitor the OPTIMIZE speed by ROW OPERATIONS section of SHOW
INNODB STATUS. For InnoDB it maps to ALTER TABLE, which rebuilds
the table.
Maybe i got it! For the chronicle:
I resolved the problem decreasing the max_bdb_lock to the default value
and creating an index on the column used in the where clause of my
query. Probably mysql tried to lock the whole table because the primary
key wasn't in the where clause.
Cheers,
Marco
On 09 Dec 2005 10:45:04 +0800, Jeffrey G. Ubalde
I have been thinking about this for hours, and I cant quite get the
correct keyword for me to search it in the manual.
for example i have a field that contains string1:string2:string3
where colon ':' is the delimiter.
How do i create a select
On 09/12/05, Frank Rust [EMAIL PROTECTED] wrote:
Is there a possibility to select all columns from a table except one or
two columns? For example I have a table with 30 columns and want all
columns but one column *not*. Do I have to write a very long select
statement with 29 column names that
Hello.
Though I haven't read this article, but its title looks promicing:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Duncan Miller wrote:
I am looking to do a query on a self join table that returns the parent
records.
Obviously there are ways to do
Hello.
It is a bug:
http://bugs.mysql.com/bug.php?id=15223
Like temporary workaroud I use on my FC4 system
MySQL-shared-compat-4.1.13-0 rpm.
Logg, Connie A. wrote:
I am trying to install the following rpm on a red hat linux machine.=20
Frank Rust [EMAIL PROTECTED] wrote on 12/09/2005 01:59:35 AM:
Is there a possibility to select all columns from a table except one or
two columns? For example I have a table with 30 columns and want all
columns but one column *not*. Do I have to write a very long select
statement with 29
Oops, I meant to send this to the original poster _and_ the list :-)
Rhino
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: Frank Rust [EMAIL PROTECTED]
Sent: Friday, December 09, 2005 9:02 AM
Subject: Re: SELECT all except ... ?
- Original Message -
From: Frank
Hi Everyone,
I've got a little debate that maybe you can all help me settle.
I have three tables that I need to join, but there are performance problems
with the joins due to some misunderstandings of my predecessor about what's
needed to join the tables efficiently.
Here's the setup.
t1 has a
Rod Heyd [EMAIL PROTECTED] wrote on 12/09/2005 11:01:38 AM:
Hi Everyone,
I've got a little debate that maybe you can all help me settle.
I have three tables that I need to join, but there are performance
problems
with the joins due to some misunderstandings of my predecessor about
Rod Heyd wrote:
Hi Everyone,
I've got a little debate that maybe you can all help me settle.
I have three tables that I need to join, but there are performance problems
with the joins due to some misunderstandings of my predecessor about what's
needed to join the tables efficiently.
Here's
It's not possible in the query, but I wonder if there's a UDF you
could write that takes in the name of a table, and then a list of
columns NOT to show, and outputs a string of comma-separated values.
That'd be neat, so then you could write:
SELECT allBut(mytable,badfield1,badfield2,. . .) FROM
you could also have a look at
http://dev.mysql.com/tech-resources/articles/mysql-triggers.pdf which I
found useful.
-jp
All,
I am using the perl DBI to access a large table. I need to a simple
manipulation of the table
then write it to a file. If I use the simple select * from table then
process this statement
on the client side, it looks that the client first receive all the
content of the table. This
Hello Friend,
Can you please let me know how to copy data from a column in table A
to a column in table B. e.g. I want to copy value of column age from
table 2 to column age in table 1, provided the entries in column
name, which is there in both the table, should match. In MySQL v 4
it could be
At 11:17 -0800 12/9/05, Kemin Zhou wrote:
All,
I am using the perl DBI to access a large table. I need to a simple
manipulation of the table
then write it to a file. If I use the simple select * from table
then process this statement
on the client side, it looks that the client first receive
Hello,
We expect to offer native support for LDAP and PAM authentication, late next
year.
Thanks,
Jimmy Guerrero, Senior Product Manager
MySQL Inc, www.mysql.com
-Original Message-
From: Sachin Bhugra [mailto:[EMAIL PROTECTED]
Sent: Friday, December 09, 2005 1:38 PM
To:
in an application i have written there is the need to do a search from mysql
using numbers that are stored in a varchar column. it is not possible to store
only the results with numbers in a seperate column.
so i was looking at CAST(), is this a big performance loss? is there some way
of
Assuming that your text data is in the column `userinput` and you want the
integer values to be in the column `numericvalue`, this statement will
populate the `numericvalue` column all at once:
UPDATE `odd_data_table` SET `numericvalue` = `userinput` + 0;
You are better off checking for
Hello, thanks for your help!
I dont really get it :)
You suggestion is to have a seperate column with the name numericvalue and
insert userinput into that and add a zero, right?
Could you explain more, why when how will this help me :)
Quoting [EMAIL PROTECTED]:
Assuming that your text data
Tnx for the reply Jimmy. I also sent another question( i know its a
very silly question for you all..but believe me i am tryin this for
past three days and not able to get it)
Pls hlp..(just give me hint in right direction, and i will try to do
the rest)
Tnx
Sachin
--
MySQL General Mailing
I misunderstood, I thought you were looking for a way of converting your
numbers-as-strings into a native numeric format.
Please describe you situation better: What language are you using to build
your application. Are you composing the SQL statement client-side or
server-side? What kind of
I believe that some time in the future mysql will support oracle style
connect by prior syntax but it's not implemented yet.
Gleb Paharenko wrote:
Hello.
Though I haven't read this article, but its title looks promicing:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Check this out.
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
On 12/9/05, Sachin Bhugra [EMAIL PROTECTED] wrote:
Hello Friend,
Can you please let me know how to copy data from a column in table A
to a column in table B. e.g. I want to copy value of column age from
table 2 to
Hi again :)
The table contains a column named value and is in the format varchar(255).
This column contains specifications for different computer products.
There is also a id column so i know which product it belongs to.
value(varchar)
80
17
1024x768
USB
DiVX
For example, the first value 80
Is the box swapping?
Gleb Paharenko wrote:
Hello.
As was mentioned by other members without seeing your configuration
settings it is difficult to say about InnoDB performance. You can
indirectly monitor the OPTIMIZE speed by ROW OPERATIONS section of SHOW
INNODB STATUS. For InnoDB it maps to
Ladies, gentlemen,
This week, Database Workbench 2.8.0 was released.
However, that build included an error with MySQL
and loading index metadata and an specific error with
Firebird/InterBase.
There's a new installer available at our website.
Below is the original announcement...
This is kind of ugly, but with the multitable limitations of 3.23 it
probably works.
CREATE TABLE TEMP
SELECT table_1 columns except age, table_2 age
FROM table_1
INNER JOIN table_2
USING (name);
TRUNCATE table_1;
INSERT INTO table_1
SELECT *
FROM TEMP;
DROP TABLE_1;
Sorry the DROP TABLE Should be TEMP not table1
-Original Message-
From: Gordon Bruce [mailto:[EMAIL PROTECTED]
Sent: Friday, December 09, 2005 3:51 PM
To: Sachin Bhugra; mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: RE: copying data!!!
This is kind of ugly, but with the
This sounds like a simple case of bad design.
You need to be able to locate specific values for various product
descriptions but they are all mangled together into just one field. You
end up trying to do substring matches and all hell breaks loose and
performance hits the skids.
My
Test USER wrote:
Hi again :)
The table contains a column named value and is in the format varchar(255).
This column contains specifications for different computer products.
There is also a id column so i know which product it belongs to.
value(varchar)
80
17
1024x768
USB
DiVX
For example, the
Oh, is it really such a bad design? Here is some more.
What is substring matches, and why do i need them?
TBL_PRODUCTS
ID PRODUCTNAME
1 SAMSUNG TV
2 PHILIPS DVD-PLAYER
3 PHILIPS TV
4 MAXTOR DMAX
5 LaCie HARDDIVE
-
Yes the ordering is the only problem i have seen so far but i´m concerned that
the = ? might cause problems to? It seems to work but since it orders the
results wrong can i be sure that it will always do this correct for me?
In the ordering it seems like mysql thinks that 80Gb is larger than
I need to run `mysqladmin version` from a remote host, on the same LAN, what
are the min permissions for a user I need to set up to get this data?
--
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com
At 16:33 -0800 12/9/05, Scott Haneda wrote:
I need to run `mysqladmin version` from a remote host, on the same LAN, what
are the min permissions for a user I need to set up to get this data?
No permissions are necessary, you just need an account that has no privileges.
The account needs only
When using IN should i design the database to use int's or is the performance
equal?
WHERE col IN('test','test2','test3')
vs
WHERE col IN(1,2,3)
-
FREE E-MAIL IN 1 MINUTE!
- [EMAIL PROTECTED] - http://www.pc.nu
--
MySQL General Mailing List
MUCH BETTER!! Sorry I doubted you. However you have to remember that
unless you declare a second numeric column in your PRODUCT_SPECS table
then everything will be treated as strings. Sorting will be as strings,
comparisons will be as strings, and any attempt to use them as numbers
while they
39 matches
Mail list logo