Re: disk space on arbitrary rows

A very first thing you should do is to evaluate the storage needed by a single row. This can be done by summing up all columns data types length in bytes and index lenght as well. This should be quite accurate. Just a tip to start:

Re: REstricting MySQL access to port 3306

and in case it is feasible use a custom port to prevent specific attacks to mysql. All clients and application servers will need to connect to the new port. Claudio 2009/9/24 Willy sangpr...@gmail.com Limit connection from trusted host will reduce it. And its better handled by firewall .

Re: Data import problem with duplicate datasets

A very first thought I got is disable the constraint before import and re-enable after that. One way could be to set the foreign key checks to false or alter the constraint and remove the 'cascade delete' part. It's just a quick brain storm, please verify the goodness of it, I still need to get my

R: Thread Stack Overrun

I would take a look at bugs. An insert like that cant give any errors. I imagine it is a slave_sql thread bug. Claudio Il giorno 18 set, 2009 4:31 p., John Daisley j...@butterflysystems.co.uk ha scritto: We have a master slave replication setup with 3 slaves running off one master. The master

Re: Mysql dynamic database location

As far as I know, you can't, you can do it with symbolic linking but not at run time. So if you have a clue you can (pre)build empty databases using symbolic linking and switching to the right one at run time. Cheers Claudio Nanni 2009/9/18 Manasi Save manasi.s...@artificialmachines.com Hi

R: Re: Mysql dynamic database location

;* ++ | Tables_in_remotedb | ++ | a | ++ 1 row in set (0.00 sec) mysql Bye r...@soulcake-duck:/var/lib/mysql# On Fri, Sep 18, 2009 at 10:54 AM, Claudio Nanni claudio.na...@gmail.com wrote: As far as I know, you can't, you can do

R: RE: database design

Manageability. Id(surrogate) can be autoincrement so managed by the engine, Joins are simpler to write. Imagine a natural key composed of three or more fields. Practical, with surrogate you can 'book' a record while not knowing yet all of the values that compose the natural key. Just a couple of

Re: database design

A.J., It sounds good to me! You can be a little confused but you did it well, It seems you have all you need there. A) Yes B) select * from articles A left join article_types AT on A.article_type = AT.article_types_id Claudio 2009/9/11 AndrewJames andrewhu...@gmail.com This is a bit of a

Re: how to query this

This can also help: select id,value from table order by value desc limit 1; Cheers Claudio 2009/9/10 Slackli User slackliu...@gmail.com Thanks all the info. Just got what I wanted. 2009/9/10 Wolfgang Schaefer scha...@gmail.com: John Daisley schrieb: SELECT MAX(value), id FROM table

Re: Lost connection to MySQL server during query

Can you provide more details? network layout, type of client/app used, connectors,etc,etc? Thanks Claudio 2009/9/9 stutiredboy stutired...@gmail.com hi,all: we met a problem that: * Lost connection to MySQL server during query SHOW TABLE STATUS WHERE ENGINE='MyISAM' *sometimes it works

Re: Lost connection to MySQL server during query

/commits/9447 http://bugs.mysql.com/bug.php?id=15752 but, this bug has been fixed in 5.0.25 are there any suggestions ? or any other informaion (s) should i post here? thanks! stutiredboy Claudio Nanni wrote: Can you provide more details? network layout, type of client/app used

Re: how to get the time of the client in sleep status

mysqladmin processlist -v or mysql show processlist; Cheers Claudio 2009/9/4 stutiredboy stutired...@gmail.com hi,all can i get how long the client(s) in sleep staus after the client connected to mysql server how can i do it ? thanks very much tiredboy -- MySQL General

Re: Fail to change MySQL data directory on ubuntu

2009/8/26 chen jia chen.1...@gmail.com Hi there, I am using MySQL on ubuntu 8.04. I followed this link http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive to change the data directory of MySQL. After stopping MySQL: sudo

R: Re: recovery help needed

When you are in without the flag , issue the following: Select current_user(); It should return root. Then do this: Grant all privileges on *.* 'root'@'%' identified by 'letmein' It should work If you did not mess too much with grant tables. Claudio Il giorno 26 ago, 2009 4:36 m., Todd Lyons

storage upgrade in a replication cluster

