EcoBuntu.org

mysql> SELECT concat(table_schema,'.',table_name) table_name,concat(round(data_length/(1024*1024),2),'M') data_length FROM information_schema.TABLES ORDER BY data_length DESC LIMIT 10;

“The transaction log in database tempdb is almost full. Your transaction
is being suspended until space is made available in the log.”

If you are getting this error message you can extend tempdb running the following commands:

disk init name ="extra_tempdb", physname ="/opt/sybase/data/extra_tempdb", vdevno=8, size=512000
alter database tempdb on extra_tempdb = 500
alter database tempdb log on extra_tempdb = 500

mysqldump --opt --where="true LIMIT 1000000" mydb > mydb1M.sql

On 1 specific table:

mysqldump --opt --where="true LIMIT 1000000" mydb mytable > mydb_mytable_1M.sql

Restore:

mysql -p mydb_1 < mydb1M.sql

sqlplus user/password@db

SQL> set echo off
SQL> set feed off
SQL> set head off
SQL> spool analyze_tables.sql
SQL> select ‘analyze table ‘||table_name||’ compute statistics;’ from user_tables;
SQL> spool off
SQL> exit

sqlplus user/password@db @analyze_tables.sql

When SYBASE get started, the following call is made:

startserver -f RUN_MYINSTANCE

RUN_MYINSTANCE is located in $SYBASE_HOME/install.

1/ edit RUN_MYINSTANCE and add the following line, where the switches are:

-psa

2/ run startserver -f RUN_MYINSTANCE

During the boot phase you will see something like, e.g:
New SSO password for sa:uvwxyz

You can also see this message in Sybase logs.

3/ edit RUN_MYINSTANCE and remove the line you added in step 1/, so you do not reset it next time.

4/Set your own password:

isql -Usa -SMYINSTANCE (using ‘uvwxyz’ password)

>sp_password “uvwxyz”,”my_own_password”
>go

LOAD DATA LOCAL INFILE 'file.csv'
INTO TABLE my_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field_a, field_b, field_c, field_d);

Default value : 25

$isql -Usa -SMYINSTANCE

>sp_configure ‘user connections’, 100

No reboot is required since this option is dynamic.
Changing the value of ‘number of user connections’ to ’100′ increases the amount of memory ASE uses by 17740 K.

sp_configure – set db parameters

sp_dboption – set db options

sp_displaylogin – Show login details

sp_help object_name – Object definitions

sp_helpdb dbname – db info

sp_helpdevice - device info

sp_helpindex - index per table info

sp_helpprotect userid – Privileges info

sp_helpsegment – Monitor db sizing

sp_helptext stord_proc – Show stored procs code

sp_helpuser userid - User info

sp_spaceused – db sizing

sp_who userid – Users logged in info