[Pentium10]

We want it back too. This move was ridiculous .

[Pentium10]

'peterlaursen' wrote:

Well ..

You can do from the table (context) menu .. ALTER TABLE. You may change the charset for individual columns (clcik the option to 'show language options') or from ALTER TABLE .. advanced if you want to change the default charset of a table (but changing the defaut charset for a table- or a database for that sake – does not change the encoding of existing columns).

Please also read this FAQ: http://webyog.com/faq/content/34/152/en/my-special

-characters-display-as-_noisy_-latin-characters-in-sqlyog.html

i was looking for a mass operation.

[Pentium10]

'peterlaursen' wrote:

The idea to first process the current database context is a good request really. Our developer team will check how easy it can be done.

Can you post this request also in the Google Issues?

[Pentium10]

'peterlaursen' wrote:

1) The SQLite databases use by autocomplete are built on a per-connection basis. Do you need access to all databases from same connection? Note that in the SQLyog 'connection manager' you can specify specific databases only. That will result in much smaller local databases and

2) Can you find the 'Tags' folder in your user profilesqlyog folder. How big is the biggest file in here?

3) I don't understand why it should stop/time out. Do you use (HTTP- or SSH-)tunnel?

4) We are just executing simple SHOW statements (SHOW DATABASES, SHOW TABLES LIKE 'base_table' etc.) to get the meta information inserted to lcoal database. We cannot reduce the load from that. And querying I_S will cause similar (or higher on some mySQL versions) load. I wonder how well you server is configured? This article is probably the best entry point http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ (though maybe with MySQL 5.5 it may not be quite up to date).

1. I don't need access to all databases, probably need access to 50, I will try to list the number of databases I need. I will post back the findings.

2. One file is very big: 100 MB, more precisely 104,878,080 bytes others are at 1MB

3. I am connecting on a gigabit network inside the building (no tunneling)

4. Server is configured well as it handles so much trafic on all those database, it's a super machine. When I stop SQLYog the load goes down below 0.8

How much work would be to priorities parsing expanded/use(d)/favorited objects first?

Update: I've tried listing a couple of databases in the connection wizard, and now it is much faster and works better, and stored functions names are used in autohint. Thanks for this tip. Could I request to put this in your FAQ.

I got this working now, but there are other questions in this thread, so please keep discussing on that and we should not close for now.

[Pentium10]

Sorry I was using the wrong terminology. I meant Stored Procedures/Functions.

[Pentium10]

'vishal.pr' wrote:

@Pentium10,

Can you rebuild the tag files and try. To rebuild tags, in main menu goto Powertools->Rebuild tags.

Regards,

Vishal P.R

That says there Stop Rebuilding Tags for a while. I have a huge system with over 1030 databases.

I think you should improve the order of that thread a bit.

So it should queue in front, with higher priority the databases that are expanded/use(d)/favorited in the object browser first.

Anyway does that some kind of local caching?

Or whenever I open a new connection it tries to build the tags? That will take hours on a large database system like I have, so I can't use SQLYog for hours until the tags are not finished. That is not acceptable, and for example our admin users will ban me because I do a lot of load on the system by having so many connections open for hours and doing heavy stuff like schema readings.

Further more I see a lot of processes after I start SQLYog that are very slow: SHOW CREATE TABLE …….., and all these are making a huge load on the database because for each column MySQL checks permissions, so runs a query on: information_schema`.`COLUMNS`

And the order there is in alphabetic order, and there is no priority on the parsed databases, which is totally WRONG, as it will take down my database.

See the heavy load on the server and the time the connection are kept open (10 minutes and only got parsed until databases with letter F)

http://screencast.com/t/yhrIXaBGH

It queries tables that are never used in the GUI.

Update: The build tags did not finished, it timed out after 1 hour. And only half of the database tables were processed.

Update: I've tried this on a server where only a few database are, and the stored procedures/functions are not tagged, and rebuild tags does not help, and they are not included in the hint.

[Pentium10]

You have a couple of ways to get the UDF parameters:

1. For MySQL 5.5 use the new information_schema.PARAMETERS table

http://dev.mysql.com/doc/refman/5.5/en/parameters-table.html

2. For older version when you have access to database `mysql` use `mysql`.`proc` table:

select name,param_list from `mysql`.`proc`; // this returns all parameters for procedure/function for ALL databases (you don't need to query separately for database, you query once for server

there is also a `mysql`.`procs_priv` that you need to use.

Read page: 823+ from here:

Beginning PHP and MySQL: from novice to professional By W. Jason Gilmore

http://books.google.com/books?id=6tJAdlzjFJ0C&pg=PA823&lpg=PA823&dq=procs_priv&source=bl&ots=1i9l0rakXw&sig=bKS6Fq6mk2OETkKjsvoteUgD64g&hl=en&ei=aC9MTuidN8rt-gbd0MGWCQ&sa=X&oi=book_result&ct=result&resnum=10&ved=0CF0Q6AEwCQ#v=onepage&q=procs_priv&f=false

[Pentium10]

'peterlaursen' wrote:

Autocomplete is supposed to work in the editor and nowhere else. Not hat htis is a bad request. it is just technically completey hopeless to implement.

That area is not an editor? I think that is also a place where I edit the data. If you fix the others this might be be so important as you say.

[Pentium10]

'peterlaursen' wrote:

We will not fix this.

There is no fix requested here. I just want to know where are the delete buttons, to be able to moderate myself in case I do duplicate posts.

[Pentium10]

'peterlaursen' wrote:

Plase moderate yourself.

This is a duplicate.

I didn't find the delete button, so excuse me. Please show me the delete post/thread button location.

[Pentium10]

'peterlaursen' wrote:

We never promised this! Autocomplete supports MySQL built-in functions, but not UDF's nor Stored Functions etc..

This observation/request is OK, but I tell that is very little chance that this will be changed. I)t would be very expensive and involves passing SHOW CREATE FUNTCION for each Stored Function at connection time.

You are already fetching the function name to list the Object browser at beginning. At that time you would need to run a thread to get also the parameters name from the information schema.

http://dev.mysql.com/doc/refman/5.5/en/parameters-table.html

This would add tremendous value to SQLYog and certain apps have this functionality, so I think it's time to implement it.

We bought today Ultimate SQLYog today mainly for this purpose, and we see missing stuff.

[Pentium10]

Ok cool, I will fill a feature request for it.

[Author]

Posts