All, I would appreciate some valuable ideas from you all. I have a replication setup with 1 master and 4 slaves, I am short on disk space on all the 5 servers so I will move to another partition (SAN). What is, according to you, the smoothest way to move all 5 servers from one partition to

storage upgrade in a replication cluster

All, I would appreciate some valuable ideas from you all. I have a replication setup with 1 master and 4 slaves, I am short on disk space on all the 5 servers so I will move to another partition (SAN). What is, according to you, the smoothest way to move all 5 servers from one partition to

R: Re: Replication, Stored Proceedures and Databases

You dont have changes coming from db G since it is ignored from replication. Why dont You move all stored procs in a separate db and replicate it as well? You will use it as a 'library' for all of your dbs. Of course prepose your schema name, always. You dont have to change replication type in

R: how to get the timestamp from remote mysql

When you are using SQL connected to the server (mysql -ublah) the timestamp is the server one. If you use app time functions it will be client time. Bottom line: use server sql functions. Ciao Claudio Il giorno 4 lug, 2009 8:50 m., Nathan Huang nathan.vorbei.t...@gmail.com ha scritto: Hi guys I

Re: Why is MySQL using /tmp?

Yes it is used for temporary tables. You can also set the directory for temporary tables to some bigger partition. Cheers Claudio 2009/6/11 Amr Mostafa amr.most...@gmail.com If I understand the manual correctly, it uses /tmp for creating temporary tables if their size exceed the smaller of

Re: GRANT and ticks or no ticks...

2009/5/27 Daevid Vincent dae...@daevid.com Wondering which of these will work or not? (no quotes) GRANT ALL PRIVILEGES ON mydb.mytable TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; (backticks) GRANT ALL PRIVILEGES ON `mydb`.`mytable` TO 'user'@'10.10.10.%' IDENTIFIED BY

Re: Logging SQL queries

Enable mysql SQL logging in the configuration file. [mysqld] log Cheers Claudio 2009/5/27 Tompkins Neil neil.tompk...@googlemail.com Hi, We've developed a new extranet system and feel that we need to record all queries performed. What is the best / recommended way to achieve this.

Re: service terminating

Hi, aren't there any other clues before restarting? 2009/5/20 Duane Hebert duane.heb...@group-upc.com I'm having a problem where every day or so, the mysql service is restarting. This is MySql 5 running on a win2003 server. The error in the event log says: Faulting application

Re: mySQL slave IO Running and SQL Running

Yeah Daevid! I know very well the issue! first set the slave to READ ONLY [mysqld] read-only then there is a configuration option to tell the server to skip some type of errors automatically slave-skip-errors=

Re: Upgrade Mysql

I already posted about this: http://lists.mysql.com/mysql/215100 or google for moving from 3.23.58 to 5.0.45 I never recommend to install mysql as default package, is way too limiting. I manage to have as many mysql installations on the same server as the hardware can carry, but not software

Re: How to copy an statement in Mysql console

History (Arrow Up/Down) COPY: Select (click + drag)PASTE: right click (or middle click) 2009/5/15 jean claude babin babi...@gmail.com Hello, I'm pretty new in MySql. I would like to know how you can copy a statement like mysql INSERT INTO customers ( firstname, surname, title, phone)

Re: Password Reset Not Working

It is important to understand deeply mysql client access control. Basically you need only one root account from the localhost for administration purposes. Keep in mind that when you login specifying 'localhost' (either by the -h flag or implicit) MySQL will use the mysql client socket

Re: Password Reset Not Working

! Claudio Carlos Williams wrote: On Fri, May 15, 2009 at 3:57 PM, Claudio Nanni claudio.na...@gmail.com wrote: I don't know if you are now more ore less confused! Claudio I would say less because you basically explained that I need to have localhost 127.0.0.1. Now my problem

Re: Question on replication terminology

Hi there, I would only like to stress that the only supported (and recommended) replication solution in MySQL is Master---Slave replication. In this scenario you can have ONLY one master and (virtually) any number of slaves. There is NO other safe replication solution. The terms you mention

Re: A good US Hosting Site?

www.awardspace.com I have both free and paid hosting and it is really really good, it has a lot of tools. Claudio 2009/4/20 Pete Wilson pete...@yahoo.com http://www.kionic.com I've been a very active and heavy customer for years and very satisfied. -- Pete Wilson

