Hi all,
I'm trying to wrap my brain around folowing problem.
table main(code, field_1, field_2, field_3, , , field_51)
111, 'X', '', 'X',,,
222, '', '', 'X',,,
333, '', 'X', '' ,,,
444, '', '', '' ,,,
555, 'X','X', '' ,,,
table map(id, field)
1, 'field_1'
5, 'field_2'
9, 'field_3'
Hi Ann,
Currently, the thoughts on how to make the BLOB references secure go
like this:
The BLOB reference consists of 2 components: The first component is
basically an index used to find the BLOB on the server. The second
component is a random number generated when the BLOB is created.
I would agree with the other person who posted about the MySQL 5.0 cert guide.
It is quite thorough. I would also recommend "Pro MySQL" which is more in-depth
on some things like replication.
If you are going to be going into clusters..there is only book that
specifically covers it. "MySQL Clu
What I've done in situations like this is write SQL that generates the SQL I
need. I then pipe out to a file and pipe it back in, or just pipe from one
instance of mysql to another.
Example SQL:
SELECT
CONCAT('UPDATE main SET ', field, ' = ', id, ';')
AS update_sql
FROM map
Example command to
If I understand your problem correctly (and correct me if I am wrong),
you have one table that has information about what other tables to
search in??
If that is the case, then you can still use the same technique of
PREPARED STATEMENTS:
Search the first table and retrieve the name of the other ta
This seems to be a frequent occurrence:
[EMAIL PROTECTED] dblog]# mysqlbinlog mysql.25
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
ERROR: Error in Log_event::read_log_event(): 'Found invalid event in
binary log', data_len: 94, event_type: 15
Could not read entry at offset 4:Error
I have a table in my database (currently) that grows to be huge (and I
need to keep the data). I'm in a redesign phase and I'm trying to do it
right. So here are the relevant details:
The table has several keys involved:
mysql> desc data__ProcessedDataFrames;
++-
Ext3 fs on an emc SAN. Rhel 4 box with 4 cpus and tons of memory. I have
no problems with other types of files- only binlogs. I am using mostly
innodb tables.
It is a high load server but that's no excuse to corrupt all the binlogs
John Mancuso
Linux Administrator/MySQL DBA
IT Infrastructure
Ame
Dear sir or madam:
I'm totally new to mySQL and I have little pre-knowledge on database, could
anyone suggest a toutrial on mySQL which is suitable in my case, please? I
really appreciate any answer, very much!
Best Regards,
yours sincerely,
Weiqi
=
first you need to learn to spell tutorial.
On Jun 27, 2007, at 10:37 AM, Weiqi Wang wrote:
Dear sir or madam:
I'm totally new to mySQL and I have little pre-knowledge on
database, could anyone suggest a toutrial on mySQL which is
suitable in my case, please? I really appreciate any answe
Do you have any other applications which work the SAN as hard as MySQL
does? I"m not familiar with the EMC but have you run it through
through a stress test? I agree that load sohuldn't cause corruption
but, sad to say, in some cases it does. We have had similar
difficulties with certain SANs un
On 6/27/07, Dave G <[EMAIL PROTECTED]> wrote:
Queries on this table when it gets large is slow as molasses. I'm
thinking about making a new table for anything with a different test_id
any opinions as to whether this is good or bad?
Hi Dave G.,
We need to know how:
a)How large the tabl
Good Afternoon David
sounds as if you have a number of non-unique indices (even possibly FTS!)
slowing down queries..this should help you concentrate on the slower indices
mysql>
select TABLE_NAME,COLUMN_NAME,INDEX_NAME from INFORMATION_SCHEMA.STATISTICS
where NON_UNIQUE=1;
Anyone else?
Mart
I think I can do that:
I don't have any other indexes, just the keys.
mysql> show create table data__ProcessedDataFrames;
+---+--
Weiqi,
You might want to take a look at the book "MySQL Tutorial". It is in a second
edition and available from Amazon. In addition there are numerous guides
available on the Internet. Devshed (http://www.devshed.com/c/b/MySQL/) for
example has 90 articles on mysql. Of course many of them are
I ran mysqlbinlog --force and that spit it out:
# at 15873
#070626 13:07:43 server id 2 log_pos 15539 Query thread_id=85
exec_time=0 error_code=0
SET TIMESTAMP=1182877663;
@[EMAIL PROTECTED]@[EMAIL PROTECTED]@ [EMAIL PROTECTED]@[EMAIL
PROTECTED]@[EMAIL PROTECTED]
[EMAIL PROTECTED]@[EMA
I could be wrong.. but this is a guess..
event_type: 15 is update_rows_event which is used in mysql 5.1 and
later..
if mysqlbinlogs is an older version.. most likely it will produce an
error
because it does not recognize event_type 15 and is bombing out.
try it.
http://dev.mysql.com/doc
I do, but I don't see any way around that with the data I have.
Dave G.
> Good Afternoon David
>
> sounds as if you have a number of non-unique indices (even possibly FTS!)
> slowing down queries..this should help you concentrate on the slower
> indices
> mysql>
> select TABLE_NAME,COLUMN_NAME,IN
Hi Octavian,
First, thanks for helping out. I really appreciate it. Thanks to you also
Randall.
> I am not sure I understand what you want.
>
> If you want to search for all cds, and books, and dvds based on a certain
> criteria, you can use that method I've told you about.
Randall said it be
On 6/27/07, Dave G <[EMAIL PROTECTED]> wrote:
select payload_time,HEX(processed_data) from data__ProcessedDataFrames
where test_id=18 AND top_level_product_name="DataProduct" AND payload_time
> 11808.74704 AND payload_time < 1180564096.24967;
What I'm concerned about is with how much data I
Hello people.I would like to ask the following.Using greek character set and
collation i perform a
select-order by.But i get first the latin characters and then the greek
ones.Can i show first the
greek ones and then the latin?
Thank you in advance!
ps:moreover i would like to sort them in pairs
Weiqi,
You can use the mysql web site. It's the best first tutorial for anyone.
http://dev.mysql.com/doc/refman/5.1/en/index.html
I don't know if you are Chinese or Japanese but there is versions in
this two languages. Have fun and welcome to MySQL world!
Regards,
Ricardo Conrado Serafim
DBA J
I would wait until your DB is offline (such as on a weekend)
Once you find the Character Set you want e.g. greek_general_ci
http://dev.mysql.com/doc/refman/5.0/en/charset-se-me-sets.html
then alter your DB to use that character set
http://dev.mysql.com/doc/refman/5.0/en/charset-database.html
M--
At 09:37 AM 6/27/2007, Weiqi Wang wrote:
Dear sir or madam:
I'm totally new to mySQL and I have little pre-knowledge on database,
could anyone suggest a toutrial on mySQL which is suitable in my case,
please? I really appreciate any answer, very much!
Best Regards,
yours sincerely,
Weiqi
Yes it is a good idea to store in a table information about which other
tables should be searched.
I don't know how these queries can be made using only SQL. I think that it
could be made in the programming language you use.
For example, first get the list of tables that should be searched (
Hello sir and thanks for replying.
I'm have tried all greek collations.The fact is that when sorting i see first
the latin
characters(sorted) and then the greek ones(again sorted).I want to have a
choice.I mean i want to
see first the A latin and then the greek A.Then B latin and B greek etc.Or
I know there is a tool out there to grab the user info from the mysql database
and store it like versioning control. I thought it was in Baron's toolkit but
unless I have had too much caffeine and can't read I don't see it on his
website. What am I thinking of?
Thanks,
keith
--
B. Keith M
I think it was Baron's toolkit I was thinking of...
the command mysql-show-grants seems to do the trick.
Thanks,
Keith
- Original Message -
From: "B. Keith Murphy" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Wednesday, June 27, 2007 4:11:54 PM (GMT-0500) America/New_York
Subject: u
Hi,
I have an application that is using the MySQL HANDLER heavily. The
application was ported from a legacy ISAM database to use MySQL.
The upshot is that the application works by "index walking" - i.e.,
HANDLER tablename OPEN
HANDLER tablename OPEN as indexname
HANDLER indexname READ indexname
On Wed, Jun 27, 2007 at 01:27:24PM +1200, Ian Collins wrote:
> Are HANDLER queries cached in the query cache?
No, they are not. The query cache only caches the results of SELECT
statements.
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
That's quite a query. You may not be able to optimize it well with
those nested selects. You may want to think about changing your query
around a little, perhaps joining pieces of data using whatever
programming language you're using on the front end. You have MySQL
doing a lot of work and
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of systems, can you suggest
me an opensource solution ??
Thanks.
--
MySQL General Mailing List
Fo
On 6/27/07, Eddy D. Sanchez <[EMAIL PROTECTED]> wrote:
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of systems, can you suggest
me an opensource soluti
On 6/27/07, Eddy D. Sanchez <[EMAIL PROTECTED]> wrote:
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of systems, can you suggest
me an opensource soluti
David T. Ashley wrote:
On 6/27/07, Eddy D. Sanchez <[EMAIL PROTECTED]> wrote:
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of systems, can you suggest
Thanks, but there is no problem with copyright, I want scan and store
just internal documents from my enterprise
On 27 Jun 2007, at 21:48, David T. Ashley wrote:
On 6/27/07, Eddy D. Sanchez <[EMAIL PROTECTED]> wrote:
Hello Everyone.
I want to scan a large quantity of books and documents
MMM, yes, but I think that CMS isn't the solution, I want to store a
large amount of documents and organize it with best performance for
indexing, searching and viewing.
On 27 Jun 2007, at 22:57, Gary wrote:
David T. Ashley wrote:
On 6/27/07, Eddy D. Sanchez <[EMAIL PROTECTED]> wrote:
On Wed, 2007-06-27 at 20:07 -0400, Eddy D. Sanchez wrote:
> Hello Everyone.
>
> I want to scan a large quantity of books and documents and store
> these like images inside or outside a database, I want use mysql,
> anyone have any experience with this kind of systems, can you suggest
> me a
Hi All,
I have created a user and grant all previlages on all db and the user can
connect from any machine with in the same doiman.
Now, when i login from a mysql client machine, i am able to see all the
databases, but when i login directly from the mysql database server,
I am able to see only th
Thanks for your answer.
I'm searching an opensource project (based on mysql obviously) that I
can hack for my needs, but if I can't find anything, I must make one,
my intention for technology is:
-Java for application server and framework
-store all image on a file server or into database li
On Thu, 2007-06-28 at 01:50 -0400, Eddy D. Sanchez wrote:
> Thanks for your answer.
>
> I'm searching an opensource project (based on mysql obviously) that I
> can hack for my needs, but if I can't find anything, I must make one,
> my intention for technology is:
> -Java for application serve
41 matches
Mail list logo
