missing data after partitioning an existing table

I know a couple of things, but table partitioning isn't one of them. i have a 35 GB sized table which is causing performance issues, my research came across partitioning, which is what i tried and failed with today. i tried altering the table, that kept going for 2 hours with absolutely no

RE: missing data after partitioning an existing table

: t...@stuxnet.org To: mysql@lists.mysql.com Subject: Re: missing data after partitioning an existing table Hi there, Le 23/05/2014 21:06, Roland RoLaNd a écrit : [...] Ouch This post is somewhat ... unreadable ! Please format ! Christophe. -- MySQL General Mailing

RE: missing data after partitioning an existing table

table Hi there, Le 23/05/2014 21:06, Roland RoLaNd a écrit : [...] Ouch This post is somewhat ... unreadable ! Please format ! Christophe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql

Database lock on mysql import - Information

Dear all, I realize this is a very newbie question so bear with me please. I know that when you import/export a DB its tables are locked to ensure consistency and no data corruption. but why would other DBs on the same server get locked if im importing/exporting one DB ? in other words:

Best practice to minimize DB server performance effect (large query)

Dear all,I have a task to anonymize data in 82000 record (for the time being)i've tested my script against about 30 of them, and it takes about 2.4 sec for each query to be executed. i'm seeking help with the following: - what's the best way to run such a script without affecting the DB

Re: Best practice to minimize DB server performance effect (large query)

i agree it wouldn't cause trouble, though it might lock mysql as there's a number of other databases running on the same server. so performance is an issue even if it's just a CPU/RAM peak. On 5/31/12 11:23 AM, Reindl Harald wrote: Am 31.05.2012 09:13, schrieb Roland RoLaNd: Dear all,I

killing mysqldump

Is it safe to kill a mysqldump while it's in process ? i mean aside loosing the dumped file, would it affect the running DB being dumped? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: max() can't work

, there is a simpler and more efficient solution: select * from table_name order by movid desc limit 1. I hope this helps. Best regards Roland Kaber armando wrote: the field movid is type integer or varchar ? 2010/2/6 tech list bluetm...@gmail.com select * from table_name where movid = max(movid); why

Re: MySQL Date problem