Re: A good US Hosting Site?

Well, not a joke for free hosting. But it is, for me, by far the best hosting site. Compleat, easy to use, five subdomains, and also mysql included. Paid hosting is outstanding. Cheers Claudio 2009/4/20 Mark ad...@asarian-host.net -Original Message- From: Claudio Nanni

Re: Sun bought by Oracle

We are talking of financial moves here. I think nothing will be touched at least for first years, I don't see product or services overlapping. Oracle is one thing, MySQL another. If they are so crazy to 'shut-down' MySQL, the second after there would be the fork, MySQL could be 'closed', but

Re: A good US Hosting Site?

Mark wrote: Yeah, but a Maximum file size limit 500 KB, what can you do with that?? Your average background image is bigger! Not to mention my MySQL really? you use background images bigger than 500kb? lucky if you get a second visit! mysql database of course has nothing to do with that

Re: the way to get more info in logs

seems like there is a problem of consistency of innodb data and recovery does not go well. try to take a look at innodb status: show engine innodb status http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html http://dev.mysql.com/doc/refman/5.0/en/innodb-monitors.html Cheers

Re: Recommend a tool for editing data

I use http://www.dadabik.org/ since many years, I find it simply great. I do not know if it is exactly what you need, but give it a try! Claudio Andrey Dmitriev wrote: Dear List, Can someone recommend a web based tool for mass-editing tables in excel like fashion? Preferably view-based (can

Re: Client Programs