. --rama Hi What about using the STR_TO_DATE function to transform the java Date as a MySQL Date: STR_TO_DATE('19/10/2008', '%m/%d/%Y')? To transform this back into the original format, you may use the DATE_FORMAT function: DATE_FORMAT('2008-10-19', '%d/%m/%Y). Best regards Roland

Erro 1406 Data too long

book pro. * I issued the same statements to a MySQL server on a Windows XP machine. The problem simply didn't occur even in traditional sql mode. Do you understand what is going on? Could it be a bug? Thank you in advance for any help you can offer. Roland K

Re: Erro 1406 Data too long

character set to utf-8 2. keeping the latin 1 character set and changing the INSERT as follows: INSERT INTO text_t (t) VALUES (ASCII(169)) So, thank very much you for your excellent suggestion. Roland Jerry Schwartz wrote: It is a character set conflict between the source of the data

Re: Erro 1406 Data too long

In the INSERT, I used the CHAR function, rather than the ASCII, sorry for the mistake. Thanks again Roland Roland Kaber wrote: It looks like it is really a character set conflict. The copyright character © is ascii 169 and is part of latin-1. However, there is a similar character, (C

Re: result set on prepared statements

cursor. Because when using classic functions instead of prepared statements, I really must fetch *all* rows to avoid memory leak on database engine. With best regards, Roland. Visolve DB Team schrieb am 17.10.2006 07:57: Hi, Hope this link will be useful: http://mirrors.sunsite.dk/mysql/doc

result set on prepared statements

Information is welcome. With best regards, Roland. | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL:2003 standard

Hello Peng, please have a look at http://www.wiscorp.com/SQLStandards.html There you can download all you need. With best regards, Roland. Peter Brawley wrote on 10.05.2006 16:51: Peng Yi-fan wrote: Hi, It seems that ISO do not support SQL:2003 standard for free but I really need

MyISAM Key Buffer and Key Writes

will blocks in key buffer be written to disk? -- mit freundlichen Grüßen - Roland Wilczek Moltkestraße 90 50859 Köln Tel.  : 02234 / 91 75 05 Fax   : 01212-5-382-69-201 E-Mail: [EMAIL PROTECTED] http://www.sales1x1.de - Vertrieb und Projektmanagement http://www.web-appz.de - Programmierung und Web

move to 64 bit

Hi! What must I do to move our mysql-database from 32-bit binaries to 64-bit (mac os x). Is it as simple as just changing binaries for must I prepare the data-files somehow? Thanks in advance Roland Carlsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Find the biggest blobs

Hi! I've need to find the largest blobs in a table but I seem not to be able to figure out what it is. Could anyone please help me with this? Regards Roland -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Backup for 24/5 system

to a backup that we can take down whenever we need to to make the backups (or other maintaince). So, is this a good way to solve the backups or do you think that I should consider any other solutions? Thanks in advance Roland -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Ini (cnf) file location

very much Roland Carlsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

flush and flush delay

?) for maximum performance? Thanks for any help. Regards, Roland. -- -I have not failed. I've just found 10,000 ways that won't work. -(Thomas Alva Edison 1847-1931) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: flush and flush delay

in mysql have the path to the data directory on the RAM-disk as the datadir? Would there be any advice on how to set up the tables for maximum performance given the usage specifications as described in the earlier mail? Regards, Roland On Sunday 17 October 2004 17:50, Michael Stassen wrote

connecting over TCP

connect to MySQL server on 'xxx.xxx.xxx.xxx' (10060). I have checked the firewall settings and port 3306 is open. What might I be doing wrong? Thanks in advance. Regards, Roland -- -I have not failed. I've just found 10,000 ways that won't work. -(Thomas Alva Edison 1847-1931) -- MySQL General

connecting via TCP/IP

'@'%' as well as localhost. I can ping the server so the network connection is fine etc. Do I need some option to be able to supply the host as an IP address to the mysql call? Thanks again. Regards. Roland -- -I have not failed. I've just found 10,000 ways that won't work. -(Thomas Alva Edison 1847

reduced installation

the files that are strictly necessary. Eg without any documentation etc. Could someone tell me which files are absolutely necessary and which files and directories I can afford to ommit? Thanks in advance. Regards, Roland -- -I have not failed. I've just found 10,000 ways that won't work

mysql embedded with TCP support

and writing take place in volatile memory instead of accessing the HD every time? Regards and thanks in advance for all replies. Roland. -- -I have not failed. I've just found 10,000 ways that won't work. -(Thomas Alva Edison 1847-1931) -- MySQL General Mailing List For list archives: http

MySQL and dates before 1000-01-01

the above method of storing dates, can anyone see any potential gotchas/pitfalls? Alternatively, is there a better method which I could use? TIA for your time and help. Regards, Roland

three highest and lowest column values

Hello, from the following Product-table ProductId MarketId CustomerId Type Price ... i would like to get the three highest and lowest prices for each group of ProductId,MarketId Type. How could i do that ??? Many thanks in advance roland

three highest and lowest column values

Hello, from the following Product-table ProductId MarketId CustomerId Type Price ... i would like to get the three highest and lowest prices for each group of ProductId,MarketId Type. How could i do that ??? Many thanks in advance roland

Embedded MySQL?

run a standalone server in my program. Now I wonder how this works in practise? Ideally I want to call an API in a dll-file to create and maintain the database. /Roland --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.462 / Virus

Large resultset

missunderstood what setFetchSize does? I use J/Connector 3.0.6 Regards Roland Carlsson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Large resultset

there is anything funny there. I have tried with a couple of fetchsizes ( 5, 50, 500 ) but it doesn't seem to do any difference. I also tested with TYPE_FORWARD_ONLY with no luck. Thanks in advance Roland Carlsson - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED

Re: Large resultset

it automatically gets the next portion. Thanks roland Carlsson - Original Message - From: Rusch (ext) Reiner [EMAIL PROTECTED] To: 'Roland Carlsson' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 12:59 PM Subject: AW: Large resultset Hi, why don't you try to solve the problem

Re: Large resultset

Thanks, that solved the problem. I thought that I could have my own fetch-size but I has now understood that Integer.MIN_VALUE is the only size that is accepted. Regards Roland Carlsson - Original Message - From: Mark Matthews [EMAIL PROTECTED] To: Roland Carlsson [EMAIL PROTECTED] Cc

Problem with Win XP / Powerbuilder

I have encountered a problem regarding MySQL / ODBC ! I have an application written in PB6.5 and running in Windows XP Home Edition. There is an error generated while updating to MySQL table: Row Changed Between Retrieve and Update. I tried to move the application to Windows 98 and it worked

Re: Datentypen

Leider kann ich diese nicht in der Doku finden. how in the world did you manage to miss that one? http://www.mysql.com/doc/en/Column_types.html Regards Roland - Before posting, please check: http://www.mysql.com

Re: mysql_install_db script: can't find it

, this script is in the folder /scripts in the source code. On Windows OS the Binary does automatically install the Privilege Tables. Best regards, Roland - Before posting, please check: http://www.mysql.com/manual.php (the manual

Store pictures in DB

Can I use MySQL to store pictures as part of a record? Should I just try to store the name of the picture? Thanks for any help Roland Perez [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Re: Mysql 3.23.51 on Solaris

Connection Failed 2003 - Cannot Connect to MySQL server on 10.1.1.95 (10061) Hi, it seems that the MySQL Server is not running. Try to start the server. Best regards, Roland -- [EMAIL PROTECTED] - Before posting

Format of doubles in queries(feature request)

think so. But it would save other programmers a lot of work. The way it is now, each application programmer has to program his own conversion, or use the single-quotes trick. Thanks for your attention, Roland - Before posting

Re: JDBC: Losing precision when mapping doubles from Java

://www.thenetsquad.com/services/jdbcsupport.html Roland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

JDBC: Losing precision when mapping doubles from Java

Hello, I'm losing precision when I send a double to a mysql database from a Java program trough JDBC. Code: stmt.setDouble(i+3,((Double)value).doubleValue()); I use a prepared statement. Now, if I print out the double in java before sending it to the MySql database this is what it looks

Re: JDBC: Losing precision when mapping doubles from Java

Hi, Roland Try my JDBC Driver. http://www.t3-jpn.com/jdbc/jdbcmysql.html http://www.t3-jpn.com/jdbc/download/gweMysqlJDBC_extra3.zip Thanks. Hello, thanks for the quick answer. Your page has a link to: http://www.gwe.co.uk/ which is not working. Is there some information

JDBC: Losing precision when mapping doubles from Java

Hello, I'm losing precision when I send a double to a mysql database from a Java program trough JDBC. Code: stmt.setDouble(i+3,((Double)value).doubleValue()); I use a prepared statement. Now, if I print out the double in java before sending it to the MySql database this is what it looks like:

Can't connect to source

message. UNABLE TO CONNECT TO SOURCE “MYTEST” – “S1000” –“[TCX][MyODBC] Access Denied for user: ‘@MAILSERVER’ To database ‘roland’” – 0414 I then reset the link to the test database, and tried again, this worked fine. Do I need to setup something else on the server so I can access the database

lower_case_table_name has no effect on Linux

for a table fails. mysql select * from GRU; ERROR 1146: Table 'rg.GRU' doesn't exist Does anybody know why? Roland Geist mailto:[EMAIL PROTECTED] Developer http://www.openshop.com - Before posting, please

TIMESTAMP

Hi everybody, I am new to the list so if my question was answered recently I do apologize but I could not find the answer neither in the archive or the manual. Problem: I try to load data into a table using LOAD DATA LOCAL INFILE. Into a table containing a TIMESTAMP(14) field. The loading