included on the gui tools ( http://dev.mysql.com/downloads/gui-tools/5.0.html). I don't know exactly how to extract only the mysql command line client from the server installation, probably you would need the binary and some libs. Sorry for not being accurate Claudio Nanni 2009/4/13 Manish Gupta

Re: find records with only numbers

Hi, this can be easily solved by using regular expressions. select field1 as f from table1 t where t.f regexp '[0-9]{6}' Cheers Claudio Nanni Ed Reed wrote: I hope someone can give me a suggestion on this. I'd like to find records in a table where a specific field only contains a number

Re: find records with only numbers

He is looking only for six digit numbers. select field1 as f from table1 t where t.f regexp '^[0-9]{6}$' does the job Claudio Pinter Tibor wrote: Ed Reed wrote: I hope someone can give me a suggestion on this. I'd like to find records in a table where a specific field only contains a

Re: Total logged in time

Just a hint: Given the user 'User' and given no missing login/logout event logging you can retrieve the total amount in seconds he was logged on with the following formula: SELECT (SELECT SUM(time_to_sec(time_stamp)) as logoutTime from logevents where event='logout' and userid='User' ) -

Re: Mysql High load CPU

','read_buffer_size','read_rnd_buffer_size', so their total size will be [threads_connected * (size of all per connection buffers)] Cheers Claudio our maximum users connections are about 400 simultaneous users On Wed, Apr 1, 2009 at 12:14 AM, Claudio Nanni claudio.na...@gmail.com

Re: Mysql High load CPU

Hi, probably your system is swapping on disk, immediately reduce the sort_buffer_size, it is a per connection buffer, and your setting is way too high: sort_buffer_size=1000M (with 8 client threads you finish your ram) set it to something between 256K and 8 M sort_buffer_size=1M also

Re: IN vs. OR on performance

An explain of the two statements yields the same plan, anybody knows if they are actually translated in the same plan? Claudio Ian P. Christian wrote: 2009/3/29 Oscar ro4...@gmail.com: Hi all- I want to know what the difference between IN and OR is under the hood. select * from

Re: SOLVED: Re: Foreign Key Issue

I had the same problem and was going crazy, the ket/foreign key fields must be exactly the same. I 'forward' engineered the database with MySQL Workbench and was almost posting a bug! Cheers Claudio 2009/3/26 John Daisley john.dais...@mypostoffice.co.uk Sorry all, I was being a dummy!

Re: A problem relative ibdata1

You can't! it is part of the datafiles of InnoDB storage engine! and It contains important data like the information schema. So I would rather ask you, is it abnormally growing or is it just your feeling? You should be more precise to have good answers, for instance how much megabytes per

Re: A problem relative ibdata1

of queries... however do you know if there is an engine that support/manage foreign key? I use innodb for this reason.. but the size of ibdata1 is a problem :'( Thanks for ur reply Il giorno 26/mar/09, alle ore 12:30, Claudio Nanni ha scritto: You can't! it is part of the datafiles

Re: Replication Issues

Hi Dirk, it seems that the information about binary files on the master contained in the mysql-bin.index does not match the actual files on the disk. The first two log messages are just info on the slave starting the two replication threads, the other two seem to be a message coming from the

Re: Re: learning mysql

Hi, I think in your case you should go for a traditional book approach to build a good background. In my opinion finding the right book is a matter of match between the kind of book and your background. My hint is to gather here 4/5 good book titles, go in a book shop take a while to run

Re: if there're a tool which can replace mysql-proxy?

Question: my company tried the mysql-proxy about one year ago(may be more) but could not use it for not being multithreaded. They say they spoke to the 'mysql-proxy' developer. Is this still true? Are there any limitation on using mysql proxy on a high load production server? Will it be

Re: if there're a tool which can replace mysql-proxy?

and Diego Medina, Quality Assurance Engineer @ Sun who will be talking about Proxy in general, but also some advanced topics. Thanks, -- Jimmy Mark Matthews wrote: On Mar 24, 2009, at 8:06 AM, Claudio Nanni wrote: Question: Hello Claudio, my company tried the mysql-proxy about

Re: Mysql eat a huge amount of memory

post the my.cnf and the output from 'SHOW STATUS' Claudio Tadeu Alves wrote: Hi there guys, latelly our server is suffering from a very big memory eat problem, when i start mysql it goes with about 2GB of memory, but about 20h-30h later the server is eating about 8GB, this is a huge problem

Re: Upgrading MySQL from 5.0 to 5.1

What I always did since 3.23 upwards is new installation and import. My tecnique allows me to install as many mysql instances as I want, I always use specific user, homedir, datadir, my.cnf, for each installation. In this way I can have theoretically unlimited number of mysql instances on one

Re: MySQL General Discussion question

Hi Rich, I believe that since they are definitely considered as strings they are sorted as such, how can you pretend that '#2 NOV' is considered as a number? If you cannot define a rule in the structure of the data it is impossible to sort, not only in sql, but in life! IF we take for granted

Re: why is this happening?

I am afraid you have two mysql instances up on the same host. ps -ef | grep mysql ? Claudio Jim Lyons wrote: I have a rather odd problem with a replication slave. The slave has been down for a number of hours. Of course, both io and sql threads are stopped - from SHOW SLAVE STATUS:

Re: how can I make a stored procedure executable by public?

Hello Jim, If I unserstand well your needs the steps you need to do are: Create one user X with insert privileges on the mydb.audit_table Create the stored procedure specifying the user X both in the DEFINER section and in the SQL_SECURITY section of the create procedure statement (

Re: JOB: linux sysadmin with good mysql skills [thin k really mysql dba] - LOCATION: reading, berkshire, england , uk - SALARY: £40k-£55k at least!

Gentelemen, this is my opinion. This is not a list for job posting, there are specific sites for that. If we consider useful a 'private' list for job postings we can ask a new one. I understand every thing about the need of a job but it can be done in a better way, I use this list to solve

Re: how can I make a stored procedure executable by public?

called. The genral log logs original calls to procedures, but I don't see that it records calls made to one procedure from within another. On Wed, Mar 18, 2009 at 6:42 AM, Claudio Nanni claudio.na...@gmail.com mailto:claudio.na...@gmail.com wrote: Hello Jim, If I unserstand well your

Re: InnoDB - CREATE INDEX - Locks table for too long

Hi, I am using your procedure on MyISAM tables now and works but RENAME does not work with locked tables, (anyway it is already an atomic operation) =BARON Try something like this: create table new_table like old_table; alter table new_table add

Re: avoiding use of Nulls (was: The = operator)

that he invented the things we are talking about (http://en.wikipedia.org/wiki/Edgar_F._Codd) Cheers Claudio Nanni

Re: avoiding use of Nulls (was: The = operator)

Hi everybody I want to join as well. But hypothetically speaking, what value would you use if you didn't have a I don't what this is value like null? I ask this because I started programming when NULL was really zero, and part of the ASCII collating sequence. NULL was zero I'd use

Re: Replica questions

If you are finding replication stops after a reboot then I think you have a serious problem, but don't know what that might be. Post some more info and someone on the list can probably help, just a 'skip-slave-start' in my.cnf does the trick. 2 Is there a way to get a slave to

Re: mysqlimport remote host problem

zcat /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql.gz | mysql -h 192.168.0.224 -u root -p alba2 Cheers Claudio 2009/3/11 Rob Wultsch wult...@gmail.com On Tue, Mar 10, 2009 at 7:16 PM, René Fournier m...@renefournier.com wrote: OK, I've managed to do the same thing with just the

Re: using a subquery/self-join to recursively retrieve a tree

as you say you need recursion to build the tree from the table. if you are interested just in all the employees that are not manager with their manager info. select * from emp e1 inner join emp e2 on e1.uidman=e2.uid; cheers Claudio 2009/3/10 Ali, Saqib docbook@gmail.com Hello, I

Re: mysql behaviour

is in the syslog file but here I didnt find any errors. I will cofigure an exclusive log file for the slow connections and the errors. Thank you very much for your help. best regards, Miguel On Tue, 2009-03-10 at 00:41 +0100, Claudio Nanni wrote: I do not know how debian works, but in any

Re: mysql behaviour

Here is a very interesting reading for you! http://dev.mysql.com/doc/refman/5.0/en/table-cache.html Claudio 2009/3/8 Miguel m...@moviquity.com Hello, I wanted to know how mysql behaves when accessing to its tables. I have check the file descriptors and I could see different MYI and MYD

Re: mysql behaviour

Open tables: 64 Queries per second avg: 109.676 I am trying to optimize a django project. I am not familiar with this framework but it seems it has a very very bad performance. Is it not normal the above results, isn't it? On Mon, 2009-03-09 at 14:00 +0100, Claudio Nanni wrote: Here

Re: mysql behaviour

... Is it normal to keep the tables opened? and have so many queries per second? and what about the slow queries? thank you very much, Miguel On Mon, 2009-03-09 at 18:31 +0100, Claudio Nanni wrote: It is really not enough for me to give an opinion but I do not see anything strange, what is your

Re: mysql behaviour

Still everything is relative, Aborted clients seems high but it could be just a Django problem (does not close correctly connections), can you tail some 100 lines from the mysql error log? Miguel wrote: On Mon, 2009-03-09 at 22:37 +0100, Miguel wrote: as you say, it is not a fact. I m trying

Re: mysql behaviour

, the server has not an exclusive error log. It is not configure. It says: Error logging goes to syslog. This is a Debian improvement :) but I can not see anything clear in syslog. On Mon, 2009-03-09 at 23:20 +0100, Claudio Nanni wrote: uld be just a Django problem (does not close correctly

MySQL Binary Log Summary Tool

All Lately I am struggling with big tables maintenance, I've just made a very quick and dirty tool for having summaries from the binary log files, like how many times a table was updated, or inserted or deleted. Before going any further I would really appreciate your opinion to know if there

MySQL Binary Log Summary Tool - w/link!

All Lately I am struggling with big tables maintenance, I've just made a very quick and dirty tool for having summaries from the binary log files, like how many times a table was updated, or inserted or deleted. Before going any further I would really appreciate your opinion to know if there

Re: Enumerate MySQL Servers?

If you are designing a microsoft windows software to connect to MySQL servers the easiest way to create connections is to use the ODBC Drivers provided by mysql ( http://dev.mysql.com/downloads/connector/odbc/5.1.html). Once installed the drivers you will have to create the (System) Data Source

Re: MyISAM large tables and indexes managing problems

Hi Baron, I need to try some trick like that, a sort of offline index building. Luckily I have a slave on that is basically a backup server. Tomorrow I am going to play more with the dude. Do you think that there would be any improvement in converting the table to InnoDB forcing to use multiple

Re: MyISAM large tables and indexes managing problems

Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM : RolandoLogicWorx Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: Friday, February 27, 2009 4:43 PM To: mysql@lists.mysql.com

Re: MyISAM large tables and indexes managing problems

the query instead of killing MySQL? use show processlist to get the query id, then kill it. You may already know that. Brent On Fri, Feb 27, 2009 at 5:25 PM, Claudio Nanni claudio.na...@gmail.com wrote: Great Brent, helps a lot! it is very good to know your experience. I will speak

Re: Monitoring MySQL availability

We monitor hundreds of production systems with Nagios, of any kind. I dont have time to search for better ones, but this is doing its job. Cheers Claudio 2009/2/27 Éric Fournier eric.fourn...@cspq.gouv.qc.ca Hi everybody , I'm searching for a good way to

MyISAM large tables and indexes managing problems

partition because it was filling the / 100%. MySQL is 5.0.x on 64bit RHEL 5 with 16GB RAM and NAS storage. Any hint on how to manage big tables? Thanks Claudio Nanni

Re: MyISAM large tables and indexes managing problems

set of tables to query on (i.e. current_month). Of course, this means splitting your table into separate tables based on a certain criteria. Basically, divide and conquer. Hope that helps. Brent Baisley On Fri, Feb 27, 2009 at 4:42 PM, Claudio Nanni claudio.na...@gmail.com wrote: Hi, I have one

Re: catch the error [OFF TOPIC]

professional list on MySQL, let's keep it on MySQL. Phil, this is my humble opinion. Regards, Claudio Nanni PJ wrote: What is wrond with this file? same identical insert works from console but not from this file :-( html head titleUntitled/title /head body ? //include (lib/db1.php

Re: Upgrade story / request for insight

compare and test both of them, provided you are using different 'sockets', that is different PORT if just using TCP/IP connection method. Cheers Claudio Nanni 2009/2/25 Jerry Schwartz jschwa...@the-infoshop.com My ultimate goal is to upgrade a production server (MySQL 4.1.22 on CentOS

Re: left joins concat

certain rows, ok now you use the WHERE. Forget about CONCAT/CONCAT_WS this is a string function, and is not related to JOINS. Please, let me know if this was useful to you. Claudio Nanni 2009/2/22 PJ af.gour...@videotron.ca I have been searching and searching for a clear and logical

Re: moving data to MySQL

\MyDb.ldf' Regards, Haidong Alex Ji http://www.HaidongJi.com/tech On Sat, Feb 21, 2009 at 5:48 PM, Claudio Nanni claudio.na...@gmail.comwrote: Hi, Using ODBC Drivers and MS Access you can do the job. This is a quick list of steps(if you need more in depth just ask): Download ODBC drivers

Re: book categories

already know, dont focus on CONCAT, forget it for now. Let me know Claudio Nanni 2009/2/22 PJ af.gour...@videotron.ca Here's a tough one... In my library I have some 62 categories where a number of books can be in several categories. Now, to relate the categories table(AS c) to the book

Re: InnoDB - CREATE INDEX - Locks table for too long

, but updates where queued. In my case, if I do this between 2:00am and 4:00am , I can at first try the single insert READ locked, and if I have problems I will switch to your solution, What do you think? Thanks! Claudio Baron Schwartz wrote: Hi! On Thu, Feb 19, 2009 at 2:14 PM, Claudio Nanni

Re: moving data to MySQL

Tools-ODBC Data Sources) Create a System Data Source Name that point to the MSSQL database (Control Panel-Administration Tools-ODBC Data Sources) Using Microsoft Access you can import-export-query the tables as you like. Cheers Claudio Nanni 2009/2/21 Chris Rehm ch...@javadisciple.com I want

InnoDB - CREATE INDEX - Locks table for too long

I need to add an index on a table on a production server. It is one 7Gb InnoDB table with single .ibd file (one_file_per_table), the index creation on preprod server took 40 minutes but table was smaller. I tried to add the index but was locking all applications on production and had to kill it.

Re: When will MySQL support array datatype?

Complex datatypes are not compatible with the concept of relational databases, probably you want to refer to an Object-Oriented DBMS or Object-Relational DBMS. Cheers Claudio Nanni Moon's Father wrote: Hi. Who could tell me when the MySQL support array datatype? Any reply

Re: Re: Re: MySQL 5.1.31 PostInstall Script Error

My pleasure, Bunti! let me know if you need any help, I worked ten years on Sun Solaris, and six of these with a rambling MySQL on it, I always compiled my MySQL release, and enjoyed so much Solaris, it is the most stable operating system I ever worked with, very good choice! Cheers Claudio

Re: Re: MySQL 5.1.31 PostInstall Script Error

The only thing I can tell you is you are using 64bit package instead of the 32bit one. Issue this /usr/bin/isainfo –kv and see if you have 32 or 64 bit architecture os. In case download the right one! Solaris 8 (SPARC, 32-bit) Cheers Claudio 2009/2/9 bunti bunti1...@cooltoad.com Yes

Re: MySQL View

Steven, I would suggest you the reading of a basic book about SQL and Databases, I explain you why. Views are a very fundamental concept in database theory that you would love to study in deep. This mailing list, though the most professional on MySQL, is not suitable to explain such basic and

Re: MySQL 5.1.31 PostInstall Script Error

Hi, I just try to guess because you don't post much information about your platform. My impression is that you are using the wrong binaries, probably after the common copy procedure of the solaris package manager the post installation script is the first package-related program. From what I see

Instance scale-out

I succesfully install multiple instances on the same host since many years (good old 3.23), my rule of the game is: different os user, different os user homedir, different my.cnf (with different port/socket) and start the server ecluding the possibility to read other than its own my.cnf with

Re: Instance scale-out

Hi John, So according to this interpretation a port IS a network interface, it means that I have thousands of network interfaces on my servers? I never thought of a port as a network interface, I always thought of it as an attribute(address of an application on the host) of the tcp/ip protocol,

Re: Instance scale-out

John, I don't want to argue too much on this but I'd also like the opinion of the big heads in MySQL I think there's no grey area here. An interface is an interface and can be of any type and supporting any protocol(TCP/IP on ethernet card, UDP idem. DSL on WAN card, PPP on POTS modem) A port is

Re: Instance scale-out

First to help people join the discussion, the guilty paragraph of certification study guide 42.1 -- Each server must have its own network interfaces, including the TCP/IP port, the named

Re: WHERE vs. ON

2009/2/4 Baron Schwartz ba...@xaprb.com On Tue, Feb 3, 2009 at 12:24 PM, Jerry Schwartz jschwa...@the-infoshop.com wrote: Somebody, I think it was somebody from MySQL, said that you should never put anything into a WHERE clause that could be put into the ON clause of a JOIN. My guess is

Re: ERROR 1010 (HY000): Error dropping database (can't rmdir ./foobar

that way, though - for that you really do need to shut down the db and unmount the disk. On Fri, Jan 30, 2009 at 7:29 PM, Claudio Nanni claudio.na...@gmail.com mailto:claudio.na...@gmail.com wrote: I am banging my head. First, is not a file permission problem. I cant import data

Re: questions about merging

Robert, keep the two databases separated, that is on different mysql database (or schema as they are also called). If the wordpress blog is on a database named 'wpblog' for example import your dump in another newly created database. Could just use those statement in the dump file CREATE

ERROR 1010 (HY000): Error dropping database (can't rmdir ./foobar

I am banging my head. First, is not a file permission problem. I cant import data on some replication slaves either in binary, or from a sql mysqldump. I use one innodb file per table and I am importing only two databases on a dozen. After a few hours seem that the problem is with the name of

Re: ERROR 1010 (HY000): Error dropping database (can't rmdir ./foobar

tables with read lock, then mount -oremount,ro and then fsck - that'll keep your db up for reads, at least. DON'T let fsck fix things that way, though - for that you really do need to shut down the db and unmount the disk. On Fri, Jan 30, 2009 at 7:29 PM, Claudio Nanni claudio.na...@gmail.com

Re: Help with formatting of 1:n relationship

I think what you are looking for is something like this: - SELECT CONCAT(A.FIELD1,',',GROUP_CONCAT(B.FIELD2)) FROM TABLE1 A LEFT JOIN TABLE2 B ON A.ID=B.ID_TABLE1

Re: Mysqld fails to start

JD, please post the ouput from: ls -altr /var/lib/mysql thanks Claudio JD wrote: Deamon runs as root. ls -ld /var/lib/mysql/ drwxr-xr-x 5 mysql mysql 4096 2009-01-27 10:00 /var/lib/mysql/ So what other perms does root need? Andy Shellam wrote: Hi JD, I believe the error about

<    1   2   3   4   >